I have this project for almost a month now and I cannot find a solution:
The project is called PA HPU calculation.
*Actual HPU = Actual Hours / Actual Units*
I have a cube: hour Cube will give me the Actual Hours.
Actual Units will be calculated from a table that a replicate from R/3 called zcars.
the fields of the table are: category_type example(M5, M7, Z3, F8) and the builT_day which is the day in the month the cars are built. here our the tables look like:
Built_day | Category_type| Vinnumber
01/02/2008 M5 G555
01/02/2008 M5 L567
01/02/2008 F8 T433
01/03/2008 M5 R544
01/03/2008 Z3 h675
.etc..
How to find the Actual Units per months and put it in another cube to calculate the key figures Actual HPU? Do I have to design an ABAP program? I am very confused. I need help. Hope some one will help.