Member Properties

Hi

How to create a member properties in AS 2005?

Regards

In AS 2005 (SSAS2005) it is the same as attribute hierarchies. All attributes in a dimension table no longer have to be included in a user hierarchy.

If you run the dimension wizard and turn off the autocreate hierarchies you will get a dimension without hierarchies which is the same as member properties in AS2000. Or , if you use this feature(autocreate) you will get user hierarchies(the same as dimensions in AS2000) and attribute hierarchies(the same as member properties).

Still the word member properties is sometimes used for attribute relations. But this is not the same as in AS2000.

HTH

Thomas Ivarsson

|||

Actually member properties are not synonimous to the attribute hierarchies.

To model member property for particlar attribute in your dimension, you create a new attribute and than relate it to the original one.
Then you should disable attribute hierarchy, this way it wouldnt clutter your nice multidimensional model.
Once you've processed you should be able to get information from the new attribute by referring to it as memeber property from the original attribute member.

As you think of it, in many cases you have many attributes in dimension related to the key attribute. That means key attribute of the dimension. Or better say, members of the dimension key attribute have many member properties. It is good practice to disable attribute hierchies for the attributes you can access as member properties.

HTH.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Interesting answere Edward. I refer to member properties in a general BI design way. If so you can say that member properties are attributes that do not form a natural hierarchy, like the color of a product. In this case the attribute hierarchies will qualify as member properties.

You can use an attribute as a member property, in the way you describe it, only to sort another attribute and without showing it in the dimension.

If I show an attribute as an informative box on another attribute or as an attribute hierarchy is really not that important. I can show color as an information box on the leaf members in the product dimension or I can combine the attribute hierarchy color with a product user hierarchy and show this on an axis.

But thank's for the information anyway.

Regards

Thomas Ivarsson