Technical data

Chapter 11 Using Built-in Functions in Analytic M odels
If the userID matches the member in the USERID dimension, the AT function searches for the
coordinates of the userID member that is returned by TXT2MBR and returns the corresponding
value of DEPT_CUBE.
On the right-hand side of the equation, the MEMBER function returns the corresponding member
of DEPT_DIM.
3. The analytic calculation performs one of these actions:
• If the value returned from DEPT_CUBE matches the member returned from DEPT_DIM, the
userID can see the bonus amount.
For example, the Dev value returned from DEPT_CUBE matches the Dev member returned from
DEPT_DIM. For this reason, Albert can see his bonus amount of 5000.
• If the value returned from DEPT_CUBE does not match the member returned from DEPT_DIM, the
userID cannot see the bonus amount.
See Also
Chapter 11, “U
sing Built-in Functions in Analytic Models,” AT, page 141,Chapter 11, “Using Built-in
Functions i n
Analytic Models,” MEMBER, page 172,Chapter 11, “Using Built-in Functions in Analy t ic
Models,” TEX
T2MBR, page 194 and Chapter 10, “Creating Ru l es, Formulas, and User Functions,” Fil ter User
Functions, p
age 113.
PARENT
Syntax
PARENT(Dim
ension,{Child Member})
Descriptio
n
The PARENT function returns the member reference to the pare nt of the specified member.
Parameters
The PARENT function takes one required argument and one optional argument. The first argument is required.
The second argument is optional.
Parameter Descriptio
n
Dimension The dimens
iontouse.
Child Member If this optional argument is not supplied, use the current calculated mem ber for this
dimension.
Note. If the child mem ber is the root, this function returns –1.
Returns
The member reference to the p arent of the specified member.
Example
PARENT (Region, [Region:West]) returns a reference to the parent of [Region:West], which
is [Region:USA].
Copyright © 1988-2007, Oracl e. All rights reserved. 179