Load data InfoCube

[Former Member]

Hello guys,

I am trying load data to InfoCube of the BW/APO through of source system BW Corp.

But to the execute, some data not add in InfoCube.

Do you know what might be happening? Has anyone experienced this issue?

Thanks in advanced!

Augusto Peres

[Former Member]

Hi,

Be sure you have the correct infopack when loading..

[Former Member]

Hi Augusto,

please try this way.

1.1.1 FC Building Block 1 u2013 Preparation and Basic Setup

1. Create Info Objects

2. Create Info Object Catalog

3. Create InfoCube

4. Load InfoCube

5. Create Storage Buckets Profile

6. Create Master Planning Object Structure

7. Create Planning Area

8. Create Characteristic Value Combinations

9. Create Planning Buckets Profile

10. Planning Book Design

11. Create Forecast Profiles

1.1.1.1 Step 1: Create Info Objects

Info Objects are the main elements of any planning area. They are used to define characteristics and

key figures of planning areas, irrespective of the way the data is stored (i.e. in liveCache or in an

InfoCube). The first step is to create these Info Objects. Before starting with the creation of the Info

Objects, check whether the Info Area u201CAPOTRAININGu201D is set up. If this is not the case, it needs to

be created. Create the following Info Objects as described with dd being your initials.

From the APO tree structure, select Demand Planning > Environment > Current Settings >

Administrator Workbench

􀂉 Check whether the Info Area u201CAPOTRAININGu201D is listed on the right side of the screen. The

entries might not be in alphabetical order. If the Info Area does not exist, follow these tasks

else proceed to the next step.

u21D2 Select the u201CData Targetsu201D node (not the header line) on the right side of the screen and

activate the context sensitive menu.

u21D2 Select u201CCreate Info Areau201D.

u21D2 Define the Info Area name (APOTRAINING) and a long description.

u21D2 Press the <Enter> pushbutton.

􀂉 Press the <Maintain Info Objects> pushbutton (Shift F8) on the button bar.

􀂉 Specify the Info Objects listed below, select their type and press the <Create> pushbutton.

Select u201CAPOu201D (and not u201CBWu201D) on the next pop-up window. Press <Activate> and <Return>

after the creation of each characteristic.

u21D2 Select Type u201CCharacteristicu201D and create the following Characteristics:

o Characteristic Long Description. Reference Char. Data Type Length

TddCH01 Product 9AMATNR

TddCH02 Product Group Char 7

TddCH03 Location 9ALOCNO

My First Plan 9

TddCH04 Country Char 2

TddCH05 Customer Char 7

TddCH06 Customer Group Char 7

u21D2 Select Type u201CKey Figureu201D and create the following Key Figures:

o Key Figure Long Description Type Data Type Fix UoM

TddKF01 Historical Data Quantity QUAN PC

TddKF02 Key Figure 02 Quantity QUAN PC

TddKF03 Key Figure 03 Quantity QUAN PC

TddKF04 Key Figure 04 Quantity QUAN PC

TddKF05 Base Forecast Quantity QUAN PC

TddKF06 Promotion Quantity QUAN PC

TddKF07 Corrected History Quantity QUAN PC

TddKF08 Corrected Forecast Quantity QUAN PC

TddKF09 Ex-Post Forecast Quantity QUAN PC

TddKF10 Total Forecast Quantity QUAN PC

􀂉 Leave the Administrator Workbench.

1.1.1.2 Step 2: Create Info Object Catalog

In this subsequent step the previously created Info Objects are grouped in Info Object Catalogs.

This is an optional step. Using an Info Object Catalog helps easily identify u201Cownu201D Info Objects and

speeds up subsequent tasks.

From the APO tree structure, select Supply Chain Planning > Demand Planning > Environment >

Current Settings > Administrator Workbench

􀂉 Press the <Edit Info Objects> pushbutton (Shift F5) on the button bar.

􀂉 Press the <Info Object Catalog> pushbutton (Ctrl F6) on the button bar.

􀂉 Specify the name of the new catalog (TddCHC for the Characteristics) and press the <Edit>

pushbutton.

􀂉 Enter the name (TddCHC) and a description for the catalog of the characteristics.

􀂉 Specify the Info Object Type u201CCharacteristicsu201D, the Info Area u201CAPOTRAININGu201D, and select

u201CCreateu201D. Do not use a template.

􀂉 Using the <Transfer Fields> pushbutton, copy the desired characteristics (the newly created

ones in the previous step) from the template to the structure. Once all Characteristics are added

to the Info Object Catalog select <Activate> and <Back>.

􀂉 Repeat the previous steps for all Key Figures accordingly (name for the Key Figures Catalog is

TddKFC and Info Object Type is u201CKey Figureu201D).

􀂉 Leave the Administrator Workbench.

1.1.1.3 Step 3: Create InfoCube

My First Plan 10

The InfoCube is used to store historical data. It can only be read, and consequently, the forecast is

not written into the InfoCube based key figures, but into liveCache based key figures.

Subsequently, the InfoCube will be linked to the planning area.

From the APO tree structure, select Supply Chain Planning > Demand Planning > Environment >

Current Settings > Administrator Workbench

􀂉 Activate the context sensitive menu on Info Area u201CAPOTRAININGu201D and select u201CCreate

InfoCubeu201D. Enter a name (TddIC) and a description for the InfoCube and select <Create>.

􀂉 Select u201CBWu201D as your choice of BW application (do not use APO!) and select <Continue>.

􀂉 Select the Characteristics tab.

􀂉 Choose the characteristic u201C9AVERSIONu201D to be included in the structure. Transfer the

characteristic from the template to the structure using the <Transfer Fields> pushbutton in the

middle of the screen.

􀂉 Select the characteristics from your Info Object catalog by clicking on the Info Object catalog

icon in the upper right corner and double clicking on the name of the Info Object catalog

TddCHC.

􀂉 Confirm the u201CTransfer Fields Automaticallyu201D query with u201CYesu201D. This copies all Characteristics

of your catalog into your InfoCube automatically.

􀂉 Click on the <Dimensions> pushbutton.

􀂉 Create four dimensions; one for the version, and the others for the other characteristics. You do

not need to create dimensions for time characteristics or units; these are created automatically.

o Select the <Create> pushbutton and define a dimension description. Repeat this step for all

dimensions.

Dimension Characteristic 1 Characteristic 2

Planning Version 9AVERSION

Product TddCH01 TddCH02

Location TddCH03 TddCH04

Customer TddCH05 TddCH06

o Then click on the Assign tab.

o Select the characteristic you want to assign. To do so click on the check box of the

respective characteristic and place the cursor on the dimension to which you wish to

assign it and click on the <Assign> pushbutton. After all characteristics are assigned to

dimensions, select <Continue>.

􀂉 Click on the Time Characteristics tab.

􀂉 Transfer the Time Characteristics u201C0CALMONTHu201D and 0CALWEEKu201D from the template to

the structure.

􀂉 Click on the Key figure tab.

􀂉 Select the key figures u201CTddKF01u201D through to u201CTddKF04u201D and press the <Transfer Fields>

pushbutton (do not transfer all your previously created key figures!)

􀂉 Choose <Activate>, <Back> and confirm the u201CSaveu201D query (if any).

􀂉 Leave the Administrator Workbench.1.1.1 FC Building Block 1 u2013 Preparation and Basic Setup

1. Create Info Objects

2. Create Info Object Catalog

3. Create InfoCube

4. Load InfoCube

5. Create Storage Buckets Profile

6. Create Master Planning Object Structure

7. Create Planning Area

8. Create Characteristic Value Combinations

9. Create Planning Buckets Profile

10. Planning Book Design

11. Create Forecast Profiles

1.1.1.1 Step 1: Create Info Objects

Info Objects are the main elements of any planning area. They are used to define characteristics and

key figures of planning areas, irrespective of the way the data is stored (i.e. in liveCache or in an

InfoCube). The first step is to create these Info Objects. Before starting with the creation of the Info

Objects, check whether the Info Area u201CAPOTRAININGu201D is set up. If this is not the case, it needs to

be created. Create the following Info Objects as described with dd being your initials.

From the APO tree structure, select Demand Planning > Environment > Current Settings >

Administrator Workbench

􀂉 Check whether the Info Area u201CAPOTRAININGu201D is listed on the right side of the screen. The

entries might not be in alphabetical order. If the Info Area does not exist, follow these tasks

else proceed to the next step.

u21D2 Select the u201CData Targetsu201D node (not the header line) on the right side of the screen and

activate the context sensitive menu.

u21D2 Select u201CCreate Info Areau201D.

u21D2 Define the Info Area name (APOTRAINING) and a long description.

u21D2 Press the <Enter> pushbutton.

􀂉 Press the <Maintain Info Objects> pushbutton (Shift F8) on the button bar.

􀂉 Specify the Info Objects listed below, select their type and press the <Create> pushbutton.

Select u201CAPOu201D (and not u201CBWu201D) on the next pop-up window. Press <Activate> and <Return>

after the creation of each characteristic.

u21D2 Select Type u201CCharacteristicu201D and create the following Characteristics:

o Characteristic Long Description. Reference Char. Data Type Length

TddCH01 Product 9AMATNR

TddCH02 Product Group Char 7

TddCH03 Location 9ALOCNO

My First Plan 9

TddCH04 Country Char 2

TddCH05 Customer Char 7

TddCH06 Customer Group Char 7

u21D2 Select Type u201CKey Figureu201D and create the following Key Figures:

o Key Figure Long Description Type Data Type Fix UoM

TddKF01 Historical Data Quantity QUAN PC

TddKF02 Key Figure 02 Quantity QUAN PC

TddKF03 Key Figure 03 Quantity QUAN PC

TddKF04 Key Figure 04 Quantity QUAN PC

TddKF05 Base Forecast Quantity QUAN PC

TddKF06 Promotion Quantity QUAN PC

TddKF07 Corrected History Quantity QUAN PC

TddKF08 Corrected Forecast Quantity QUAN PC

TddKF09 Ex-Post Forecast Quantity QUAN PC

TddKF10 Total Forecast Quantity QUAN PC

􀂉 Leave the Administrator Workbench.

1.1.1.2 Step 2: Create Info Object Catalog

In this subsequent step the previously created Info Objects are grouped in Info Object Catalogs.

This is an optional step. Using an Info Object Catalog helps easily identify u201Cownu201D Info Objects and

speeds up subsequent tasks.

From the APO tree structure, select Supply Chain Planning > Demand Planning > Environment >

Current Settings > Administrator Workbench

􀂉 Press the <Edit Info Objects> pushbutton (Shift F5) on the button bar.

􀂉 Press the <Info Object Catalog> pushbutton (Ctrl F6) on the button bar.

􀂉 Specify the name of the new catalog (TddCHC for the Characteristics) and press the <Edit>

pushbutton.

􀂉 Enter the name (TddCHC) and a description for the catalog of the characteristics.

􀂉 Specify the Info Object Type u201CCharacteristicsu201D, the Info Area u201CAPOTRAININGu201D, and select

u201CCreateu201D. Do not use a template.

􀂉 Using the <Transfer Fields> pushbutton, copy the desired characteristics (the newly created

ones in the previous step) from the template to the structure. Once all Characteristics are added

to the Info Object Catalog select <Activate> and <Back>.

􀂉 Repeat the previous steps for all Key Figures accordingly (name for the Key Figures Catalog is

TddKFC and Info Object Type is u201CKey Figureu201D).

􀂉 Leave the Administrator Workbench.

1.1.1.3 Step 3: Create InfoCube

My First Plan 10

The InfoCube is used to store historical data. It can only be read, and consequently, the forecast is

not written into the InfoCube based key figures, but into liveCache based key figures.

Subsequently, the InfoCube will be linked to the planning area.

From the APO tree structure, select Supply Chain Planning > Demand Planning > Environment >

Current Settings > Administrator Workbench

􀂉 Activate the context sensitive menu on Info Area u201CAPOTRAININGu201D and select u201CCreate

InfoCubeu201D. Enter a name (TddIC) and a description for the InfoCube and select <Create>.

􀂉 Select u201CBWu201D as your choice of BW application (do not use APO!) and select <Continue>.

􀂉 Select the Characteristics tab.

􀂉 Choose the characteristic u201C9AVERSIONu201D to be included in the structure. Transfer the

characteristic from the template to the structure using the <Transfer Fields> pushbutton in the

middle of the screen.

􀂉 Select the characteristics from your Info Object catalog by clicking on the Info Object catalog

icon in the upper right corner and double clicking on the name of the Info Object catalog

TddCHC.

􀂉 Confirm the u201CTransfer Fields Automaticallyu201D query with u201CYesu201D. This copies all Characteristics

of your catalog into your InfoCube automatically.

􀂉 Click on the <Dimensions> pushbutton.

􀂉 Create four dimensions; one for the version, and the others for the other characteristics. You do

not need to create dimensions for time characteristics or units; these are created automatically.

o Select the <Create> pushbutton and define a dimension description. Repeat this step for all

dimensions.

Dimension Characteristic 1 Characteristic 2

Planning Version 9AVERSION

Product TddCH01 TddCH02

Location TddCH03 TddCH04

Customer TddCH05 TddCH06

o Then click on the Assign tab.

o Select the characteristic you want to assign. To do so click on the check box of the

respective characteristic and place the cursor on the dimension to which you wish to

assign it and click on the <Assign> pushbutton. After all characteristics are assigned to

dimensions, select <Continue>.

􀂉 Click on the Time Characteristics tab.

􀂉 Transfer the Time Characteristics u201C0CALMONTHu201D and 0CALWEEKu201D from the template to

the structure.

􀂉 Click on the Key figure tab.

􀂉 Select the key figures u201CTddKF01u201D through to u201CTddKF04u201D and press the <Transfer Fields>

pushbutton (do not transfer all your previously created key figures!)

􀂉 Choose <Activate>, <Back> and confirm the u201CSaveu201D query (if any).

􀂉 Leave the Administrator Workbench.

Regards,

Srinivas

[Former Member]

Hi,

Welcome to SDN.

Pls provide more information on your setup for us to be able to help you.

Generic tips:

To check for errors. Go to the cube --> right click --> manage --> there will be either a red or yellow or green colour light, just a column before that you will see a monitor icon. Click on that, this will give you error details.

Thanks

Mani