Skip to Content
avatar image
Former Member

Dynamic record creation in SAP BW-IP

Dear experts,

I have a business scenario for which I need to create a planning report based on user selection of fields.

Assume that my planning query has three fields viz., Product, Period, Revenue.

User should be given with a blank layout with the drop down button for Product and Period.

User can select any Product / Period combination for which he wants to plan upon.

I cannot dynamically load the entire Product data with all the available periods.

Is there a way in which only the user selected Product/ Period alone is generated in the real time cube?

Many thanks in advance for your suggestions,


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 13, 2016 at 09:33 AM

    Hi Harish,

    I think you will have problems with the request to have the user selection by drop down.

    ou should rather have the user do the selection in variables and use these as filters in your query.

    Otherwise you will have problems with the locking and the number of combinations to be created.



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Indu,

      Yes, I can do that. But my problem is with huge master data and time periods. It's not the correct way to generate combination for all characteristic combinations.

      Br, Harish

  • Apr 19, 2016 at 09:29 PM

    Hi ,

    I'm not sure if you already figured out the solution . Here is what you need to do

    In Query designer, go to Product, Period and Revenue and select the option 'Master Data' or Characteristic Relationship in the 'Posted Values' setting.

    Once you do that, go to filter and set variables on each of the above Characteristics.

    This way the variables will pop up in the screen when you run the report.The values will be generated only for the selections made in the variables.



    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2016 at 06:44 PM

    Hi Harish,

    Are you using BPC10.1 for planning? It looks to be an easy option through EPM tab rather than a planning query. However You can create an input query with variables rather than drop down selection option from excel or you can also link your drop down options to input query variables so it can enable those rows for planning.



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Indu,

      Thanks for your reply.

      However we are using BW Integrated Planning for our scenario and BPC is not in the picture.

      Br, Harish