February 7, 2012 at 6:40 am
Hi Everyone,
I would appreciate your support on the following issue.
I have a table named Category, which basically has the following fields:
PK
CategoryID
ParentCategoryId
CategoryDescription
The CategoryId references the ParentCategoryId to get the parent category.
Now in SSAS 2008, I created a DSV and pointed the CategoryID to self join the same table on column ParentCategoryId.
Next, I created a Dimension named Category, and Am finding it difficult to create a Dimension Hierarchy to replicate the data in the base table.
Basically I want to cxreate a hierarchy where a user can navigate from the top of the hierarchy into the sub-categories.
Can anyone please assist in this issue?
Thanks very much for your support,
Jon
February 7, 2012 at 9:48 am
Jon,
It sounds like you've modified the join/table in the DSV but not the dimension (on the attribute dimension) itself. In the dimension, if you right click on the attribute in question and specify as Parent for the usage type, this should help. Supposedly, the dimension wizard will pick up the P-C tables but I rarely use the wizard, so can't confirm or deny that this works.
s.
Steve.
February 7, 2012 at 11:51 pm
Hi Steve,
Thanks for your comment.
I have created the relationship in the DSV but I do not get the wizard to create the Parent-Child dimension, maybe I am missing something?
Thanks
jon
February 8, 2012 at 5:44 am
Hey Jon, if you already have the dimension created and you're just missing the P-C, then make sure the parent attribute is in the dimension ( this is the SSAS dim, not just the dim tsble) and then set that attributes usage to "parent" (it's a property of the attribute within the dim).
Steve.
February 8, 2012 at 6:15 am
Hi Steve,
Go exactly your suggestions so now it's workin Thanks heaps!
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply