Data conversion from Periodic to YTD and then moved to BPC

[Former Member]

Hi All,

Could you please help me..

How to convert the data from periodic to YTD in  BW  side before we send  to BPC

Do we required any logic to be written to convert Periodic to YTD in bw

Thanks in Advance

Jose

[Shrikant_Jadhav]

Hi Jose,

It depends on your source data structure, you can covert it by using routines.

First confirm why do you want to convert data from periodic to YTD, if you model type is periodic, you get YTD data as standard measures functionality of BPC.

IF your model model type is YTD then you need to convert it YTD.

The complexity depend on source data structure.

Shrikant 

[Former Member]

Hi Shrikanth,

I am Extracting the data from ECC, using the data source 3FI_GL_2L_TT (IFRS-non leading ledgers).

Once the data is extracted to  BW,and before sending to  info cube,i need to convert the  data from Periodic to YTD, and later i need to send to  BPC  Consolidation model ( YTD).

Could to please help me how to write the routine logic  brifely

Thanks in Advance.

Regards

jose.

[Former Member]

Hi Jose,

Please have a look at the following doc. It will work with BPC 10.

load data from ECC to BW, then in your transformation file (which you need to load data from BW to BPC) you can do the YTD calculation and post to BPC.

You need ABAP skills to do this.

Andy