SAP BPC 7.5 Netweaver - BI Transaction Data to BPC

[Former Member]

Hi,

I have to add 0debit and 0credit in BI PCA cube to AMOUNT in BPC using transformation file.

Prefereably, want to use same data source(P_Datasrc) value and single transformation file.

BI transformation is the last option to avoid any issues after full optimization.

Could I use *MVAL in transformation for the above scenario?

Any other way in the start routine or end routine?

Regards,

[Former Member]

Hi Venkata,

*MVAL function allows you to use multiple time period columns. I don't think this may help your scenario. I my opinion you may need to use two transformation files to bring the data from BW cube to BPC. BPC is an account base model, I don't think you can load the data in two columns in BW cube using one transformation file.

Thanks

[Former Member]

Thanks for your reply.

I have done BI transformation to sum up debit and credit and used one single key figure in the tranformtion file.

Regards