Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Hierarchy from two different dimensions Expand / Collapse
Author
Message
Posted Wednesday, December 5, 2012 5:41 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 3:59 PM
Points: 213, Visits: 572
Is it possible to have a hierarchy that contains attributes from two different dimensions?
Post #1393283
Posted Thursday, December 6, 2012 12:15 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Sunday, July 20, 2014 11:20 PM
Points: 13,252, Visits: 10,133
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
Posted Monday, December 17, 2012 10:50 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, December 18, 2012 4:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:11 AM
Points: 7,128, Visits: 6,291
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

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
Posted Wednesday, January 2, 2013 9:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 13, 2014 1:09 PM
Points: 121, Visits: 308
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 »

Add to briefcase

Permissions Expand / Collapse