on 11-03-2013 3:57 PM
Hi APO expert,
We extract inventory on data from Apo SNP planning book into BW report through MALO cube.
The BW report data not matching with APO planning book and Malo cube as well.
I appreciate your help.Many thanks in advance.
Vijay KH
HI Vijay, which key figure did you extracted? what is the difference between cube and planning book?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vijay, You did not answer my second question. But the key figures mentioned are auxliliary key figure which is not saved in liveCache (at least in standard SNP planning book). Please make sure that the key figures you extract is either liveCache time series key figure or liveCache order key figure, and the key figures should be assigned to aggregate 9AMALO in planning area setting. APO is responsible for planning area to infocube. Infocube to BW report is responsible totally by BW.
Hi Ada,
do you have any suggestions how to take backup of SNP planning area key figures, i am also having similar trouble with extracting TOTAL DEMAND key figure, it does not show up in the extraction.
Is there any possibility to load the data from SNP planning area to Info Cube in a delta enabled mode, if weekly data needs to be load to the info cube ?
In a general sense , can you also suggest the standard way to take backup of SNP planning area key figures. What is the best approach in terms of
1) Data load performance for SNP planning area backup
2) extracting Key Figures ( Safety Stock, Total Demand , Total Receipts, Forecast)
3) How to delta enable them for weekly extraction / Daily extraction
4) Is a consistency check necessary to perform before running extraction for the SNP backup cube
hi, sorry but I cannot answer all your questions.
1) Data load performance for SNP planning area backup
-Try to keep the number of key figures and number of buckets as small as possible.
-Exclude auxiliary key figures from datasource.
-Consider excluding zero values.
-Consider using parallel processing.
2) extracting Key Figures ( Safety Stock, Total Demand , Total Receipts, Forecast)
- All key figures to be extracted must be either liveCache order key figure or liveCache time series key figure. Auxiliary key figures cannot be extracted.
- All key figures to be extracted must be assigned to the aggregate which is used for the datasource.
3) How to delta enable them for weekly extraction / Daily extraction
- Sorry I don't know such setting at APO side ... maybe you can also check BW side whether there's delta update functionality.
4) Is a consistency check necessary to perform before running extraction for the SNP backup cube
- Better but not mandatory. Inconsistency may cause error during extraction.
User | Count |
---|---|
13 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.