Friday, March 30, 2012

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.

No comments:

Post a Comment