Show TOC

Determining the Effective Time FilterLocate this document in the navigation structure

The system determines the area in which a query displays data on a non-cumulative InfoCube as follows:

  1. In general, the times are projected onto the most detailed time characteristic that occurs in the query.

  2. The effective time filter is determined. The system calculates the set of all the time points from the static filter of the query. Global filters and structure elements that contain non-cumulative key figures are included here. The resulting set of time points from the static filter intersects the set of time points from the dynamic filter.

  3. The validities are still taken into consideration. The query only displays non-cumulative values for time points, which are within the validity area for at least one cell in the query.

  4. Separate validities are calculated for cells without constant selection and for cells with constant selection. A query can contain a maximum of two validity areas: one for cells without constant selection and one for cells with constant selection. The validity area for cells without constant is not influenced by the cells with constant selection. However, the validity area for cells with constant selection is influenced by the validity of cells without constant selection. There are two reasons for this:

    • The constant selection does not create objects. This means that constant selection cannot create new cells in the result. The validity of cells with constant selection therefore cannot influence cells without constant selection.

    • Constant selection is often chosen to display a comparison value. The validity of cells without constant selection therefore also applies to cells with constant selection.

    More information: Constant Selection