cancel
Showing results for 
Search instead for 
Did you mean: 

BPC Transformation File

0 Kudos

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
Active Contributor
0 Kudos

Sorry, but what do you mean by:

"accommodate multiple categories for below like Actual, Plan"

Based on what????

What are you doing?

0 Kudos

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
Active Contributor
0 Kudos

Still unable to understand!

2 categories???

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

0 Kudos

yes,

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

former_member186338
Active Contributor
0 Kudos

"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
Active Contributor
0 Kudos

Please explain the business scenario...

0 Kudos

yes same KF

0 Kudos

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
Active Contributor
0 Kudos

It's impossible! Please read my second answer!

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member186338
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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

CATEGORY=CATEGORY

0 Kudos

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.