Hi Everyone
I have a task where I have to create named set calculated members. They will be used as an enhancement to some dimensions as unique groupings. They need to be flexible and dynamic (we are using sql 2008) to be able to apply to multiple different measures.
I am trying to come up with with best way to go about creating some of these sets. For example, they want all the decedents of a product type, except 2 of the members. Another example is a full set of members from one product type plus the members of another product type minus certain members.
Is there a way to subtract a named set from a set? Or am I looking at combinations of the except(), intersect() and Union() functions.
This is my first day back to MDX after 2 years and I'm a little rusty... any help is appreciated.
Thanks!