Forum Discussion
Data Modeling
Hi VK-Vishnu ,
If you have already implemented a star schema and the common slicers are still not filtering all visuals correctly, then the issue may be related to the relationship configuration rather than the schema design itself. In a star schema, shared dimension tables should filter all connected fact tables through active one-to-many relationships.
Could you please share a screenshot or diagram of your current data model, including the relationships between the 3 fact tables and 4 dimension tables? Also, please confirm whether the slicers are built from dimension tables and whether all relationships are active.
This will help identify whether the issue is related to relationship paths, filter propagation, or model design.
I already tried this ways but its not working , i have 3 fact and 4 dim, fact 1 connect wit dim 1,2,3,4 then fact 2 connect with dim 1,3,4 and fact 3 connect with dim 2,3,4. move visula side 1st page having only 7 sliceers that slicers are comman and 2nd page having many visulas and also having some slicers, and also i want both slicers have intract in visuals and main condition fom my clint side is desighn model on star schema. what i doo
Hi VK-Vishnu ,
If you have already implemented a star schema and the common slicers are still not filtering all visuals correctly, then the issue may be related to the relationship configuration rather than the schema design itself. In a star schema, shared dimension tables should filter all connected fact tables through active one-to-many relationships.
Could you please share a screenshot or diagram of your current data model, including the relationships between the 3 fact tables and 4 dimension tables? Also, please confirm whether the slicers are built from dimension tables and whether all relationships are active.
This will help identify whether the issue is related to relationship paths, filter propagation, or model design.Hi VK-Vishnu ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.