Skip to Content
0

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

Mar 15, 2017 at 09:16 AM

104

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Vadim Kalinin Mar 15, 2017 at 09:37 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Mark Dean Mar 15, 2017 at 01:27 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Mar 15, 2017 at 01:34 PM
0

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!

Share
10 |10000 characters needed characters left characters exceeded
Mark Dean Mar 15, 2017 at 02:25 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Mar 15, 2017 at 02:54 PM
0

"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.

Share
10 |10000 characters needed characters left characters exceeded