Hide a dimension's "All" level

[apache]

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

[MFGF]

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.

[Steve]

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