How to create hidden levels?

[camjai]

In Transformer I would like to use a unique level to associate other levels in a dimension to my data sources. However this level is purely a unique productcode that is of no use to my end users. Is there a way to hide this level so that it won't show up in the Powerplay report?

thanks.

 

[drlex]

You could create a dimension view and summarize the level above the unique product code. Change the cube properties to show this view.
(Note: not yet checked in 7.3)

soi la, soi carre

 

[camjai]

thanks for the tip drlex. I've looked up "dimension views" in Transformer help and I'm sure this is what I'm looking for.

 

[drlex]

No worries; post back here if you get into any problems.

soi la, soi carre