on 05-17-2011 4:11 PM
Hi All,
We have a requirement that the Web Intelligence report should be on the between date range.
We have BW query, the time key figure format is MM-YYYY(its is character) and we created universe on top of the Bex Query
I am trying to create the Web Intelligence report using the month as the filter and I am using between option. When I run the query its not considering the date function and its bringing everything without concerning the the filter.
Should I create new object in universe using the existing Billing Month(MM-YYYY) object ? If yes could you please give the function how to convert. I tried to convert right click on the object>object properties>Definition-->type(Date) but its giving error.
Please advice me how can I convert the char function to date function when we use the BW query as a source to the universe.
Thank in advance.
Muvva
I got it
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.