Skip to Content
author's profile photo Former Member
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

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on 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

  • Posted on 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