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 !