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

[Former Member]

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?

[former_member399404]

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

[Former Member]

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?

[lucas_costa3]

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

[lucas_costa3]

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

[Former Member]

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.

[former_member186338]

What client are you talking about?