cancel
Showing results for 
Search instead for 
Did you mean: 

MDX - Convert string to date

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member219634
Active Participant
0 Kudos

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