This website is not affiliated with, sponsored by, or approved by SAP AG.

Difference in working days between two dates

Business Warehouse

Moderators: Snowy, thx4allthefish

Difference in working days between two dates

Postby M » Wed Oct 23, 2002 12:33 pm

Hi,

How can it be calculated the difference in working days between two dates at query level and cube level (update rules)?

Thank you!
M
 

Postby Ravi » Wed Oct 23, 2002 10:02 pm

Haven't tried in query, but in update rules, you can subtract dates one from another (higher - lower) if the dates are type d and the result is type i or p.

-Ravi.
Ravi
 
Posts: 71
Joined: Wed Oct 23, 2002 9:48 pm
Location: OH, USA

Postby mannie » Thu Oct 24, 2002 8:17 am

Hi,

I think what you need to do is to make use of the factory clanedar for that plant for calcualting the workdays between those two dates. The factory calendar that you have in R/3 should be availble in BW also when you transfered the global settings from R/3 to BW.

Regards:mannie
mannie
 

Postby jv » Thu Oct 24, 2002 8:39 am

use function :

DAYS_BETWEEN_TWO_DATES
jv
 

use date as Key figure

Postby itsmanish » Thu Oct 24, 2002 4:02 pm

You can use the date as a KYF . look at the infoobject 0DATE_KYF and create similar Objects and add them to the transfer rules. You can then calculate the difference etc..

Note : If u r creating a new KYF create the same as 0DATE_KYF. The aggregation (tab in the infoobject maintenance screen) should be the same as the above.

Hope this works for u

ms
itsmanish
 


Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 1 guest





This website is not affiliated with, sponsored by, or approved by SAP AG.