Input-Ready Queries at Runtime

In planning applications that use input-ready queries as data providers, you can enter data manually at runtime.

Whether the cells in an input-ready query can be changed at execution depends on the query view and possibly on other settings (such as settings for data slices and characteristic relationships).

In terms of whether the cells of a query view are input ready, note the following rules:

1. In a query that is used for manual planning, a cell is only input ready if each characteristic value of all the characteristics included in the aggregation level is unique. This means that any values aggregated for the aggregation level are not input ready: Totals, subtotals and internal hierarchy nodes are not input ready.

2. To be able to change values for calculated key figures too (Average Price as a quotient of Amount and Quantity for example), they must be based on formulas, and at least one operand must be input ready.

3. To be able to change aggregated values (for the aggregation value), these values must be disaggregated on all data records that contribute to them.

4. If a query used for manual planning includes a navigation attribute that is restricted using a fixed or dynamic filter or a restricted key figure, the system treats the navigation attribute as a normal characteristic. The rule under point 1 applies here. If the navigation attribute is not restricted, the system responds as if the navigation attribute was not part of the query.

5. In a query that is defined on a MultiProvider or a complex aggregation level and is intended for use in manual planning, the cell is not input ready if the InfoProvider determined by this cell is:

   • Not a real-time InfoCube

   • A real-time InfoCube that has been switched to load mode

6. If an input-ready query is executed in change mode, but the requested data is locked by another user, the query starts in display mode.

   Note

   For more information about manually creating plan data, refer to the documentation for BEx Web Application Designer (section: Manually Planning Company Data), the documentation for BEx Analyzer under Manually Planning Company Data and under Functions for Manual Planning.