IIF MDX syntax for comparing dates

[Former Member]

Hi,

I want to create one object that is the first date out of two date objects.

Tried the following in the Universe Designer:

<EXPRESSION>

IIF(@Select(Dates\Confirmed Date to) > @Select(Dates\Requested delivery to date),

@Select(Dates\Confirmed Date to),

@Select(Dates\Requested delivery to date))

</EXPRESSION>

The object parses but when running I get an error message:

A database error occured. The database error text is:

The MDX query WITH MEMBER [Measures].[...] AS ' IIF([x1].[LEVEL01] > [x2].LEVEL01],[x1].[LEVEL01], [x2].LEVEL01]) ' SELECT ...

failed to execute with the error Invalid MDX command at >. (WIS10901)

I get the same error message in the MDXTEST in BW.

We are on BW 3.5 and BO XI 3.1 Patch 2, maybe this is the problem?

Would there be a possibility to calculate this in the BW query (not in the cube)?

Thanks,

Siegfried

[IngoH]

Hi Siegfried,

what exactly are you trying to achieve ?

ingo

[Former Member]

Hi Siegfried

Did you get/find any solution to this challenge? ...I need a solution for this as well.

br

Jesper