Please advise...
I have a dimension hierarchy that each member could have multiple parents and therefore the out-of-box ParentKey support in dimension would not be sufficient.
Based on Mr. Kimball recommendation ( http://www.dbmsmag.com/9809d05.html ) I tried to use a linked helper dimension that has only ParentKey and ChildKey. However I am having difficulty utilizing it in the cube browser. The similary user experience we have with the out-of-box hierarchy is missing in this solution.
I am wondering if anyone in this forum has done something similar or know a better way of doing it.
Appreciate any help or comment.
Best Regards,
This is not natively supported by AS, but you can make it work as follow:
Create a duplicate member with same member name but different member key: ie: Member 1 (Key=1) and Member 1 (Key=2)
The original member is the one linked to your fact data Member 1 (Key = 1)
Associate a custom member formula to the shadow member (Key = 2): Member formula = Dimname.hierarchyname.$[1]
You’re set.
|||In AS2K5, you created this via a many-to-many dimension. The "linked helper dimension" in Kimball terminology is implemented as a measure group.
_-_-_ Dave
sql
No comments:
Post a Comment