Loading BPC data from anither BPC model

[Former Member]

Did anyonw has the experience to load BPC data from anither BPC model?

[Former Member]

I know we can use he script logic to load data from one cube to another one, I want to know if anybody has use the data package to load data from a BPC model.

[lucas_costa3]

Hi Jian,

This is pretty common.

You can create a package using process chain /CPMB/ALLOCATION or /CPMB/DEFAULT_FORMULAS - Changing the LOGICFILENAME parameter in advanced script.

And then all you need to do is define package.

i.e.: If you need to filter data, add the following lines advanced script of your package:

PROMPT(SELECTINPUT,%SELECTION%,,"Select the members","VERSION,TIME,ENTITY,BUS_AREA",0)

TASK(/CPMB/ALLOCATION_LOGIC,SELECTION,%SELECTION%)

Lucas

[Former Member]

Hi Jian,

You can use script logic to do a transport between the models.

Andy

[Former Member]

Hi Jian,

if both models are in the same environment, as Andy said, you could use script logic to copy data from one model to another (*DESTINATION_MODEL).

Alternatively, or if the two models are not in the same environment, you could use the standard ASCII export and import via the Excel front end.

BR,

Arnold