Understanding Filter Criteria

Filter criteria comprise field or dimension criteria combined with query or ledger criteria. They display a value from the query column results. You can combine filter criteria with label criteria to display a tree node or detail value as a descriptive label. Using nPlosion, one row or column of filter criteria can generate multiple detail rows or columns.

You can apply filter criteria at the column, row, or cell level.

Filter criteria consist of one or more tree detail values. If you select more than one value for your filter criteria, the total of all specified values is used to limit intersecting query or ledger criteria, and the results appear as one consolidated value. However, where multi-value filter criteria intersect with label criteria, the label values cannot be combined. Only the first label retrieved appears.

You can accept tree effective date when you define criteria. This option enables you to have multiple trees in the layout with different effective dates, and you can compare the results of the reports based on different effective dates. In addition, when you run a report request, you can specify a new effective date that overrides effective date of all trees if effective date was specified in the layout.

Note:

Accept tree effective date at the time of criteria definition is available only in nVision windows client.

When defining filter criteria, you can use detail values summarized under particular tree nodes, or detail values from value tables. If a value table is entered in filter criteria, it will be used for prompting and nPlosion labeling. During nPlosion, if some field values do not exist in the value table or if nVision cannot find corresponding labels in the value table for some field values, nVision will not include the amount for those values in the nPloded result.

Note:

If the value table specified for nPloded labels has an incomplete set of values, the total may differ from a non-nPloded total.