-
Monarch Automation & License error
Hello, I'm trying to automate Monarch from Microsoft Access (MS 365 Apps for enterprise) using the attached VBA example code. When I try to run the program, I get an error message that says license error (see pic). What could be causing this and how do I fix it? Thanks, Andy
-
Altair Monarch 2023 contact
Description: need to connect with an Altair resource Product/Topic Name : Altair Monarch 2023 *Note from Community Team - Once you receive a satisfactory answer on your question, kindly mark your answers as "Accepted" so it can help others with similar problems. Thanks. We are in the process of moving our Finance &…
-
How can I aggregate or group monetary transactions on the next business day
I need to find a way to group or aggregate transaction amounts done on Saturday, and Sunday (or on a holiday) to show their total on the next business day, usually Monday. I have a list of transactions by account number and I need to aggregate the transaction totals for each business day, grouping them by date seems easy…
-
Upcoming Altair Community Events - Join Us!
Hi Everyone, We have some exciting sessions lined up for August and the rest of the year. New sessions are also added to the exciting Power Conversion and Magnetic Chat series. Register Now! Summary of our Upcoming Events: MotionView/MotionSolve 2025.1 for Vehicle Dynamics [ August 27] - Learn about the latest advancements…
-
Monarch command line .bat file error
Description: I'm having a problem moving from Monarch 14 to Monarch 15. My command prompt .bat files work fine in version 14 but when I try to run them for version 15 I get an error message which says "Product successfully licensed" and then it exits without executing the script. Has anyone else seens this and have any…
-
Altair Monarch - Summary respecting line position of original database
Good afternoon all, We have a requirement to create a Monarch project where the summary should be different than the usual one when creating our posting files for SAP. In this case, we have an original database (excel) where the key value are provided in column A. These key values can be shown as consecutive way or in very…
-
Monarch 2025 failing to install SQL Server 2019 LocalDB
I am trying to install Monarch 2025 and it is currently failing to install SQL Server 2019 LocalDB. Prior to this it was failing to install Visual C++ 2015-2022 Redistributable. I fixed this by manually installing this myself. However, I cannot find an installation of SQL Server 2019 LocalDB. What are my solutions?
-
Monarch for Asset Based Lending
Financial Analysts working in the Asset Based Lending (ABL) Industry are responsible for assessing the value of the assets that their business customers will provide as collateral. Popular assets for ABL are Inventory and Accounts Receivables. However, gathering this data and loading it into leasing software for analysis…
-
Monarch for Fiserv DNA User Group 07-16-25
Review of new workspaces for ATM Recon and GL vs DNA Trials. https://fast.wistia.net/embed/iframe/p631wygxtx?web_component=true&seo=true&videoFoam=false
-
Monarch Classic- how to capture business days between two dates?
i am trying to capture the number of business days between two dates in monarch classic, but there is no macro for this. as a work around i have been using age(date1,date2,4)/7*5. So this will take the number of days between the two, divide out the number of approximate weeks then multiply times 5 days per week. hoping…
-
Monarch Server - Rights & Privileges
Quick review of the rights and privileges in Monarch Server. https://fast.wistia.net/embed/iframe/8cx6xx2ayf?web_component=true&seo=true&videoFoam=false
-
Automating Data Prep Studio using Excel Macros
I have developed many automated processes using Monarch COM auto where complex solutions involving integration of Monarch with Excel macros, remote systems interface (such as AS400, file servers, etc.), and other disparate systems. Is the same possible with Monarch Data Prep Studio (DPS)? Simply said, can DPS workspace(s)…
-
What's New in Monarch 2025? | Ask The Expert Monarch Webinar Series
Join our Ask The Expert webinar to learn about the new features in Altair Monarch's latest 2025 Version, followed by a live Q&A. Expert: Steve Caiels, Senior Professional Services Consultant MC: Rebecca Cronin, Manager Customers Success Recorded on June 17, 2025…
-
Exercise#41: FIS TSYS (TS2) TSAD0553 Reject Analysis
Exercise Info Application (Classic vs Data Prep Studio): Data Prep Studio Level of Difficulty (Beginner, Intermediate, Advanced): Beginner Skills/Features Tested: Report Templates, Group By, Join Systems of Record: FIS TSYS (TS2) Estimated Time to Solve: 10 mins Exercise files required are attached Below; TSAD0553 Reject…
-
Monarch for Fiserv DNA - Trials vs Prologue Recon
Fiserv DNA Banks & Credit Union customers need to perform reconciliation between their various Trials (Deposit, Loans) against Prologue (Financial General Ledgers) This is a critical process for balancing general ledgers for financial reporting and integrity. The new version of Monarch, Data Prep Studio, helps Fiserv DNA…
-
Monarch for Fiserv DNA - ATM Reconciliation
Fiserv DNA Banks & Credit Union customers need to perform daily reconciliation between their 'Switch' Platform for processing Electronic Funds Transfers (typically Debit Card & ATM Transactions) against their core banking process. This is a critical process to balancing general ledgers for financial reporting and…
-
Exercise#40: ICE Mortgage MSP P-181 Analysis
Exercise Info Application (Classic vs Data Prep Studio): Data Prep Studio Level of Difficulty (Beginner, Intermediate, Advanced): Beginner Skills/Features Tested: Report Templates, Filter, Duplicate, Join Systems of Record: ICE Mortgage Black Knight MSP Estimated Time to Solve: 10 mins Exercise files required are attached…
-
Altair is a 2X Leader in the 2025 Gartner® Magic Quadrant™ for Data Science and Machine Learning
We are pleased to share that Altair have been recognized as Leaders for the 2nd year in a row in the Gartner(r) Magic Quadrant(tm) for Data Science and Machine Learning Platforms! In the words of Altair CTO Sam Mahalingham: 'We think being recognized as a Leader for the second consecutive year further validates Altair’s…
-
RegEx Trapping in Altair Monarch | Ask The Expert Monarch Webinar Series
Join our Ask The Expert webinar to learn about RegEx Trapping in Altair Monarch, followed by a live Q&A. Expert: Chris Porthouse, Senior Professional Services Consultant MC: Rebecca Cronin, Manager Customers Success Recorded on May 20, 2025…
-
Monarch issue
I used Monarch 2022 to convert the text file into .DBF format but I got an error message. I am doing this process fine monthly until I got new laptop. Please help fixing this issue. Thanks
-
Monarch Data Prep Studio - Change History - Edit this column change Inquiry
Description: Wanted to know why that some rows of the change history allow itself to be edited but some other rows cannot be. Also wonder if the edit button is the only way to modify an existing change without having to roll all the way back to the row I want to modify. Product/Topic Name : Monarch Data Prep Studio *Note…
-
How do licenses drop off and what is this error?
Hi, I'm IT support and I have some users in my building that use Monarch. I wanted to verify how licenses drop off from users and also why a user would have multiple licenses checked out a time? The other issue is this error that appeared for one of my users. I'd appreciate any information or help as I have never used this…
-
Report Redactions | Ask The Expert Monarch Webinar Series
Join our Ask The Expert webinar to learn about Report Redaction in Monarch Complete, followed by a live Q&A. Expert: Steve Caiels, Senior Professional Services Consultant MC: Rebecca Cronin, Manager Customers Success Recorded on March 28, 2023…
-
Sorts and Filters on Exports | Ask The Expert Monarch Webinar Series
Join our Ask The Expert webinar to learn about Sorting and Filtering in Monarch Complete. This session covers data manipulation before exports in Monarch Data Prep Studio, followed by a live Q&A. Expert: Steve Caiels, Senior Professional Services Consultant MC: Rebecca Cronin, Manager Customers Success Recorded on April…
-
Replacing Data Sources | Ask The Expert Monarch Webinar Series
Join our Ask The Expert webinar to learn about replacing data sources in Monarch Complete. This session also covers Monarch Server connection definitions, followed by a live Q&A. Expert: Chris Porthouse, Senior Professional Services Consultant MC: Rebecca Cronin, Manager Customers Success Recorded on May 9, 2023…
