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
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
Thanks parry2k , i tried that and this would create duplicate entries for orders which have more than channel assigned to them. Is there a way to avoid that?