Special periods(13,14,15,16) data to be move to 012 period using routine and the moved to bpc

[Former Member]

Hi All,

Please help me.

Could you briefly explain how write the routine to move the special periods data to the 12th period.

Thanks in Advance..

RegardsJose

[Former Member]

Sure, provide more information. If you need to convert always a TIME Frame to Other TIME Frame 2, just create a new dimension and make a relationship. Or if you need its only for report porpose, just group by local members.

[Former Member]

Hi Daniel,

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

In ECC there are 16 periods, out which 4 are special periods.

And before sending to the BW info cube, the  special periods  13,14,15,16   data  to be moved to 12th period(last period of the Fiscal year) in BW. and later i need to move to consolidation model(YTD)  using DM

So could to please help me how to write the routine(logic) to move the special periods to the last period of Fiscal Year.

Thanks in Advance.

Regards

jose.

[Former Member]

Hello Jose, pls take into account that best practice is: 1. Model1 in BW must be as same data as ECC 2. Create Model2 on BW based on Model1 in order to have the possibility to change any new requirement from BPC Model in BW 3. In model2 créate rules to map TIME.12=TIME.13+TIME.14+TIME.15...etc from Model1 (use rules or abap) 4. In BPC model just créate 12 months through BPC Admin 5. Then Copy from model2 to BPC Model regards, dj

[former_member186338]

Sorry Jose,

But you have to provide more details - there is no general solution...

Why routine?

Vadim

[Former Member]

Hi Vadim,

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

In ECC there are 16 periods, out which 4 are special periods.

And before sending to the BW info cube, the  special periods  13,14,15,16   data  to be moved to 12th period(last period of the Fiscal year) in BW. and later i need to move to consolidation model(YTD)  using DM

So could to please help me how to write the routine(logic) to move the special periods to the last period of Fiscal Year.

Thanks in Advance.

Regards

jose.

[former_member186338]

Using Conversion file for TIME dimension simply map 13-16 to 12.

Vadim