BW OLAP universe hierarchy level manipulation

[Former Member]

Hi,

don't even know if it's possible, but I'd like to do something like a COALESCE with hierarchy levels, when a level is empty then use value from the "father", something like

IIF(
 ISEMPTY([YIO                     YH_HIER].[LEVEL04]),
  [YIO                     YH_HIER].[LEVEL03],
  [YIO                     YH_HIER].[LEVEL04]
)

Is this even possible?

Thanks

[Former Member · Accepted solution]

Hi Pabloj

No, it would not work because IIF statements in the universe consist of the following:

IIF("Logical Expression", "numeric expression", "numeric expression" ) returns one of two values determined by a logical test, and the hierarchy consist of char.

Regards,

Rikke