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

That's the main issue... I need to filter the dim tables according to the source selected.

I understand this kind of relashionship shouldn't be allowed. However, according to the data I have in my model, this shouldn't be a problem and this would make sense. This is what I'm trying to achieve:

 

 

Therefore, I've been trying to use RLS to create a filter in every dim table without creating the relashionships using the DimSource table. However, I didn't manage to do it...

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 😉