converting 3 materials into one finished good

[Former Member]

hello experts,

i am trying to convert 3 materials into one finished good,but still getting three seperate values intead of accumulated value.

Transformation file looks as below

PLANT = 0PLANT

TIME    = 0FISCPER

FG       = ZMATERIAL

ACCOUNT = *NEWCOL(SALES)

CATEGORY = *NEWCOL(Actual)

conversion file looks like this

external              internal

Material1             FG_01

Material2             FG_01

Material3             FG_01

Material4             FG_02

Material5             FG_02

OUTPUT FILE.

1. PLANT1 -> 2010.01(TIME) -> FG_01 (Finished good) -> SALES - 20

2. PLANT1 -> 2010.01(TIME) - >FG_01 (Finished good) -> SALES - 30

3. PLANT1 -> 2010.01(TIME) - >FG_01 (Finished good) -> SALES - 40

         Here I am trying to get accumulated value of all the three records i.e SALES - 90.

How to achieve this?

Thanking you.

Praveen

[former_member190501 · Accepted solution]

Hi,

When you use /CPMB/LOAD_INFOPROV_UI to load data from BW infoprovider, in the 3rd screen system will ask you about "Handling of records in target" - Choose Append. So that you can see expected result in BPC cube.

Hope it helps...

regards,

Raju

[Former Member · Accepted solution]

Hi Raju, thanks for your reply.

       Material1, Material2,Material3 are sold to customers in the month of 2010.01. All these three Materials are collectively called as Finished good 1(FG_01). All these three Materials are related to PLANT1.

      I am trying to get the total sales volume of all the 3 Materials into one Finished good. In the above example,

     Material1 -> sales -> 20

     Material 2 -> sales -> 30

     Material 3 -> sales -> 40

Now the collective sales volume if seen in terms of Finished good (FG_01) is 90 Tonnes.

I tried to map all the materials with finished goods in conversion file only. This mapping is getting me three separated records instead of one collective value. 

How to achieve this?

Praveen

[former_member190501 · Accepted solution]

Hi,

In validation result you can see individual records with same material but once you load data into BPC with Append option it will consolidated as expecting.

Thanks,

Raju

[Former Member · Accepted solution]

Ok

Thank you

Praveen

[Former Member · Accepted solution]

Raju,

Inspite of using the "Append" button during run package, it still gave me three seperate records,

It worked on using the "Overwrite" Option.

Thank you

Praveen

[former_member186338]

Hi Praveen,

What do you mean by OUTPUT FILE?

Vadim

[Former Member]

Thanks Vadim,

Output file refers to the "Accepted records", after data validation. 

Praveen