on 01-04-2009 1:02 PM
What we did is as below
1. created MOPS
2. created Planning area in DP
3. created time series and assigned version 000 in DP
4. Created Planning Book and Data view in DP
5. BW settings to extract data from OLTP and we have the data with planning version 000 in BW info cube
6. Load the history data from Info cube
7. Calculated proportional factors for next year
8. created Forecast profile.
9. Run forecasting after reading the history
10. Now forecast is ready in DP.
11. Released the same to SNP
12. When I goto SNP interactive planning and trying to load the data using 9SNP94 planning book/Data view i am getting the error - key figure not defined
Can anyone tell me how to resolve the same?
Hi,
This doesn't seem to be any issue with the data released from DP.
This looks like not all keyfigures used in the 9ASNP94 book are active.
Try running the program /SAPAPO/TS_LCM_CONS_CHECK on the planning area 9ASNP02.
Also just run the program sapapo/ts_d_objects_copy. This activates all SAP delivered standard objects...just in case some thing is left inactive during system installation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rajesha,
Left-mouse click on the error message and check which KF is missing.
Then, deinitialize the planning area and add the missing KF.
Add it also to the planning book in use.
Initialize the planning area.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dears,
I tried all the steps given by you..but all in vain, I will explain you in detail what i ahve done..
In /SAPAPO/MSDP_ADMIN - Administration of Demand Planning and Supply Network
I have defined MOPS with following character(no SNP tick)
9ALOCNO
9AMATNR
Defined planning area with following key figures
SALE_HIST Sales history
9AREVFC Sales Forecast
9AMANUP Manual Correction
9ATOTFC Total Forecast
9APRICEFC Planned Price
T_PRICE Price
Storage bucket profile used is MONTH
Created time series and it is valid up to 31.12.2009
In BW, I have created a infosource/infocube with 9ALOCNO and 9AMATNR as character and SALE_HIST Sales history as key figure and OCALMONTH as time character. Uploaded data from excel and now I can see the data in infocube.
Now uploaded the data from BW to SAP-APO using - /SAPAPO/TSCUBE - Load Planning Area Version
Calculated proportional factor using /SAPAPO/MC8V - Calculate Proportional Factors.
In /SAPAPO/MSDP_ADMIN - Administration of Demand Planning and Supply Network, created chrematistics combination.
Created forecast profile with UA profile
Defined Planning book and data view
Defined macros in /SAPAPO/ADVM u2013 MacroBuilder
For calculating 9ATOTFC Total Forecast = Sales Forecast 9AREVFC + Manual Correction 9AMANUP
For calculating T_PRICE = 9ATOTFC * 9APRICEFC
Now I goto /SAPAPO/SDP94 - Interactive Demand Planning and search for my PB
I could see sale history filed is copied form BW.
Run Forecast and got the forecast in 9AREVFC.
Released the DP figures above to SNP using /SAPAPO/MC90 - Release to Supply Network Planning.
In /SAPAPO/SNP94 - Interactive Supply Network Planning, used std planning book/DV u2013 SNP94(1).
When I load I am getting the error as u201Cno key figure selection was foundu201D
Any clue where i am wrong?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
"no key figure selection was found" Hmm.... I am assuming you selected location product in your selection and loaded the data.
Few questions:
1. When you released the data to SNP, which category did you release the data to? was it FA?
2. "Released the DP figures above to SNP" What key figures did you release? you can select the relevant key figure in MC90.
3. Did you assign Location and Product characteristics in your DP POS?
You have to got to msdp_admin> your DP POS, Menu Edit>Assign product/Location.
Hi rajesha,
Do consitency check of Planning Area as well as Planning book.
1.Go to t-Code: /n/sapapo/msdp_admin
2. Double click on 9ASNP02
3. Go to extras, Constency Check
4. Initialize Planning Version (Constency Check for Existing Time Series Network)
5 Select Check box of Log, Repair & Check live cache anchor & Execute the transaction
6. Then do consitency check for Planning book also.
7. Then go to T-code: /n/Sapapo/sdp94, Check whether u r getting same error or not.
Hope it will help you
Regards
Sujay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Visu and Sujay
I could not get any advantage after doing all the steps mentioned. I will explain once again all the things i did as below, may be you may get some clue where i am wrong
In /SAPAPO/MSDP_ADMIN - Administration of Demand Planning and Supply Network
I have defined MOPS with following character(no SNP tick)
9ALOCNO
9AMATNR
Defined planning area with following key figures
SALE_HIST Sales history
9AREVFC Sales Forecast
9AMANUP Manual Correction
9ATOTFC Total Forecast
9APRICEFC Planned Price
T_PRICE Price
Storage bucket profile used is MONTH
Created time series and it is valid up to 31.12.2009
In BW, I have created a infosource/infocube with 9ALOCNO and 9AMATNR as character and SALE_HIST Sales history as key figure and OCALMONTH as time character. Uploaded data from excel and now I can see the data in infocube.
Now uploaded the data from BW to SAP-APO using - /SAPAPO/TSCUBE - Load Planning Area Version
Calculated proportional factor using /SAPAPO/MC8V - Calculate Proportional Factors.
In /SAPAPO/MSDP_ADMIN - Administration of Demand Planning and Supply Network, created chrematistics combination.
Created forecast profile with UA profile
Defined Planning book and data view
Defined macros in /SAPAPO/ADVM u2013 MacroBuilder
For calculating 9ATOTFC Total Forecast = Sales Forecast 9AREVFC + Manual Correction 9AMANUP
For calculating T_PRICE = 9ATOTFC * 9APRICEFC
Now I goto /SAPAPO/SDP94 - Interactive Demand Planning and search for my PB
I could see sale history filed is copied form BW.
Run Forecast and got the forecast in 9AREVFC.
Released the DP figures above to SNP using /SAPAPO/MC90 - Release to Supply Network Planning.
In /SAPAPO/SNP94 - Interactive Supply Network Planning, used std planning book/DV u2013 SNP94(1).
When I load I am getting the error as u201Cno key figure selection was foundu201D
User | Count |
---|---|
9 | |
4 | |
3 | |
2 | |
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.