Cube filtering

[thabrane]

Hello
I am creating multiple cubes from the same model.
I would like to create one cube which automatically filters to a certain level in a dimension when it is open. I also do not want this dimension to be available for further filtering.
Is there any way to specify this within the cube?

Any help would be greatly appreciated

Thanks

 

[GJParker]

This is a non starter

Gary Parker
Systems Support Analyst
Manchester, England

 

[drlex]

Depends on how you want to filter the cube.

I've done something similar with a couple of models by way of duplicating a dimension and adding filters by user class to the duplicated dimension in the form of an apex on the level required.

Exclude this duplicated dimension from all other cubes so that is only referenced in the 'filter' cube (which naturally excludes the original dimension).

lex

soi la, soi carre