Forum Discussion

macostaf2's avatar
macostaf2
New Member
10 years ago
Solved

Hierarchies within different column tables

Hi, I am familiar with hierarchies, but now I have the need to create a new hierarchy based on description from different tables: Products Hierarchie, but I need the hiest level of manufacturer which...
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi macostaf2,

    You can bring the related fields into the table with the lowest level of granularity, which can be done on this table by adding calculated columns as demonstrated by the following example, then you are able to create hierarchy.

    ColumnName=RELATED(DimProductSubcategory[EnglishProductSubcategoryName])

    For more details, please check the following blog.
    https://intelligentsql.wordpress.com/2013/05/08/tabular-hierarchies-across-multiple-tables/

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi macostaf2,

You can bring the related fields into the table with the lowest level of granularity, which can be done on this table by adding calculated columns as demonstrated by the following example, then you are able to create hierarchy.

ColumnName=RELATED(DimProductSubcategory[EnglishProductSubcategoryName])

For more details, please check the following blog.
https://intelligentsql.wordpress.com/2013/05/08/tabular-hierarchies-across-multiple-tables/

Thanks,
Lydia Zhang