Skip to main content
D
DivyaPuri
Newcomer
November 23, 2021

if-else condition in Member Filter Builder Cube View

  • November 23, 2021
  • 3 replies
  • 0 views

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

3 replies

J
JohnMorehead
Newcomer
November 23, 2021

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?

    C
    ckattookaran
    Newcomer
    November 23, 2021

    +1 for the XFBR

    D
    DivyaPuriAuthor
    Newcomer
    November 23, 2021

    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.

    C
    ckattookaran
    Newcomer
    November 23, 2021

    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

    Terms & ConditionsAccessibility statement