Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Apply same filter different dimensions

 

Hi guys, I need help to solve something here.

Red table are fact tables

Green table is a Parent table based on Location table.

OneToMany is represented by arrows.

The problem is Type tables (type parent and Type Location)

 

 

If I apply filter on Type Location, i need that the same filter has been applied at Type parent.

I cannot create a join between that because it will be create a circle relationship. I cannot use just one share table because it will create a circle relashionship.

 

I need to do that because I have two fact tables in different levels, right, however, I would like to apply same filter in both of than.

 

Could you help me to solve it?