01-20-2022 01:41 PM - last edited Wednesday by JackLacava
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 <=2019M12
>>> only "KPI after 2020" when my POV time is >=2020M01
Currently my cube view result looks like:
My desired outcome:
Any ideas how to create such cube view?
01-20-2022 02:07 PM
Probably due to rubber duck effect I found a solution after I had written my question here.
A#MyKPIs.Base.Where(Text1 Contain 'Active')
Despite I solved the problem, I would highly appreciate alternative solutions.
01-24-2022 09:28 AM
Text8 is hardcoded and doesn't depend on POV, which I thought is the requirement. But I'd look into the XFBR first, with just one XFBR driven column returning different set of KPIs depending on your POV.