Help Topics

Calculation Member Find pane


In the Calculation Member Find pane, you can specify member expressions.

Note: You can use member expressions only in calculations on multidimensional databases.

You can use the Apply Not option to returns member that are not returned by the member function. The following table shows the member functions that are supported:

Member functions

Description

Child

Returns all children of the specified member. Child has the following argument:

Member
Is the member whose children are returned.

Descendents

Returns all descendents of the specified member. Descendents has the following argument:

Member
Is the member whose descendents are returned.

Find

Returns all members that meet the specified condition. Find has the following arguments:

Dimension
Is the dimension on the opposite axis whose members are used in the comparison.
Member
Is the member in Dimension that you want to compare to the value.
Comparator
Is the comparison operator that compares the member to the value. Valid comparisons are >, <, >=, <=, =, and != (<> can also be used for not equal tests).
Value
Is the value to compare to the member.

Generation

Returns all members of a dimension that are at the specified generation. Generation has the following argument:

Generation
Is the generation level of the members to return.

Leaf

Returns all leaf-level descendants of the specified member. Leaf has the following argument:

Member
Is the member whose leaf-level descendents are returned.

 

Related topics: