cancel
Showing results for 
Search instead for 
Did you mean: 

Loading planning data into BW.

Former Member
0 Kudos
125

Hi Gurus,

How the data is taken from the planning system to BW.. Whether its loaded fom planning cubes directly to Reporting cubes or flat files are used?

Is planning done in same BW or a different box is used?

Please help me.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Planning system is not a separate system as such. It uses the cubes present in BW. You can create a flow from planning cubes to reporting cubes. You can include this load in process chain as well.

Bindu

Former Member
0 Kudos

Hi Bindu, Thanks for your quick response. Can you tell me the steps how to load the data or can you send me a link which contains steps to load the data. Please help me, I am new to planning.

Former Member
0 Kudos

Hi,

Are you in BW3.5 or BI7.0?

If it is BW3.5, Create an update rule from the planning cube to the reporting cube. First you need to switch the planning cube to loading mode, then schedule the package. After the load is done, you need to switch back the cube to planning mode.

If you are in BI7.0, you have to create transformations. Loading process is the same.

This sequence

switching to load mode

load

switching back to plan mode

can be included in process chains which depends on how frequently you want to load data.

Bindu

Former Member
0 Kudos

Thanks a lot Bindu for your valuable answer.