Skip to Content
avatar image
Former Member

BI Integrated Planning Input ready query - input characteristics values

Hi,

I have created a real-time cube with characteristics and a key figure. The aggregate level is also built similarly. Now there is never going to be an actuals data load in this cube and this is purely a planning cube. When I build my query in Bex - checking the 'open query in change mode' and 'input ready' for the key figure, and run the query in Analysis for office, I get a message ' No applicable data found'.

How do I get a default layout that lets me input values for the Characteristics AND the key figure? And then I can start saving these planned values for both Characteristics & Key figures in the relevant cube.

I have read the documents on creating input query on real time cubes but they don't address my requirement of having a layout to update Characteristic values (example Country) to the Cube that is loaded no other way.

Thanks for your answers

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 08, 2016 at 01:00 PM

    Hi,

    You have some options (all of them are as prerequisite step):

    1. Change the mode of the cube to "loading" and load via ETL desired combinations. Then set cube mode to "planning"

    2. Use IP standard function (Generate Combinations) to generate desired combination (note that you will get Cartesian multiplication of all mater data values combination)

    3. Use IP FOX formula to generate desired combinations.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 08, 2016 at 01:17 PM

    Thanks Andrey,

    Can you please elaborate on the IP standard function (Generate Combinations)?

    What I want is, a tabular form of Query structure with all fields as input ready (with value help) even when the cube is empty to begin with.

    example: The picture below depicts the requirement -

    There is a value help for the characteristics Product Group and Material (Sales). The Key figures are also input ready. I want the users to be able to put in all the data manually when they run the query

    Add comment
    10|10000 characters needed characters exceeded