cloning parent-child hierarchy within a dimension

Question

cloning parent-child hierarchy within a dimension

darth vodka

SSCrazy

Points: 2367
More actions
September 13, 2010 at 3:31 am

#145170

hi
i have a self-referential table and a dimension that contains a ragged parent-child hierarchy
all fine
but, i want to have two parent-child hierachies that are the same data but sorted and displayed slightly differently
i could just create another dimension, but this seems too much
if i change my properties on the hierarchy it can be either version i need, but i staruggle to create two...
if i create a nother parent-child, it gets the hump in the attribute relationships as it thinks i want two parents for the key field
bit stumped, any ideas?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

naveendas Mr or Mrs. 500 Points: 590 More actions · Answer 1

If the two hierarchies are essentially the same, you should not have to define another parent-child relationship. Just create another hierarchy on the same dimension with a different name

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 2

SSAS doesn't currently support > 1 P-C hierarchy per dimension 🙁 If you don't want to create two separate dimensions, only alternative that i would see is to unroll the P-C nature of the two P-C drill paths and create proper levels for both. There is/was a tool for doing this on CodePlex, here[/url]. On looking at this, seems like it hasn't been updated in a while but the BIDS helper lists one of it's features as the naturlizer also, so maybe it's been moved into this project[/url].

Steve.

darth vodka SSCrazy Points: 2367 More actions · Answer 3

stevefromOZ (9/28/2010)
SSAS doesn't currently support > 1 P-C hierarchy per dimension 🙁 If you don't want to create two separate dimensions, only alternative that i would see is to unroll the P-C nature of the two P-C drill paths and create proper levels for both. There is/was a tool for doing this on CodePlex, here[/url]. On looking at this, seems like it hasn't been updated in a while but the BIDS helper lists one of it's features as the naturlizer also, so maybe it's been moved into this project[/url].

ah many thanks, it's enough to know it needs add-ins. not too fussed about getting my hands dirty

cheers

DV