I have a requirement to calculate " Number of Movements for each material" for warehouse logistic operations. Can you please suggest the modeling approach for this kind of scenario.
Can I add key figures in the cube level to compute this number or snap shot scenario will help.
Please share you thoughts.
You can like...
Take Meterial Production details along with date of manucaturing,and then track it like.
1. From Actual Production Plant to Storage Loaction, how many days? (from AUFM table)
2. Any Internal Transfers?. i.e. one loaction to another location?.
3. From storage location to Custome, this you can find using LIKP and LIPS tables or 2lis_12_vcitm.
In this way you need to gather the data from various tables/ data sources and then create reports.