CUBESET function for non-consecutive members

**David Laplante** · 05-06-2010, 10:21 AM

My first post !

Hello everyone.

I have seen many, many examples around the web about the cubeset function but none of them mention how one would go about selecting anything else than [Dimension].[Member].children.

Through trial an error, I managed to get only a few members of a dimension but these seem to need to be consecutive members in the cube dimension. I acheived this using this function:

=CUBESET("Local Stream Cube","[Transaction Type].[By Transaction Category].[All].[Capital Item].[TX]:[Transaction Type].[By Transaction Category].[All].[Capital Item].[WTAX]","Tax")

This returns 3 members because between the member [TX] and the member [WTAX], there is also a 3 member.

Now let's say I wanted to ONLY return [TX] and [WTAX] in that cubeset. What would be the set expression to use ?

I'm very suprised I haven't found this anywhere on the net.

Thanks !

**DP978** · 05-06-2010, 08:49 PM

=CUBESET("Local Stream Cube","{[Transaction Type].[By Transaction Category].[All].[Capital Item].[TX],[Transaction Type].[By Transaction Category].[All].[Capital Item].[WTAX]}","Tax")

A colon creates a range between the first and last values. Use the squigly brackets to denote a set.