Forum Discussion
Data Model: Using Reference tables to merge in Categorizations for Dimension usage
Anonymous
I looked at the model and I could recomment couple of approaches.
1. Bring Product segment to facts and join the segment dimension directly to facts intead on top of tax. The tax should join to facts as well. With this tax and segment both filter facts.
But for a single row in fact, if a segment tagged to core is different than a segment tagged to platform, we can't go for this appraoch.
2. Create bridge or linker table between tax and facts. This should have all the combination for segment, tax(core,product, platform etc) and facts. All 7 tax and segment dimension connects to bridge and the bridge connects to facts.
In any case, you can't join the dimension to seperate tax unless you merge them togeather.
Let us know.
Anonymous
I looked at the model and I could recomment couple of approaches.
1. Bring Product segment to facts and join the segment dimension directly to facts intead on top of tax. The tax should join to facts as well. With this tax and segment both filter facts.
But for a single row in fact, if a segment tagged to core is different than a segment tagged to platform, we can't go for this appraoch.
2. Create bridge or linker table between tax and facts. This should have all the combination for segment, tax(core,product, platform etc) and facts. All 7 tax and segment dimension connects to bridge and the bridge connects to facts.
In any case, you can't join the dimension to seperate tax unless you merge them togeather.
Let us know.
I think I have ended up at the conclusion to just merge in the tax to the fact table at the ProdSeg level and use normal diminetions tables. It is impossible to process in Power BI, but I have a Excel Cached model that I may take to a db at somepoint. In Excel i will do these merges where it is more managable.
Anonymous
Before you start to do it in Excel, when you merged in Power BI, did you uncheck the "Enable Load" for all the 7 taxonamies tables? Otherwise, it would have loaded the table twice and caused it to run longer.
Just a thought.
yes. I disable many tables in processing.