on 01-10-2013 11:10 AM
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?
Hi Pritesh
This is by design, please check these two KBs for more information :
https://service.sap.com/sap/support/notes/1370410
https://service.sap.com/sap/support/notes/1485264
Best Regards
Ines
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.