|
toulon83
United Kingdom
7 Posts |
 Posted - 08/25/2005 : 08:20:07
|
I have had the same problem when going from Dev to Live environment where we had to change:
- from Server name Dev_OLAP to Live_OLAP
- from database RELIAB_DEV to RELIAB_LIVE
- from cube RELIABCUBE_DEV to RELIABCUBE_LIVE
i had 70 reports to amend with the changes above, in the edit report schema box !!!
i tried running a mass T-SQL update in Report table in ReportPortal database, but some of the report schemas were stored as long text and this failed so i still had to go into Edit Report Schema and manually change every definition.
A piece of advice therefore, don't have any specific Dev or QA type of names for the server, database or cube names, as it will be a nightmare when moving to production.
Another glinch we cam accross was when removing a dimension from a cube or a measure, the report schemas had to be edited manually as well as those were mentioned in the report schema in hard mdx code.
Rgds
Frederic
Rgds
Frederic |
 |
|
Report Portal
OLAP Database name change
