Element reference modifiers

Visibility modifier

Short

Description

all

a

Both visible and hidden elements are included.

This is the default visibility filter.

visible

v

Only visible elements are included.

hidden

h

Only hidden elements are included.

Hierarchy modifier

Short

Description

level

l

Only elements on the same hierarchy levels in the dimensions as the current element are included.

This is the default hierarchy filter.

If an integer >= 0 immediately follows this filter name, e.g. ‘l2’, then only the values in level 2 are included, with level zero being the grand total.

siblings

s

Only elements with the same hierarchy parents in the dimensions as the current element are included.

children

c

Only elements that are nested inside the current element are included.  Please note that only data references can be used with this filter.

Example: This filter can be used with an if-then-else operator for making subtotals that only include the visible elements, when some elements have been hidden by a Visibility Agent:

if allcount(0,d1:d-1(c),m1) > 0 then sum(0,d1:d-1(v,c),m1) else sum(0,0,m1)

ragged

r

This filter is useful e.g. for making an accumulation which follows the current expansion of single elements:

Like with the ‘level’ filter, an integer >= 0 can follow this filter name, e.g. ‘r0’.  In ragged filter, however, this value is somewhat more complicated to explain:

Level zero are the leaf elements, i.e. the elements that have no children.  Level one are their parents.  In the example above, only 2001 is on level one.  Level two are the elements that have level 1 children (grand total above), etc.

leaves

rl

Only elements with no children are included.  This is the exact same as ‘r0’.

Order modifier

Short

Description

sorted

o

Relative and data references are indexed according to the current sorting of the grid.

This is the default order filter.

unsorted

u

Relative and data references are indexed according to the order of the dimension values in the cube.