Skip to Content
0
Dec 01, 2008 at 12:53 PM

Efficiency per working day calculation

24 Views

Hi, guys

I have two ODS-es connected through an Infoset - one with transport data on item level (item, date, month, departure plant,carrier, quantity etc.), and another with the working days per plant on month level.

The infoset data looks like this:

Item no/ Date / PeriodYear /Dep.plant/ Carrier/ Load qty/ Work days

item 1 / 20.11.2008/ 11.2008/ RNN1/ ADC Trans/ 100kg/ 26 (work days in a month)

item 2/ 20.11.2008/ 11.2008/ RNN1/ ADC Trans/ 150kg/ 26 (work days in a month)

The query has to take the data (in example above - 250kg and divide it per working day. But, the system is aggregating the data in key figure so the query result for work day is 52 days instead of constant 26.

How can I change the query and make the number of working days logically correct.

To add a little extra spice in my question - the working days in month vary on plant level.

Can you think of a solution?

Many thanks in advance

Ana