icCube

Documentation

SubCubeOthers

(MDX+)

Creates an 'Others' category member

Parameters

Name Type Cardinality Default value
  set-expression  zero-n   

Return

void

Description


Currently only available for categories, the SubCube functions allows for filtering facts using different operations.

SubCubeOthers() without parameters allows for creating a category member based on the siblings that are not "others". It is equivalent of the selection of the parent minus the union of the siblings:


SubCubeMinus( parentMember, SubCubeUnion( {siblings} ) )


If the parent member is the all member, it is equivalent to:


SubCubeComplement( SubCubeUnion( {siblings} ) )


E.g. assuming the following hierarchy:


Countries
United States
Switzerland
Others as SubCubeOther()


The "Others" will be [Countries] - [United States] - [Switzerland]

With a parameter it is a shortcut of:


SubCubeMinus( parentMember, SubCubeUnion( {parameter tuples} ) )


See Also

SubCubeComplement SubCubeIntersect SubCubeMinus SubCubeSymDifference SubCubeUnion

Examples

Since Version

5.0

XMLA Properties

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