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
DeepButi's avatar
DeepButi
Icon for Helper I rankHelper I
8 years ago

Hi Bordalos

yes, of course the code is in the fact_table. But it is not a measure, so not available as data. It is an OLAP cube, the fields used as keys to the dimension tables are not measures, so not visible in the fact_table.

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)