Skip to Content
author's profile photo Former Member
Former Member

IIF MDX syntax for comparing dates

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2010 at 12:37 PM

    Hi Siegfried

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

    br

    Jesper

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 25, 2010 at 01:17 PM

    Hi Siegfried,

    what exactly are you trying to achieve ?

    ingo

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.