These are additional MDX statements that would work in the same fashion as the equivalent standard MDX statement:
@COUSIN
@DISTINCT
@EXCEPT
@FILTER
@FIRSTCHILD
@GEN
@GENMBRS
@INTERSECT
@LASTCHILD
@NEXTMBR
@PREVMBR
@ISIBLINGS
To view how the functions work the Oracle documentation covers that.
The first function I wanted to test was the @EXCEPT function as we have had a requirement for that for time.
To test I tried to remove one code from the level zero descendants of my profit and loss accounts; syntax I thought would be simple enough.
@EXCEPT(@Level0Descendants("PL"), "A12345")
Where A12345 is a level zero account.
However the rule failed to validate with the following error message:
Error Cause: Syntax error in input MDX query on line 1 at token ')' Rule xxxxx
As the functions were not listed in the release notes of this version I initially figured that they had somehow slipped through the migration cracks and should't have been included in this release, but decided to give it a bit more of a go and then tried the following syntax:
@EXCEPT(@Level0Descendants("PL"), @Level0Descendants("A12345"))
As these were not documented and this is the first release Oracle may fix this issue, but if not this is how to use the @EXCEPT function
