SubCubeComplement (MDX+)
Filters the facts performing a complement operation.
Parameters
Name | Type | Cardinality | Default value |
set-expression | one |
Return
void
Description
Currently only available for categories, the SubCube functions allows for filtering facts using different operations.
SubCubeComplement selects all facts not defined by the first parameter. For example SubCubeMinus(A) will define a subCube with the rows not defined by A. Like [All] - [A].
Use this function for large dimensions as using the complement function might improve performance significantly.
See Also
SubCubeIntersect SubCubeMinus SubCubeOthers SubCubeSymDifference SubCubeUnion Eval
Examples
Since Version
4.7
XMLA Properties
Find here the value of the XMLA properties when not specified otherwise.