Skip to Content

BI Integrated Planning Input ready query - input characteristics values

Dec 07, 2016 at 03:50 PM


avatar image
Former Member


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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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


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.

10 |10000 characters needed characters left 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

wpnhm.png (46.1 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hello CC,

May I please know how you achieved this?

Please share the solution.

Thank you

Best Regards,