Home > SSAS > SSAS – Attribute properties

SSAS – Attribute properties

Recently, I have involved in a conversation on SSAS hierarchies properties.
I always feel the development of SSAS cube depends on the selection of properties options with respect to the source data.
I would like to document one property to avoid the end-user ambiguity while analysing the cube using Adventure works cube.
Step 1: The initial attribute properties setup on the solution as (MemberWithData = NonLeafDataVisible)

Step 2: Process the dimension and the process succeeded as

Step 3: Browse the dimension and select the Employees Hierarchy and the parent data appearing in the child records as shown below. The repetitive data in the hierarchy level makes the ambiguity to the end users

Step 4: Change the attribute property as (MemberWithData = NonLeafDataHidden)

Step 5: Process the dimension to deploy the changes as

Step 6: Browse the dimension employee hierarchy and the child ambiguity data has been hidden so to get the accurate parent child related data to the end-user as

Points to consider:
1. I have presented only a particular property of the dimension apart from many of the implemented properties.
2. I would like the present all the attribute properties as a series in future posts

Categories: SSAS Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: