Hierarchy from two different dimensions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Hierarchy from two different dimensions

Hierarchy from two different dimensions

Rate Topic

Display Mode

Topic Options

Author

Message

imani_technology

Posted Wednesday, December 05, 2012 5:41 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 5:42 PM
Points: 192, Visits: 506

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

Post #1393283

Koen Verbeeck

Posted Thursday, December 06, 2012 12:15 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378, Visits: 6,473

Yes, if you have a link between those two.
In other words, one dimension should have a foreign key to the other dimension.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1393344

jacksonjrobert

Posted Monday, December 17, 2012 10:50 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, December 17, 2012 10:49 PM
Points: 1, Visits: 1

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

Post #1397555

Brandie Tarvin

Posted Tuesday, December 18, 2012 4:37 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:22 PM
Points: 6,660, Visits: 5,684

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 Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #1397693

lduvall

Posted Wednesday, January 02, 2013 9:36 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 12:13 PM
Points: 115, Visits: 288

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.

Post #1401921

« Prev Topic | Next Topic »

Permissions