Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: 2 days ago @ 9:31 AM
Points: 267, Visits: 741
Is it possible to have a hierarchy that contains attributes from two different dimensions?
Post #1393283
Posted Thursday, December 6, 2012 12:15 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Thursday, September 22, 2016 2:39 AM
Points: 15,371, Visits: 13,116
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 SQLKover.

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: 2 days ago @ 12:22 PM
Points: 7,326, Visits: 8,481
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

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: Wednesday, August 17, 2016 1:55 PM
Points: 148, Visits: 396
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