Forum Discussion

DeepButi's avatar
DeepButi
Icon for Helper I rankHelper I
8 years ago

How to clean filter for unused values

We have an OLAP SSAS cube with a sales fact table and an employee dimension table.   The employee table contains all company employees.   The sales table contains UserCode ... who created the sa...
Need Help
Bordalos's avatar
Bordalos
Icon for Helper I rankHelper I
8 years ago

DeepButi I might be missig something but I can't see how you conecting the Slicer with the fact table.

Maybe you can  share a screenshot of the relationship page.

DeepButi's avatar
DeepButi
Icon for Helper I rankHelper I
8 years ago

We are using a live connection to an OLAP SSAS cube. No relationship defined on PowerBI, everything comes up already defined from the cube itself.

 

There is no relationship page available on PowerBi.

 

I can annex the cube relationship definition ... although I guess you will not find what are you looking for there ... (only two of the fact table codes are shown)