Modifying the report source from SAP to MS SQL Server

Hi All,

We had intially developed some reports using SAP Infocube(SAP Orders universe). We now want to source the same reports from MS SQL Server 2008(MS Orders universe)

When I change the universe in the query panel, all the features like scope of analysis, subqueries etc that were disabled with the SAP universe(because a SAP Infocube based universe does not support these features) remain disabled when the source is changed to MS Orders universe too. Kindly check attachment for a snapshot.

If I create a new report based on the MS SQL universe all the features are enabled.
I dont want to re-create all the reports. If there is way to enable the features after flipping the universe it would be a great help. Pls advice

Thanks
Meena
snapshot.zip (29.0 KB)


meenaj (BOB member since 2005-01-12)