MDX with multiple dimensions potential named set
Posted on 2011-02-23
i want to create a named set where i have a set of dimensions which i want to include but a set of dimensions i want to exclude at the same time when applied to a measure.
So for example, If i had codes 1-10 as one dimension (CodeGroup) , and product codes 1-1000 for another dimension (ProductCode)
And we are dealing with sales dollars:
I want to be able to create a named set, which includes CodeGroup 1,
CodeGroup 2 but not ProductCode 221
how could i do this in a named set. and how would i code to exlude a product code for a given codegroup (as per above)
I think i have to use exists, and i'm guessing something like a join that i need to make to make the named set work.
Is there something like not exists?