Unable to make active relationship with multiple dimension tables.

[Anonymous]

Hi,

Issue 1:-If I have multiple KPIs governed from different fact tables connected to common dimensions, what is the best way to model it?

Issue 2:-

In this i'm unable to make active relationship for FACT (KPI C) table with multiple DIM tables.

i can only make 1 active relationship for FACT and Date Table as shown above.

If i want to make active relationship for other two tables there is a pop-up message i.e., i can't create a direct active relationship between KPI C and Dim tables.

Can anyone assist me that how to make active relationship for Fact and all Dim tables.

Thanks in advance.

[Thejeswar · Accepted solution]

Hi @Anonymous ,

The Join you can trying to create is not set as Active Relationship, because there is already a relationship that is flowing between the tables using someother path in your datamodel. To make the relationship between you KPI-C table and DIM table, you might have to first identify and remove the indirect active relationship that is present between the tables.

When you say indirect active relationship, look for cases where can query the data from KPI-C table from Dim table using another intermediate table.

Regards,