Is it possible to edit the Metadata or otherwise do some sort of global find and replace of the underlying code of a Cafe report ?
We have an environment where eventually in PROD we will have a report over an "work" cube - Only managers can see it, and the data can be changed as they run iterations of their monthly process. Once the managers "approve" the data, we create an IDENTICAL cube that is a SNAPSHOT of the "work" cube. This snap shot is then accessible to many, many users for reporting.
SO we have some CAFE reports that managers use over the Work cube , and want to duplicate these over the Snapshot Cube for the hundreds of Users.
There must be a way.
What about migrating from DEV to PROD? Must be a way to change duplicate the Cafe Report and update data source ?
Thank you
We have an environment where eventually in PROD we will have a report over an "work" cube - Only managers can see it, and the data can be changed as they run iterations of their monthly process. Once the managers "approve" the data, we create an IDENTICAL cube that is a SNAPSHOT of the "work" cube. This snap shot is then accessible to many, many users for reporting.
SO we have some CAFE reports that managers use over the Work cube , and want to duplicate these over the Snapshot Cube for the hundreds of Users.
There must be a way.
What about migrating from DEV to PROD? Must be a way to change duplicate the Cafe Report and update data source ?
Thank you