Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Date and Month format - BW Query- Universe

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.


Former Member
Not what you were looking for? View more on this topic or Ask a question