SAP BPC Consolidation data movement from ECC

[Former Member]

Dear All,

We are moving consolidation data from ECC to BW and then BW to BPC Model. My requirement is as below;

The below record transaction is with Inter-company postings (Trading Partner). this will be from BW info-cube to BPC model

Account	Entity	Flow	Intercompany	SIGNED-DATA
XYZ	1000	F20	2000	12345.00

While creating the above line, we need one more line with "INONE" as a inter-company below for the same signed-data.

Account	Entity	Flow	Inter-company	SIGNED-DATA
XYZ	1000	F20	INONE	12345.00

Can we right transformation file to create the line with INONE ?? If yes how do we create.

Please guide me on the same.

Thanks,

Raja

[Former Member]

Hello JP, Rahul & Gresh,

I agree with performance issue on the default logic. Since the company group is small (only 4 company codes with medium volume), currently need not to worry on the data volume and performance.

We don't want to change data's of BW. it is base for many other reports for us. that's why chose this option.

Will keep posted the progress and testings.

Thank you so much for all the options and suggestions.

Regards,

Raja

[Former Member]

Ok....Default will also impact your input forms performance as it is triggered everytime you will input and overwrite existing data again. I don't recommend tho use default logic for this case! Better to use conversions then!

And what if the company codes and data increase in future???

Regards,

JP

[Former Member]

ok...Conversions rule is not posting 2 lines. Which ever is the first conversion rule, it is taking that....second line is not posting entry.

Can you guide me what to do in conversions.

Raja

[former_member186338]

With proper filter in *IS xxx the effect will be minimal!

[Former Member]

Hope you have created 2 transformation files as I suggested. Can you show me the screenshots of the transformation file and conversion file?

JP

[Former Member]

JP & Gresh,

What I am planning to do is, created one "DEFAULT" logic script, which will be prompted during my data manager package run while BW to BPC model data movement. In that script logic i have coded to post the addition line for INONE also.

Tested and working.

Thanks for the suggestions.

Raja

[former_member225135]

Hi Raja,

Default logic will run whenever you will store data in BPC. As you have specific requirement of moving data while loading data from Ecc only, I would say that don't use default logic. Instead ask user to run package.

Regards,

Rahul

[Former Member]

Hi Raja,

Using default logic while running package will have performance impact also apart from what Rahul has suggested. It will affect data loading. I feel the approach suggested by Gersh is good and will not affect the performance in any way. If you have the option to make some additions in BW, then this is the ideal solution...instead of going for BPC ETL. BPC ETL is not as flexible as BW ETL.

Regards,

JP

[Former Member]

Hello Gersh,

Please explain me, how it can be done..

Thanks for your reply.

Raja

[Former Member]

Raja,

All the 3 approaches suggested by us are workable in your case

1. In BW cube, using BW transformations if you can load the intercompanyINONEby copying the record then in BPC you just have to load the records...nothing else is needed.

2. You can write a script logic to copy records on INONE. Trigger it while loading data.

3. In BPC, you can write 2 transformation file and load the data twice with each transformation file.

in 1st Transformation file - give all the mappings as required to load. Load the data with all intercomapny as it is.

in 2nd transformation file - keep the same transformation file but only for Intercompany dimension write a conversion file and mention it in Conversion section. The conversion file should be...

External       Internal

*                  INONE

Hope this helps...

Regards,

JP

[Former Member]

Hi Raja,

In your BW Transformation you have a button "Rule group". If you click it, you'll see option for a "New Group". Choose that one and in that group make all same assignments as in Standard group except Inter-company where you can assign constant INONE. This will create 2 records from every incoming record.

Nothing should be changed in load from BW to BPC.

Regards,

Gersh

[Former Member]

Thanks for the Reply Gersh, Rahul & JP.

@ Gresh ~ Not in BW cube, in BPC Model I need to do.

@ Rahul ~ yes I am testing that workaround.

@ JP ~ INONE is the super set of all inter-company values and non inter-company values.

So Data's with only inter-company transactions should be copied and posted with INONE as interco dimension.

[Former Member]

Hi Raja,

Not clear to me....INONE is the super set of all inter-company values and non inter-company values. So if there is no intercompany then you are using INONE?

and in the BPC cube you should have 2 records with same signedata... i.e Is this correct?

XYZ

1000

F20

2000

12345.00

XYZ

1000

F20

INONE

12345.00

[Former Member]

Hi Raja,

If you have those records in BW cube then loading them to BPC cube is a piece of cake:)

-Gersh

[Former Member]

Hi Raja,

Is it that all the records with intercompany have to be replicated with INONE as IC? But what is the reason behind this? Do you have to replicate each record or only specific?

You can use conversion file too...

Regards,

JP

[former_member225135]

Hi Raja,

Other workaround may be to write a script logic to copy the intercompany to INONE.

Regards,

Rahul

[Former Member]

Hi Raja,

Would it be fine having records with INONE in BW cube? If it's fine, then adding additional Rule in Transformations should be pretty simple.

Regards,

Gersh