how the data extraction from pa to info cube..

[Former Member]

helo sir

could u plz tell me How the planning data extract from the planning area to info cube..

scenerio-- i have created a planning for this month. so this month planning data will become the history of future forecast.. in which way i have to extract the timeseries data to infocube...

can anybody tell me the procedure and steps plz...

thakz a lot

[Former Member · Accepted solution]

Hi dallyanusha,

Please use the below link which contains the detailed

procedure for extraction.

http://help.sap.com/saphelp_scm2007/helpdata/en/0e/d76f3bb8d0c433e10000000a114084/frameset.htm

Regards

R. Senthil Mareeswaran.

[Former Member · Accepted solution]

helo sir

good morning

that i know about the extract the data from r/3 .. am not asking this.. am asking about the planned data export to infocube how???

we are using rolling basis forecast.. so this month planned data becomes history of future. so i have to export the planned data to infocube.. that is How??

plz clarify my doubt sir???

[Former Member · Accepted solution]

Hi,

Check out help.sap.com in the link provided by Senthil. I've just copied here for your reference.

1. Generate an export DataSource for the planning area. To do so, proceed as follows:

a. On the SAP Easy Access screen, choose Demand Planning ® Environment ® Administration of Demand Planning and Supply Network Planning.

b. Select the planning area and, in the context menu, choose Change/Display.

c. In planning area maintenance, choose Extras ® Generate DataSource.

A dialog box appears in which you enter a name for the data source.

d. Choose Execute.

A screen with details for the data source appears.

e. Specify the fields that you want to be able to select later for reporting purposes. This step enables you to limit a query to specific objects or ranges of objects. Your selection here does not influence the fields that are included in the export structure. Select the Suppress field indicator for the fields (InfoObjects) that you do not want to transfer.

The number of fields that you transfer directly affects performance. Therefore, we recommend that you only transfer those fields that you require for reporting purposes in the InfoCube.

The field for the planning version is selected by default; you cannot deselect it. This means that you must enter a planning version in the InfoPackage later.

f. Make a note of the DataSource name.

g. Choose Save.

2. Replicate the DataSource. To do so, right mouse click the source system and choose Replicate DataSources in the Data Warehousing Workbench. In this case, the source system is the system in which you are performing Demand Planning. For example, if you are planning in the SAP SCM system, client 002, the technical name of the source system is APOCLNT002.

When the system messages at the bottom of your screen cease, a background job is triggered. Check in the job overview that this job has finished before proceeding to the next step.

3. In the Data Warehousing Workbench, you are still in the source system view. Right-click the source system and choose DataSources Overview in the context menu.

4. Assign an InfoSource to the DataSource: To do so, proceed as follows:

a. In the DataSource overview under Data Marts, select the DataSource and choose Assign InfoSource from the context menu.

b. In the dialog box, choose Create.

c. In the next dialog box, enter a name and a short description for the InfoSource.

d. When the InfoSource has been created, choose Enter.

e. Answer the system prompt with Yes.

This saves the InfoSource/DataSource assignment.

If the above procedure is unsuccessful, use the following alternative:

■ Switch to the InfoSource view.

■ Create an InfoSource (right-click a suitable InfoArea and choose Create InfoSource).

■ Right-click the InfoSource and choose Assign DataSource from the context menu.

A dialog box appears with an overview of all DataSources in the Data Mart, including the export DataSources you have generated yourself.

■ Select the DataSource you created in step 1.

5. In the Data Warehousing Workbench, branch to the InfoSource view.

6. Right-click the InfoSource that you have just created and choose Change.

The screen in which you can specify the assignment of the communication structure to the transfer structure appears. You see the communication structure in the upper half of the screen and the transfer structure in the lower half. Some of the assignment information is proposed by the system. You must fill in the missing information.

This is another opportunity to remove superfluous InfoObjects from the communication structure. See also step 1.

7. Define the assignment of the communication structure to the transfer structure. To do so, proceed as follows:

a. In the lower half of the screen, enter the source system and the DataSource for the transfer structure.

b. On the Transfer Structure tab page, copy the objects from the DataSource to the transfer structure (from right to left).

c. Click the Transfer Rule tab page.

d. Check where the assignment of transfer structure fields to communication structure InfoObjects is not proposed by the system.

e. Where the assignment has not been proposed:

i. Include new InfoObjects in the communication structure in the upper half of the screen.

ii. In the lower half of the screen, select the new InfoObjects in the communication structure on the left and copy the InfoObjects to the appropriate fields in the transfer structure on the right.

f. Choose Activate.

8. If you need an InfoCube to carry out reporting with a BI front end, create an SAP Remote InfoCube, specifying the InfoSource that you created in step 4 as the InfoSource.

Otherwise, see the note below.

9. Activate the SAP Remote InfoCube

Thanks,

Rajesh Manoharan

Edited by: RAJESH MANOHARAN on Nov 19, 2009 7:16 AM

[Former Member · Accepted solution]

Hi,

I am new to SNC and was trying to create a demo for one of the client. There are couple of scenario that cient want us to model and we are facing some issues here.

1. I am not able to interprete the Time Based disaggregation factor calculation logic on SNC RR - Forecasting. This disaggregaton factor is used to disaggregation the wekly forecast from forecast view to Shor Term Forecast in daily view. I am using the sales history in the Data Import control to generate the disaggregation factor. I have the following sale history in the previus month

Mon- 12

Tue -4

Wed - 230

Thur - 10000

Fri - 32

Sat - 1500

Sun - 230

and the disaggregation factor genarated for the new week are

Mon - 10.029 %

Tue - 10.010 %

Wed - 10.579 %

Thur - 35.025 %

Fri - 10.030 %

Sat - 13.754 %

Sun - 10.576 %

Can any one explain me the logic and if any other factor is considered for the caluclation how it is used and where it is maintained?

2. The 2nd issue is the key figure calculation . In the forecast Over view scree, we have the following key figure

a) Forecast - 100 Qty

b) Manually Changed Forecast - 130 Qty

c) Corrected Forecast - 130 Qty

What ever we enter in the manually changed forecast is populated in corrected forecast key figure. But the client want to enter only the delta in manually changed forecast and the same should be either added or reduced to the Forecast and then populated on corrected forecast. For example

a) Forecsat - 100 Qty

b) Manually Changed Forecast - +30 Qty

c) Corrected Forecast - 130 Qty

Can anyone let me know where we can change the key figure calculation logic?

It will be of great help. thanks