I have leaf level members of a dimension which contain 1 member property.
How do I create a set that contains the value in the property?


Product (parent)
(child) - Product1.properties("prop1") = "P"
(child) - Product2.properties("prop1") = "S"
(child) - Product3.properties("prop1") = "M"

I want to create a set that contains {"P","S","M"}




Thanks
Justin

Maybe the (undocumented?) MDX function: CreateProptySet() can help you.
Here is a SQL Server Mag article:

http://www.winnetmag.com/SQLServer/A...302/16302.html
the real power of CreatePropertySet() is its ability to determine the
unique values of a member property within a group of dimension members.
If you needed to determine the unique member-property values and you
didn't have the CreatePropertySet() function, you would have to retrieve
the member-property values for all the relevant dimension members and
eliminate all the duplicates. This process can be very slow if you have
many dimension members. CreatePropertySet() quickly determines this list
of unique properties, but the rest of the execution can be
time-consuming. To take advantage of the function's speed, you need to
understand how Analysis Services processes MDX queries.
...

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thanks. This should do the trick.

Justin

Deepak Puri <deepak_puri (AT) progressive (DOT) com> wrote