Difference in working days between two dates

Business Warehouse

Moderators: Snowy, thx4allthefish

Locked
M

Difference in working days between two dates

Post by 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!

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

Post by 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.

mannie

Post by 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

jv

Post by jv » Thu Oct 24, 2002 8:39 am

use function :

DAYS_BETWEEN_TWO_DATES

itsmanish

use date as Key figure

Post by 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

Locked