BPC Transformation File

[former_member767725]

Hi All,

Question 1:

How do we change *NEWCOL keyword to accommodate multiple categories for below like Actual, Plan

Transformation file :

*MAPPING

MM_ACCOUNT=BACM_MM

CATEGORY=*NEWCOL(ACTUAL)

...

...

*CONVERSION

Question 2:

How do we change *STR keyword to accommodate multiple categories for below like Actual, Plan

Transformation file :

*MAPPING

MM_ACCOUNT=BACM_MM

CATEGORY=*STR(ACTUAL)

...

...

*CONVERSION

[former_member186338]

Sorry, but what do you mean by:

"accommodate multiple categories for below like Actual, Plan"

Based on what????

What are you doing?

[former_member767725]

Hi Vadim

I meant to say i want to include PLAN category along ACTUAL inside these so that it takes 2 categories like

*NEWCOL(ACTUAL, PLAN) => can i do something like this ?

*STR(ACTUAL, PLAN) => can i do something like this ?

or do i have create separate transformation files for each category in the DMP packages ?

Regards

[former_member186338]

Still unable to understand!

2 categories???

You want to load same data to ACTUAL AND Plan??

[former_member767725]

yes,

same data to both ACTUAL and PLAN via same transformation file.

[former_member186338]

"yes,

same data to both ACTUAL and PLAN via same transformation file."

strange idea from common sense point of view....

Same figures in PLAN and ACTUAL??

[former_member186338]

Please explain the business scenario...

[former_member767725]

yes same KF

[former_member767725]

Scenario is that we have to run depreciation for 2 categories PLAN 1 and PLAN 2.

it is a custom DMP that runs for PLAN 1, we want to include 2nd category PLAN 2 in the transformation file

[former_member186338]

It's impossible! Please read my second answer!

[former_member186338]

Each record from BW can be loaded to ONLY one record in BPC model! You can't generate 2 records (ACTUAL and PLAN) from single record.

But to my mind it's a bad idea to load from BW to 2 categories.

Load to ACTUAL and copy loaded data using BPC copy or script logic to PLAN.

In this case you will be sure that data is identical in both categories.

[former_member186338]

If you are loading from text file then have CATEGORY column in the text file filled with ACTUAL or PLAN and use:

CATEGORY=CATEGORY

[former_member767725]

i am loading from BW infoprovider that do not have CATEGORY.

so in transformation file we want to assign category = ACTUAL and PLAN and load the dataset to both actual and plan.