Skip to Content
avatar image
Former Member

IIF not accepting Dimensions in a OLAP Universe using Bex Query

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 21, 2010 at 10:16 AM

    Hi,

    could anyone find a solution for that??

    Thanks!

    Joachim

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 04, 2010 at 03:23 PM

    Hi,

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

    Ingo

    Add comment
    10|10000 characters needed characters exceeded