July 13, 2010 at 4:28 am
Hello,
I'm using SSAS 2008.
I'm trying to display a single value for two levels of attributes hierarchies, when their values are identical. I've used the property RootMemberIf for that matter, with no success.
These are my tables in use:
The table Dim_Customer as displayed in the SQL:
Customer_Key___Customer_Name_____Flag
_____1_____________Dan___________True
_____2_____________Lisa___________False
_____3_____________David__________False
_____4_____________Noah__________True
The Flag indicates whether the record is a known one by the user (when Flag=False), or unknown (when Flag=True)
The table Dim_Customer created by a named query at the data source view stage:
Customer_Key___Customer_Name___Customer_Name_Group
____1_______________Dan______________UNKNOWN
____2_______________Lisa______________Lisa
____3_______________David_____________David
____4_______________Noah_____________UNKNOWN
Customer_Name_Group is set to UNKNOWN when Flag=True, and set to Customer_Name when Flag=False
The attributes for Dim_Customer shown in the Dim Structure tab:
Customer Key (Usage set to Key, with NameColumn = Customer_Name)
Customer Name Group (Usage set to Regular)
Hierarchy:
o Customer Name Group
oo Customer Key
The table Dim_Customer desired display at the Dim browser:
-All
___-David
___-Lisa
___-UNKNOWN
_______-Dan
_______-Noah
This is the actual display I'm receiving now:
-All
___-David
_______-David
___-Lisa
_______-Lisa
___-UNKNOWN
_______-Dan
_______-Noah
What am I doing wrong?
Thank you for your help,
Arik
July 14, 2010 at 4:48 am
In the dimension designer look for an property called HideMemberIf when you select your hierarchy. Now choose ParentName as the value. (A member is hidden when its name is identical to that of its parent.) This should result in your desired result.
July 14, 2010 at 7:52 am
Thanks, that's exactly what I needed
Arik
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply