Skip to Content

Showing dates as dates+1 in the reporting- Webi

Hi guys

For one of the users, we have a monthly report which goes like this:

Date Cost

01/02/2017 $200

02/02/2017 $300

.

28/02/2017 $234

Now these dates reflect what happened in the previous day as the load finishes...

Current scenario: for 30th Mar, the latest report date will be 29th Mar

But she wants to display the report date as 30th mar for 29th data and so on...and this way, she will report 31st mar data at 1st apr...

I created a variable as RelativeDate(Date;1) to give me day +1

But is this the ideal way to achieve this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 31, 2017 at 05:57 AM

    Yes this is the only way to do at webi report level.

    if this is required for multiple reports then you can create object at universe level to add 1 more day.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 05, 2017 at 08:31 AM

    Yes. If that's what you need? There is no right or wrong if your logic works. The formula is there for this reason

    Add comment
    10|10000 characters needed characters exceeded