Forum Discussion

VK-Vishnu's avatar
VK-Vishnu
Regular Visitor
3 months ago
Solved

Data Modeling

Hi, am working in one migration project , i face issue is existing report under 4 sub reports now i migrate that report to bi and craete single reoprt, the issue is i had 4 fact tables and 4 dim tabl...
data protection
  • Anonymous's avatar
    Anonymous
    3 months ago

    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.

InsightsByV's avatar
InsightsByV
Icon for Super User rankSuper User
3 months ago

Hi,

In your case:

 

Create a master date table and connect it with the respective tables and ensure that the relationships are correctly defined (one to many) and single direction.

Use columns from this master date table for all your slicers to ensure uniformality across pages.