Month wise aggregation of InfoProvider Data with Transformation File

[former_member590808]

We have a MTD InfoProvider in BPC for fetching monthly Trial Balance.

Now, as per the requirement, we want to fetch aggregated month wise data for an annual year.

Example:

01.2017 should have MTD Jan SignedData.

02.2017 Signeddata should have 01.2017+02.2017

03.2017 should have sum total of 02.2017+03.2017(We are assuming that now 02.2017 will have aggregated data from Jan till Feb) and so forth for the months until December.

We were able to implement the required logic with help of Logic Script but now we have to avoid downloading the data. Is it possible to perform this aggregation while we fetch the records from the transformation file with Data Type "Transaction Data from Net Weaver BW InfoProvider" ? Can we implement it through conversion file ?

Thank you.

[former_member186338 · Accepted solution]

It's not possible to do it using transformation file. You can:

1. Write routine badi to be used during transformation and upload

2. You can create another infoprovider and using BW transformation convert data to YTD and then load from this infoprovider to BPC.

[former_member590808]

"What do you have in BW ?" We have an InfoProvider(ZCO_TRIAL) from which we want to pull trial balance data in BPC cube(X_PNL)

ZCO_TRIAL is MTD model and X_PNL is YTD.

We want to fetch month wise data from ZCO_TRIAL and display it in aggregated manner(as mentioned above) in X_PNL.

For loading the data, we have planned to use transformation file and data type as "Transaction Data from Net Weaver BW InfoProvider".

[former_member186338]

Sorry, but not clear!

What do you have in BW? What models you have in BPC?

How do you want to load data?