Forum Discussion
Relationships between groups
Anonymous so you should unpivot the data by following these steps:
Transform Data -> Select Order id and pK_Date columns -> Right click -> Unpivot other columns
It will add two columns, attribute and value, rename as you want it, close, and apply.
Now set the relationship from the dim table to the attribute column in the fact table and that's it. Now you should be able to slicer the fact table from the dim table
Super UserAnonymous so you should unpivot the data by following these steps:
Transform Data -> Select Order id and pK_Date columns -> Right click -> Unpivot other columns
It will add two columns, attribute and value, rename as you want it, close, and apply.
Now set the relationship from the dim table to the attribute column in the fact table and that's it. Now you should be able to slicer the fact table from the dim table
hello parry2k i think i managed to unpivot the tables without duplication of the orders, but how do I now use it so that I can select a channel and the table will filter based on which channel I want? channels are in different columns: