Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Mar 15, 2017 at 09:37 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 15, 2017 at 01:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 15, 2017 at 01:34 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 15, 2017 at 02:25 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 15, 2017 at 02:54 PM

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

    Add comment
    10|10000 characters needed characters exceeded