Role Playing dimensions Currency Conversion issue

Hi,

Having issues with Currency Conversion in SSAS when using role playing dimensions of Time.

When the Dim Usage in the cube is set for the role playing dimensions,
i.e. defining the relation between the Exchange rate fact and the role playing time dims.
the base $ measures (no calculations) return a null value.

The generated conversion script in Calculations has leaves(Time), not the leaves for each role playing dim.
With leaves for each along with leaves(time), the base measures return null.

Regards

does ssas 2005 currency conversion work when using the linkmember function in calculations.

Role based Attribute Hierarchy Visible

Hi,

Is it possible with SQL Server 2005 Standard Edition to set the Attribute Hierarchy Visible property based on a SSAS role? For example the role finance can see some Attribute Hierarchies and the role Sales can't see those hierarchies.

Thanks,

Marc

You can create pespectives. There you can choose what you want to have in any Role based Dimension.

|||

Ok, but that is only an Enterprise edition feature. We use standard edition.

Thanks.