Date range issue in webi

[Former Member]

Hi All

We are currently using SAP BO4.0 SP09 system. ORacle 11g database

Our report is build on a UDT universe. There is a issue with the objects related to date in the universe.

For instance, if we try to select a date range between start date(DD1/MM1/YYYY1) end date (DD2/MM2/YYYY2) the report does not retrieve data if DD1>DD2 though there is data in the database.

This is causing an issue for end users if they want to select last week of any month to next month starting data.

When try to use the function trun("DATE","DD") in the universe, the issue is resolved.

Can someone please help us understand the reason for why such a difference in data retrieval when we are using trun and without trun function.

[former_member492038]

I've seen some strange behavior between the business layer and data foundation with universes and how they handle dates. I suggest the following steps:

• That the column in question is defined as a date in your data foundation AND
• That the dimension you are using is defined as a Date

Otherwise it may be doing a string comparison hence the confusion. If you run into any errors in your business layer when setting the dimension as a date, you can also update the definition to something like:

to_date(<YOUR_OBJECT>, "<YOUR_FORMAT>")

To make sure it recognizes it appropriately