Filtre with a non active relation table

[Adeline]

Hello everyone

I have a problem to calculate a KPI related to dates 

1er Part :

• generate CA 
• generate CA (N-1) : le N-1 but with a particularity for exemple  for CA(year=2022) i want to compare it to CA(year=2018)

• my CA SC FINAL in based on a date table DIM_DATE to be able to change the date independfly from the main date table DIM_TEMPS : The script to generate by CA is in the screenshot
• THE DIM_COMPARABILITY was genertaed for this purpose but the result doesnt work since (even with a direct relationshio on my FT_Sales ) i have CA = CA SC decomp

2ème Part

• The filter of Senario comparabilité doesnt work on my CA wich means my table DIM_COMPARABILITY can not filter my CA and i dont understand why
• On the scrrenshot you can see the DIM_COMPARABILITY and the table i need to use : screenshot below
• my CA based on DIM_TIME uses a no direct relationship with CA 

DIM COMPARABILITEis an inactive relationship

 CA uses TREATAS to call the DIM COMPARABILITY table 

• i tried to use SWIICTH ( SELCTED VALUE ) on the colomn  Scenario comparabilite buy i have an error with  mode TRUE / FALSE on this table