• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Solution Set for Reports - Report ID?

 1 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
George Graham
Veteran Member
Posts: 201
Veteran Member
8/24/2011 2:47 AM
How is anyone else handling this:

Report is created on test LBI and validate by users. Report is attached to a dashboard - therefore the link in the dashboard has the ID of the report in the URL.

The desire is to be able to make test and prod LBI identical - and utilize automated procedures to migrate stuff from test to prod. But when creating a solution set from test and then loading it on prod, when the report is loaded on prod it loads it as a new report with new ID. So for new reports that means that the dashboards between servers now do not match - and if the report was an existing report the solutions set would not update the existing report.

Anyone else syncing up a test and prod LBI?
Ruma Malhotra
Veteran Member
Posts: 412
Veteran Member
8/24/2011 3:26 PM
I have come across the same situation and I was told that the report ids in both test and prod will always be different and there is no way both the systems will have the same ids unless you publish each and every report at the same time on both systems at the same time.

There is also no way to sync both ids on both systems since these ids are system generated. The only way out is if there is in the test system to point to the LBI reporting tables in prod where all the report ids are stores in these tables.