PP - Cube for Actual Capacity Utilization (in hours per confirmation)
I need to extract the exact operation confirmation times for PP orders from ECC6. For example, if a single order started at 11:00am and then was confirmed twice before being finished in the evening, the client wants to see the actual times used for each operaiton. This way they want to subtract from 24 hours and see the idle time of the production operation.
For this purpose I have checked all the cubes under 'Production/process orders' infoarea. The cube '0PP_C03 Plan/Actual Comparison Operation/Work Center View' seems to have the operation time but in days. This is first of all causing a rounding off problem and secondly it does not show the time gaps between confirmations on the same operation.
Any help will be highly appreciated.
Vikas Sharma replied
Method 1 :
1- Create a one Multi provider .
2- Copy the standard cube 0PP_C03 and make your own Cube with necessary fields ( enhance it as per your requirement ).
This New Cube should be Virtual Cube .
3- Create a Report on Mutiprovider ( which you created in step1 )
4-select the relevant char and key figure as per requirement .
5- you can use the selection and formula in report for time difference ..
In this method restrict the query on virtual cube only .
Method 2 :
From R/3 you have record like this :
Operation 1( O1) ---> 11:00 :00
Operation 1( O1) --> 14:00:00
Operation 2( O2) --> 10:30:00
Operation 2( O2) --> 13:30:00
1- Create a one Key figure with Data Type TIMS .
2- Include this key figure in the Cube which you have created in above steps ( Method1 )
3-Write a routine to fillt he data for Keyfigure ..if O1 record find calculate time difference .
4-Now you have time difference in BW for operation
5-Add new keyfigure in MP and use in Report .
Hope this helps .