Skip to Content
0
Jun 06, 2016 at 02:56 PM

Importing Multiple Categories and Running Default Script

46 Views

Hi Experts

I’d like to modify our existing Default logic to allow for the import of multiple categories from a cube in one import.

I know there’s a limitation as noted in the note: http://service.sap.com/sap/support/notes/1498049

That limits account transformation (ABC) to one category.

Is this still the case? We are using BPC NW 10.1 SP09 on BW7.4 This note is from 12/8/2010.

One alternative is to run the import one category at a time.

Any other ideas?

The main part of the default script is below – green notes where we attempted to shift from the stand-alone Category to part of the OTHER statement.

Issue I’m encountering is that even when running the import for one Category the default script updates other categories e.g. import ESTIMATE data the default script runs for ACTUAL…

Thank you.

*RUN_PROGRAM CALC_ACCOUNT

CATEGORY = %CATEGORY_SET%

CURRENCY = LC,USD,EUR

TID_RA = %TIME_SET%

CALC = NETINCOMESPLIT2

//OTHER = [CATEGORY = %CATEGORY_SET%;ENTITY = %ENTITY_SET%;INTERCO = %INTERCO_SET%;BANK = %BANK_SET%;TC = %TC_SET%;COST_CENTER = %COST_CENTER_SET%;ACTIVITY = %ACTIVITY_SET%;SUBGLOBALRGN = %SUBGLOBALRGN_SET%;ACTIVE_INGREDIEN = %ACTIVE_INGREDIEN_SET%;COUNTRY = %COUNTRY_SET%]

*ENDRUN_PROGRAM

*COMMIT

//-------------------------------------------------------------------------------------------------------------------------------------------------------------------------

// Calculating F15 - net variation as the difference between closing and the sum of other balance sheet flows

//-------------------------------------------------------------------------------------------------------------------------------------------------------------------------

*RUN_PROGRAM CALC_ACCOUNT

CATEGORY = %CATEGORY_SET%

CURRENCY = LC,USD,EUR

TID_RA = %TIME_SET%

//OTHER = [CATEGORY = %CATEGORY_SET%;ENTITY = %ENTITY_SET%;INTERCO = %INTERCO_SET%;BANK = %BANK_SET%;TC = %TC_SET%;COST_CENTER = %COST_CENTER_SET%;ACTIVITY = %ACTIVITY_SET%;SUBGLOBALRGN = %SUBGLOBALRGN_SET%;ACTIVE_INGREDIEN = %ACTIVE_INGREDIEN_SET%;COUNTRY = %COUNTRY_SET%]

// MODIFICATION DEV - FOR MULTIPLE CATEGORY IMPORT

//OTHER = [CATEGORY = %CATEGORY_SET%;ENTITY = %ENTITY_SET%;INTERCO = %INTERCO_SET%]

CALC = TBS

*ENDRUN_PROGRAM*ENDRUN_PROGRAM

Regards,

Eyal