You’re offline. This is a read only version of the page.
345
Hello,
I'm still working on issues that have arisen when we pushed SP2. Right now I'm trying to get Management Reporter to generate reports. In most case the reports will generate, but in at least one case the row definitions have had their links to financial dimensions disappear completely.
My IT department is working on putting a backup of the machine up and so worst case I can manually reproduce those links.
I'm wondering if Management Reporter actually stores the row definitions to files somewhere on the machine and I just haven't found them yet.
*This post is locked for comments
I understand. I still believe it would be possible to make a backup of the current Management Reporter database, restore a backup of that same database before the problem occurred, open the row definition for the affected report, copy that into Excel, restore the current backup, open the bad row definition and paste the Excel rows back into the current row definition over the bad definitions. It depends on how many rows are involved and whether this effort would save time over just redefining the rows.
If you are brave and comfortable with SQL you could also restore the older Management Report database to an alternate database name and create an update query to update various rows in the active database table with data from the alternate database. Again, it is a questions as to which gets the issue resolved quicker.
Management Reporter stores all of the report definitions in a SQL database named MangementReporter. The row definitions are stored in a table named ControlRowDetail and ControlRowCriteria. There are several other tables that handle the linkage to catalogs and such so you need to be careful if picking and choosing various tables to restore. You might be best off to restore the entire ManagementReporter database from a recent backup but be advised that you will loose any database changes related to Management Reporter changes since that backup.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (