FILET THE DATA ACCORDINGLY INACIVE RELATION SHIPS

[Ajithrjaa]

Hi Team,

Lossing the Values BZ of inactive relationship in between the two relationships.
I have a cenario like 3 table Table 1 and Table 2 Table 3

in table 1 and table 2 havineing a two relation ships one is active another one is inacive.
and table 2 and table 3 having a relation ship one to many filet both direction.

I in my list of values in my slicer I can able to see the active reation ship values from the table3.

But I want list active and inactive values from the Table3.

[DataNinja777 · Accepted solution]

Hi @Ajithrjaa 

In a data model where the fact table contains multiple date fields like in your case (start date and end date for example) it is important to have your calendar table as a "disconnected table" with your fact tables.  Having it as a disconnected table (with no relatinoship) will enable you to perform flexible duration analysis using both start date and end dates.  Please have a look at the article below which discuss the use of disconnected calendar table in a headcount analysis which has similar start date and end date as your fact table data.  

https://p3adaptive.com/finding-the-magic-part-2-on-the-way-to-data-happiness/

Best regards,