Fields in Input Ready Query and Aggregation Level

[former_member190408]

Hi All - New to IP. What if we dont include all the fields of Aggregation level in Input Ready Query.

Supose there are 4 fields in Aggregation level and we are including only two in Input Ready Query.

[former_member210674 · Accepted solution]

Hi Harry,

For a Keyfigure to be input ready, all the characteristics of the Aggregation should be filled with some values at the time of input.

The characteristics should be either in Static Filter, Dynamic Filter, Row, Column. New Selection.

If a characteristic is not there in any of the above area then it is considered to be null and query will not be input ready.

Regards,

Gopi R

[Former Member]

The sole purpose of creating an Aggregation Level is missed if you omit some characteristics for your input ready query.

As said by experts above, your query will not be input ready.

Br, Harish

[cornelia_lezoch]

if your "field" is a characterictic, your query will not be input enabled. or you need to use disaggregation

if the "field" is navigation attribute or key figure it is no problem

[former_member190408]

Hi - Thanks for inputs fields will be characteristics only.