All,

Is it possible to set static member properties for different levels of a
dimension?

For example --

Level 0 Member Property = "A"
Level 1 Member Property = "B"
Leaf Member Property = "C"

Any ideas??
Thanks

Absolutely. If you look at FoodMart, you will see examples of leaf level
member properties for the Customer dimension, but you will see folders at
the upper levels. You could have a field which contain something like City
Size, or something like that.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Jim_OLAP" <JimOLAP (AT) discussions (DOT) microsoft.com> wrote

Yes with "normal" dimensions but I don't think you can do it with a parent
child dimension.

"Jim_OLAP" <JimOLAP (AT) discussions (DOT) microsoft.com> wrote