| T O P I C R E V I E W |
| n/a |
Posted - 08/17/2005 : 19:05:18
It has been necessary to change the name of an OLAP database that is the source for a number of Report Portal OLAP reports. Is it possible to change the connection definition of an exisitng OLAP report or must each report be redefined?
Cheers
Ryan |
| 3 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 08/28/2005 : 21:24:53
So would you think that a "search and replace" (all reports of a given type) kind of functionality might be useful? |
| toulon83 |
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 |
| admin |
Posted - 08/18/2005 : 18:24:36
You can change the connection definition of a report by going to:
Admin > Edit Report Schema.
|
Report Portal
