Skip to Content
avatar image
Former Member

MDX - Convert string to date

Hi All,

Im trying to use a date object in Universe Designer 3.1, the data is coming from MS Analysis Services(Cube).

The first problem is that the date values always come into the Universe as a string, and not a date. So when I create a prompt on a Webi report, it dosnt allow me to use the date picker.

The second thing is, I tried converting the string to a date(Having never seen MDX before): So with google and some reading I tried using a to_date() and Cdate, both of which havnt worked. And the error messages are not very useful.

All I really want to do, is convert either a timestamp(which is in string type) to a date type, or a date(yyyyMMdd) which is also in string formate to a date type with the same format.

Can anyone please assist?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 10, 2013 at 03:43 PM

    Hi Pritesh

    This is by design, please check these two KBs for more information :

    Not Active Contributor

    https://service.sap.com/sap/support/notes/1370410

    https://service.sap.com/sap/support/notes/1485264

    Best Regards

    Ines

    Add comment
    10|10000 characters needed characters exceeded