Point Analysis Studio report to a different cube

[redmist]

Hi

Does anyone know how to point an Analysis studio report to a different cube. I'm on  Version 8.4.
Here is the scenario...
I have cube name xxx from which i created a Report xxx. Now i acrhive the cube and name to xxx_Jan10 and refresh the xxx with new data. How do i use Report xxx with xxx_Jan10. If it change the report properties to point to this new package the report breaks

With the client version this was just a matter of selecting which cube to use as the source.
In 8.4 it is looking for the MUN names and this is dependent on the datasource name so archiving the cube with the same name xxx also does not work.
For eg: i could create a folder Jan10 and acrhive the cube with the same name xxx but this also gives an error since the datasource name used to publish this is different.

thanks

[Filip.Cuppens]

Hi,

cannot you create a second connection for the data source ? The first connection pointing to the 'live' cube, and a second connection pointing to the archive cube ? When a user runs the cube report he will be asked to select the connection to use.

Regards

Filip

[redmist]

Filip

I have archived the cube by creating a second datasource connection. The problem is when the report is created it stores the MUN's and the MUN's take into account the Datasource name and not the cube name

Eg:
Datasource name for the main cube: datasource1
the report created off this has [datasource1].[Period]......

Thanks for the response

[redmist]

anyone with more ideas!!

Thanks

[MFGF]

Hi,

If you're building member-based analyses (which is the default), the MUNs are stored in the report which will then break if the cube names or structures change.

You refer to the fact that the Client version did allow cubes to be changed - but there has never been a client version of Analysis Studio, so I'm guessing you are referring to PowerPlay client?  If so, this is an entirely different product, which used PPDS or PPES to connect to the cube, so it's not really comparable.

Without resorting to the SDK to code a routine to interrogate the cube and the report XML and fix any discrepancies, you're not going to be able to do this, sorry.

MF.

[redmist]

Thank You MF !!