Aggregation expressions are determined by the following properties:
Suppose that in the time series database there are N identifying dimensions, and in the aggregation filter M of them are set.
On setting the element it is allowed to use N, N+1, N-M or N-M+1 parts in the expression:
On specifying N parts it is considered, that the user specified all dimensions, and for this element the filter is not used. Example: {Albania|BCA} or {{Country}|BCA} (with parameter).
On specify N+1 parts it is considered, that the user specified all dimensions + calendar level. For this element the filter is not used. Example: {Albania|BCA|Q}.
On specifying N-M parts it is considered, that the user specified only those dimensions, which are not in the filter. Example: {BCA}, filter contains Country dimension.
On specifying N-M+1 parts it is considered, that the user specified only those dimensions, which are not in the filter + calendar level. Example: {BCA|Q}, filter contains Country dimension.
If M=1, and in the element N parts are specified, the attempt of "a" variant analysis is performed. If it is unsuccessful, the attempt of "d" variant analysis is performed. There is a pitfall here: if the last specified dimension contains A, S, Q, M, W, D elements, it is impossible to specify calendar dimension, because the analysis is performed using the "a" variant.
In other cases an error is generated.
If N = M, the X symbol is used to set the element from the filter.
If the analysis is not used (the element selection is set manually) to set aggregation expression, the following rules should be used:
By dimensions, missing in the aggregation filter, the single selection must be set.
For the dimensions which are in the filter:
Empty selection is specified. On calculation the selection from the filter is used.
The single selection is used. It is considered, that the user specified all dimensions and for this element the filter is not used.
See also: