Forum Discussion

DivyaPuri's avatar
DivyaPuri
New Contributor
4 years ago

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...
Cube View
DivyaPuri's avatar
DivyaPuri
New Contributor
4 years ago

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.

ckattookaran's avatar
ckattookaran
VIP
4 years ago

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