Skip to Content
avatar image
Former Member

Date range issue in webi

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 18, 2017 at 01:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded