Forum Discussion
Left outer join - matrix visual
are you able to share your file? this probably has to do with how your data has been modelled. why do you not create one dimension with all your levels in on table? this seems like quite a convoluted design
Hello,
Unfortunately I'm not able to share the PBIX file.
Regarding your suggestion, I've got some questions. Let's say I create a new table (e.g. : DIM_ALL_LEVELS).
- Will the data model look like this?
- As I don't have a native hierarchy levels, I can't built it from DIM_LEVEL_1, DIM_LEVEL_2 and DIM_LEVEL_3. So it would mean I should built it from FACT_A which contains the 3 levels?
- Considering I could built this DIM_ALL_LEVELS table, don't you think I'm going to run into a many-to-many relationship problem?
Thanks.
Jinsoo
I think in order to truly understand what you are trying to do and why i really need an understanding of the business requirement here. what are level 1 - 3 based on? if you put them all into one table, why do you see there being a many to many relatioship issue? its hard to know without being able to see the data and undertstand what is the goal. Hope that makes sense. Also in order to group these levels together, one needs to understand the context of them