Forum Discussion

Vincent's avatar
Vincent
New Contributor III
2 years ago

[QuickView] Cross Time and Scenario Filters

Hello, Is it possible on the same quickview to cross both Time and Scenario Filter? For example I need the cross of  : Time "2022" with scenario "ESTIMATE" Time "2023" with scenario "Planning_202...
Application Properties
  • db_pdx's avatar
    db_pdx
    2 years ago

    Hi Vincent: I would recommend using an override (we call them 'mashups' internally).  You'll remove the Scenario from your column filter and append it to each specific time period. For example:

    T#2022:S#ESTIMATE,
    T#2023:S#Planning_2023M10

    If you want to make it clear that overrides are applied, use the :Name() function at the end with MemberFilter variables. Example:

    T#2022:S#ESTIMATE:Name(|MFTime| |MFScenario|),
    T#2023:S#Planning_2023M10:Name(|MFTimeDesc| |MFScenarioDesc|)
db_pdx's avatar
db_pdx
Valued Contributor

Hi Vincent: I would recommend using an override (we call them 'mashups' internally).  You'll remove the Scenario from your column filter and append it to each specific time period. For example:

T#2022:S#ESTIMATE,
T#2023:S#Planning_2023M10

If you want to make it clear that overrides are applied, use the :Name() function at the end with MemberFilter variables. Example:

T#2022:S#ESTIMATE:Name(|MFTime| |MFScenario|),
T#2023:S#Planning_2023M10:Name(|MFTimeDesc| |MFScenarioDesc|)
Vincent's avatar
Vincent
New Contributor III
2 years ago

Thanks so much!

The best tip of the year for me and a lot of my colleagues! 

Just the second part takes time to retrieve but it is not a mandatory need.