CODEWITHSUNDEEP
ssashierarchy
JeffreyABecker
JeffreyABecker

Reputation: 2743

How can I define a dimension using an external table to define the hierarchy

I'd like to define a hierarchical dimension where the hierarchy is defined in an external table as such: My Dimension Tables

All the tutorials seem to be geared towards deriving the hierarchy from data in the row. LeadSourceID/LeadSourceGroupID/LeadSourceViewID are not usable for this as only one is ever populated; they're ETL artifacts.

Upvotes: 1

Views: 65

Answers (1)

Dominic Goulet
Dominic Goulet

Reputation: 8113

First of all, what you want there is a Parent-child Hierarchy :

http://technet.microsoft.com/en-us/library/ms174846.aspx

All you need to do is follow the previous article example. There is the part of the subtable you got LeadSource which is not explained there, but it's as easy as joining the LeadSourceHierarchy table to the LeadSource table in your dimension definition (datasource section).

Upvotes: 1

Related Questions