Skip to Content

how to define the dynamic columns in BPC for S/4 HANA

We need to create a planning application for 12 month planning, the category for the 12 month include both actual and planning data, the columns need to be dynamic for actual/plan according to the month we run the application. for example if the we run the application in April, the first three month need to be actual, while the rest of the months need to be plan, how can we define thus kind of query in query designer?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Apr 25 at 07:01 PM

    What client are you talking about?

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 26 at 02:08 PM

    We are using BPC for S/4 HANA which is embedded BPC, we fine the query using query designer, where we need to define the category as actual/planning depend on the month the users do their planning, for example if the month is April, the category value for the first three columns of Jan, Feb and Mar should be actual, while the rest of the month should be planning, the key point here is make the category value dynamic through the query variables. I am not sure how to achieve it here.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 27 at 10:27 AM

    The approach to achieve this is by using a number of query variables and calculated kf at the query level

    https://archive.sap.com/discussions/thread/1734499

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 30 at 02:45 PM

    I have go through the suggested link, looks like the key point is to create a variable to make the category value change to avctual/planning based on the system date. I did not find this information in that post, should we create a customer exit for that by using ABAP? anybody can through a light on this?

    Add comment
    10|10000 characters needed characters exceeded

    • Yes, variable type SAP-Exit. Within the exit you can read the other characteristics selections. It's all in table

      i_t_var_range. Simply do a read table using the info object category as key.

      The implementation should be triggered when step = 2 (i_step = 2).

  • Apr 30 at 07:32 PM

    Hi Jerry,

    Yes, a variable (SAP Customer) Exit has to be created for Period, which will hold the derivation for retrieving Category based on period of selection.

    Thanks,

    Harsha

    Add comment
    10|10000 characters needed characters exceeded