@NOTEQUAL
The @NOTEQUAL calculation function searches the Essbase outline or hierarchy and returns the set of member names that do not match a specified string token. This function can be used on unique and duplicate-name outlines.
Syntax
@NOTEQUAL (tokenName, topMbrinHierarchy)Parameters
- tokenName
-
Token string value, representing the name of a member, with which to compare to members in the outline, starting with member specified in topMbrinHierarchy. The specified token name must not be qualified for duplicate members.
- topMbrinHierarchy
-
A fully qualified name of a member in the outline on which to base the member search. The specified member and its aliases, and all of its descendants, are included in the search.
To search the entire outline, provide an empty string (
"") for this parameter. For example,@NOTEQUAL("300-30", "").
Example
The following examples are based on the following duplicate-name outline:
Product
100
100–10
100–10–10
100–20
100–30
200
200–10
200–20
200–30
300
300–10
300–20
Diet
100–10
100–10–11
200–10
300–10
Bottle
200–10
300–20@NOTEQUAL("200-10", "Product")Returns all of the members under the Product dimension, except for the members [Bottle].[200-10], [Diet].[200-10], and [200].[200-10].
@NOTEQUAL("200-10", "Diet")Returns the members Diet, [Diet].[100-10], [Diet].[100-10].[100-10-10], and [Diet].[300-10].
See Also