Date and Month format - BW Query- Universe
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.