Skip to Content
0

Showing dates as dates+1 in the reporting- Webi

Mar 30, 2017 at 10:47 PM

42

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Mar 31, 2017 at 05:57 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Kuldeep Ghosh Apr 05, 2017 at 08:31 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded