What is the best suggestion to load BW periodic data to BPC YTD model

[mark_dean]

Hi all,

I have been instructed to build a BW staging area (transaction data coming from up to 14 InfoCubes) that loads a BPC YTD model.

I have 4 queries over Multiprovider's and single InfoCubes that output data in the same structure / format in periodic time. I am using these queries flagged as InfoProviders that write to a Direct Update DSO (output of queries match correct aggregation level and key of DSO).

This DSO will then be used to load the YTD BPC model. The number of records passed each day through this load process could be greater than 100,000.

My question is where is the best place to perform the Periodic to YTD conversion. I think I have 3 options as listed below. Please also suggest an alternative if relevant.

1. Perform conversion in queries themselves (4 sets of duplicate conversions across the 4 queries.

2. Have 4 transformations containing same ABAP between Query sources and Direct Update DSO.

3. Use BPC script logic between the Direct Update DSO and the YTD BPC infocube.

Thanks very much for any help on this.

Kind regards

Mark

[former_member186338]

"name of a typical BADI" - you have to write it yourself (custom logic badi)! There are no typical badi's for periodic->ytd conversion.

But first try to perform conversion using script logic and only if performance is not OK, continue with badi.

[mark_dean]

Thanks Vadim and I agree. Would you know the name of a typical BADI I could use as I want to do the conversion in NW? The data is going to a standalone Finance model and does not interact with any other BPC models.

[former_member186338]

In general it's better to have single source of data in bpc. In this case you will not have differences between ytd and periodic 🙂

For example in bpc you perform planning in periodic and reporting in ytd. You can load periodic and convert to ytd using script or badi. Or vise versa!

[mark_dean]

Thanks as usual for your prompt answer Vadim. I don't quite understand your question. All the transaction data to be loaded from BW is periodic. All of this data must be converted to YTD as target BPC model is marked as YTD storage.

Thanks

[former_member186338]

What is you primary data in BPC - YTD or Periodic?