Below is a simplified (denormalized) view of our data:
Transaction Customer Currency Value
S001 A USD 100
S002 A EUR 200
S003 A USD 100
S004 B EUR 50
S005 B USD 50
Is there a way to 'hide' the Currency(All) dimension. At the moment the data is summarised across all currencies, which doesn't make sense. For example, if you look at the cross-tab below, USD and EUR values should not be additive:
USD EUR Currency(All)
A 200 200 400
B 50 50 100
Customer(All) 250 250 500
Thanks
Hi,
I don't know of any way to hide the "All" level created for each hierarchy in DMR. One possible alternative option is to go to the properties of each of your measures in the Measure Dimension, and use the "Aggregate Rules" property for each to set the aggregation to something other than sum in your Currency dimension.
Cheers!
MF.
You can also just hide the 'Currency(all)' column which is actually the Total column.
What you are asking is possible if you make a Transformer Cube because it lets you make a cube with 'External Rollup'. What that means is that you can disable the rollup within Transformer and provide the rollup from the Data Source. That way , the value that corresponds to the total of the Dimension can be set to 0 while the values for levels would still be aggregated, so the crosstab you have will show 0 in the column 'Currency (all)' while values for USD and EUR would still be shown