icCube

Documentation

Neutral Element

(MDX+)

A neutral element defined as ∅ (U+2205)

Description


The neutral element - ∅, neutralElement() - has no effect on all operations. For example:


∅ * {A} = {A}
∅ + {A} = {A}
(∅,[Switzerland]) = ([Switzerland])

FILTER BY ∅ - does not filter anything
WHERE (∅) - is like no where clause


It might be created using the neutralElement() function.

This is mainly used in the reporting to define filters that have no effect.

It is defined as the Unicode character ∅ (U+2205).

On Windows you might try to input with the ALT key pressed 2205 on your keypad (it might not work)
On Linux you can input that character using : CTRL + SHIFT + U followed by 2205 and ENTER.

Examples

Special Examples (errors, null, ...)

Since Version

6.8

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.