Hierarchy from two different dimensions

Question

Post reply

Hierarchy from two different dimensions

imani_technology

SSCrazy Eights

Points: 8200
More actions
December 5, 2012 at 5:41 pm

#149665

Is it possible to have a hierarchy that contains attributes from two different dimensions?

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

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

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

Yes, if you have a link between those two.

In other words, one dimension should have a foreign key to the other dimension.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

jacksonjrobert Grasshopper Points: 17 More actions · Answer 2

My question is the same.Is it possible to have a hierarchy that contains attributes from two different dimensions? i would like to know what others think about his question.

_______________________

data analysis companies

Brandie Tarvin SSC Guru Points: 172994 More actions · Answer 3

The question was answered. What other thoughts do you need and what do you need them about specifically?

I guess what I'm saying is ... did the answer confuse the issue?

(edited response for clarification)

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

lduvall SSCarpal Tunnel Points: 4869 More actions · Answer 4

I don't know if the original poster was asking about multi-dimension or tabular, but in tabular, all your hierarchy fields have to exist in the same dimension. A way to get around this, though, is to create a new calculated member in your dim table and use the =RELATED function. For instance, I wanted to create a Product Hierarchy (Category-Subcategory-Product). On the dimProduct tab, you'd create a new column for ProductCategory and use the function =RELATED(DimProductCategory[EnglishProductCategoryName]). You'd do the same thing for ProductSubcategory. =RELATED(DimProductSubcategory[EnglishProductSubcategoryName]). Now you can use them in your hierarchy.