BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

[Webi 4.x] Help required to calculate business dates


 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
babu_272
Principal Member
Principal Member



Joined: 28 Jul 2010

Posts: 146


flag
PostPosted: Mon Jun 29, 2020 12:26 am 
Post subject: Help required to calculate business dates

Hi All,

Require one help.

We have an transaction date comming from DB where data will be populated from Monday to saturday and holiday calander to be at report level where if dates fall on so and so holidays then will flag Y.
Now say on sunday there are no transaction then on saturda the date difference should be 2

For Ex:
Transaction dates Date Diff
22-June-2020 1
23-June-2020 1
...
26-June-2020 1
27-Jun-2020 3

30-June-2020

How ever if Monday is also holiday for example then on Saturday date difference should be 3.

Need to achive in WEB I , kindly guide
Back to top
n8aktiv
Principal Member
Principal Member



Joined: 28 Dec 2018

Posts: 123


flag
PostPosted: Mon Jun 29, 2020 7:24 am 
Post subject: Re: Help required to calculate business dates

you can use RelativeValue() to find the next-date in your data and then substract "date" from "next-date" to get the difference

https://help.sap.com/viewer/4ff2f6684ada4777892af5866c3857a2/4.2/en-US/4723ca4d6e041014910aba7db0e91070.html

or give this request to your DB-collegues, they could add an additional column "next-date" to the source-data, with using the SQL-window-function "lead()"

_________________
------------------------------------------
SAP BO 4.2 SP6 Patch 10
------------------------------------------
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0271 seconds using 17 queries. (SQL 0.0027 Parse 0.0009 Other 0.0236)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo