Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sets and Measures, MDX

Status
Not open for further replies.

Barrps

MIS
Mar 28, 2002
1
US
I have a measure that I want to display across all children of a particular level. No problem there.
However, I want to treat 8 particular children as individuals, but all others as an entity.

I started my MDX by declaring a set that is all children of the level, except those 8 particular children I want named expicitly.

What I was thinking of was an alias, as I know it in SQL.
Can I turn my Set into such an alias, so that I see the result for all but the eight as one column?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top