Forum Discussion
Filtre between dimension doesnt work with a single column
Greeting community ,
i have connected to a cube (Live connection method ) , my model contain ( 32 dimensiosn and 9 fact )
this is a part of my model :
As you can see the relation between the dimensions and the fact exist , the problem here that i cant build filter between my dimensions without adding another column . and i find it weird . here is an exemple : (first table containt the column Iduser from Dimuser and the second table contain DepartmentCode from DimEntity ) when i filter doesnt nothing happen :
But if i add the DepartmentCode from DimEntity to the first table , the Filtre works :
anyone faced such issue ? Thanks in advance
Hi there. It looks like you need to filter between dimensions. The behaviour is correct. If you add two columns the deparment will filter the fact giving you the users related to the fact table. The only way to make that work is sharing columns in visualizations, otherwise you need to make a small change in the data model.
To keep the model consistency and avoid changing navigations and filter directions you can try measures that will help you filter between dimensions. You have to create a measure in the fact that will return 1 if you are filtering the fact, that way if you have a visualization like the list of users and you want to filter it by another dimension, you can just add a visual level filter with that measure asking if it's 1.
This post explains it step by step:
https://blog.ladataweb.com.ar/post/185907335292/datamodeling-sincronizar-filtros-entre
In case you don't want to read that much you can take this shortcut haha. Add a measure like this:
Filter_Dimension_by_fact = INT ( NOT ISEMPTY ('Fact_Table') )Add the measure as a visual level filter on the visualization you want to be affected by dimension filtering as equals to 1.
Hope this helps.
Regards,
2 Replies
- ibarrau
Super User
Hi there. It looks like you need to filter between dimensions. The behaviour is correct. If you add two columns the deparment will filter the fact giving you the users related to the fact table. The only way to make that work is sharing columns in visualizations, otherwise you need to make a small change in the data model.
To keep the model consistency and avoid changing navigations and filter directions you can try measures that will help you filter between dimensions. You have to create a measure in the fact that will return 1 if you are filtering the fact, that way if you have a visualization like the list of users and you want to filter it by another dimension, you can just add a visual level filter with that measure asking if it's 1.
This post explains it step by step:
https://blog.ladataweb.com.ar/post/185907335292/datamodeling-sincronizar-filtros-entre
In case you don't want to read that much you can take this shortcut haha. Add a measure like this:
Filter_Dimension_by_fact = INT ( NOT ISEMPTY ('Fact_Table') )Add the measure as a visual level filter on the visualization you want to be affected by dimension filtering as equals to 1.
Hope this helps.
Regards,