Forum Discussion
jaryszek
Super User
Super UserHow to create hierarchy not in fct table or based on integer key columns?
Hello, I have fct_table with integers keys to dim tables where my fields from hierarchy exists. How to make hierarchies from there? Currently I have string fields in fct_table and can crea...
jaryszek ,
Thank you for sharing your blog post.
- The RELATED () function pulls data from a related table into the current one, typically used in calculated columns.
- This operation is evaluated during data refresh, not during report interaction. So, it affects model processing time, not query performance.
We appreciate your engagement and thank you for being an active part of the community.
Best Regards,
Lakshmi.
jaryszekSuper User
Super UserSo this is what i found as advice:
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
How this will have effect on performance? It is adding additional DAX column...
Best,
Jacek
v-lgarikapat
Community Support
Community Supportjaryszek ,
Thank you for sharing your blog post.
- The RELATED () function pulls data from a related table into the current one, typically used in calculated columns.
- This operation is evaluated during data refresh, not during report interaction. So, it affects model processing time, not query performance.
We appreciate your engagement and thank you for being an active part of the community.
Best Regards,
Lakshmi.