Technical data

Creating Rules, Formul as, and User Functions Chapter 10

1. Place the cursor at the position in the rule where you want to enter a member reference.

2. Select Edit, Paste Member Ref...

The Choose Member Reference dialog box appears.

3. Click the dimension for which you want to enter a member reference.

The dimension and a generic member reference appears in the rule bar.

4. Highlight the word member.

5. Replace the word member with the name of the dimension member.

Referring to On

e S lice of a Data C ube

When you want to access particular values within a data cube, use member references to refer to a slice

of the data cube.

To refer to one slice of a data cube:

1. Define or edit a

rule.

2. Enter the data c

ube in the rule (for example, SALES, which uses the MONTHS, PRODUCTS, and

REGIONS dimen

sions).

3. Enter a member

reference (for instance, the East region from the REGIONS dimension).

Therulebarno

wdisplays:SALES [REGIONS.East]. This rule returns SALES for the East

region for all

PRODUCTS and all MONTHS.

4. Repeat step 3 t

omakethesliceassmallasyouwant.

A single value

from the data cube is the smalle st possible slice.

For example, t

o access SALES for the East region for the Hard Drives product for 2004/03, use the

following rul

SALES [REGION

S.East] [PRODUCTS.Hard Drives] [MONTHS.2004/03]