Forum Discussion

Marfield's avatar
Marfield
Icon for Helper I rankHelper I
6 years ago

One table to rule them all

Hi there,   I have an issue with my data model. Bassicaly, I need to filter all my report according to the row filtered from one main table.   In my example, I have 3 dimensions and 1 fact table ...
Need Help
VasTg's avatar
VasTg
Icon for Memorable Member rankMemorable Member
6 years ago

Marfield 

 

Did you make the filter as bidirectional between sales to client and sales to Product? This should give the result you need. Test it out before merging Source to sales.

 

 

Marfield's avatar
Marfield
Icon for Helper I rankHelper I
6 years ago

Bi-directionnal wouldn't work because I have more than 1 fact table in my real model 😉