Skip to main content
Member
Nov 23, 2021 9:36 PM UTC

if-else condition in Member Filter Builder Cube View

Source:   Migrated from Champions

Hi Team,

Hope you are safe and doing well.
I am attempting to display members using the if-else condition in cubeview.
Does anyone know if it’s possible to use the if-else condition in Member Filter Builder Cube View?

Thanks in advance

6 replies

Nov 23, 2021 9:36 PM UTC

The only way that I know of to implement that is through an XFBR rule. What is the if-else condition you are trying to switch on?

Member
Nov 23, 2021 9:37 PM UTC

+1 for the XFBR

DivyaPuriAuthor
Member
Nov 23, 2021 9:38 PM UTC

To answer question:-
I have E#Root.WFCalculationEntities in cubeview member filter. I want to add condition, if E#Root.WFCalculationEntities is blank, then E#Top.
I am during this using XFBR, but wanted to check, if someone tried if else in CV memberfilter.

Member
Nov 23, 2021 9:38 PM UTC

You can write an XFBR that gets the profile entities. If that list is nothing (maybe you can also do a count = 0) then return E#Top else return E#Root.WfProfileentities