Calculated dimension members in CA

[SqMan]

I have a simple cube with a "scenario" dimension, e.g. "Budget" and "Actual". I want to create a calculated member for the scenario dimension, Budget - Actual.

Here is my question -- if I create this calculated member in Crystal Analysis, everything works fine. But if I create the exact same calculated member in MS Analysis Services (I'm using SQL Server), Crystal Analysis will not even open the cube. I get a very general error message about a possible corrupt cube. It is clearly the calculated member which causes this, because if I remove it, then Crystal Analysis can open the cube just fine.

I can create a calculated measure in Analysis Services, and Crystal handles this just fine. It seems the problem is with calculated dimension members.

There are business reasons why I prefer the calculated dimension to be in the cube definition, and not in the Crystal Analysis CAR file. Also, I don't want to add the "Budget-Actual" scenario to the fact or dimension tables.

Is this just a capability that Crystal Analysis does not support, or am I doing something dumb in my set up? Has anyone included calculated dimension members defined in Analysis Services in their CA reports?

Thanks in advance, and sorry for the long exposition.

SqMan

 

[OliverS]

Hi SqMan,

I tried this with one of the sample cubes from Crystal and it seemed to work fine in CAPro 8.5 (the Version dimension in the Sales Reports cube). Can you open the cube with some other tool like the MDX Sample App?

Oliver

 

[SqMan]

Oliver,

Thank you for the reply. I have been able to open the cube (with the calculated dimension member) using Excel pivot table service.

I will try a sample Crystal cube. Also, I am still using v8.0, so maybe that is the problem as well.

Thanks again.