Forum Discussion

Jarek_Sadowski's avatar
Jarek_Sadowski
New Contributor II
3 years ago

CubeView - how to hide elements depending on the time?

Hello All, I have two elements, let' say for example "KPI before 2020" and "KPI after 2020". I would like to create a cube view that's shows >>> only "KPI before 2020" when my POV time is <=2019...
Cube View
Jarek_Sadowski's avatar
Jarek_Sadowski
New Contributor II
3 years ago

Probably due to rubber duck effect I found a solution after I had written my question here.

  1. Put indicator that KPI is active to one of Text1-Text8 parameters, e.g.
    1. Text1 = 'Active' starting from 2016, 
    2. Text1 = 'Inactive' starting from 2020, 
  2. I used where clause in Member Filter Builder:
A#MyKPIs.Base.Where(Text1 Contain 'Active')

Despite I solved the problem, I would highly appreciate alternative solutions.

Best regards
Jarek