cancel
Showing results for 
Search instead for 
Did you mean: 

IIF not accepting Dimensions in a OLAP Universe using Bex Query

Former Member
0 Kudos

Hi,

We have an issue with Prompted object , u2018IIFu2019 expression is not taking dimension object in u2018Thenu2019 clause, it takes only the measure object.

Below are the two expressions one with measure and other with dimension, object with measure works fine and dimension doesnu2019t.

Dimension u2013 Prompted trend (Fails with Error)

<EXPRESSION>IIF(@Prompt('Select a time period trend view','A',{'Fiscal_Year','Fiscal_Year_and_Quarter','Fiscal_Year_and_Month','Calendar_Year', 'Calendar_Year_and_Quarter','Calendar_Year_and_Month'},mono,constrained)= Fiscal_Year,@Select(Fiscal Dates\Fiscal Year),A)

</ EXPRESSION >

Measure u2013 Prompted trend (Works fine)

<EXPRESSION>IIF(@Prompt('Select a time period trend view','A',{'Fiscal_Year','Fiscal_Year_and_Quarter','Fiscal_Year_and_Month','Calendar_Year', 'Calendar_Year_and_Quarter','Calendar_Year_and_Month'},mono,constrained)= Fiscal_Year,@Select(Actuals\Actual Amt (Local)),0)

</EXPRESSION>

Has anyone tried to do this in a different way

Thanks,

Anu

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

could anyone find a solution for that??

Thanks!

Joachim

Former Member
0 Kudos

IIF can only return numbers that's why you can't use a dimension in the THEN clause, it's a BW limitation AFAIK

Answers (1)

Answers (1)

IngoH
Active Contributor
0 Kudos

Hi,

just to let you know - not overlooked - will look into this.

Ingo