Inserting a Dimension Member Reference into a Rule
This topic discusses how to:
-
Enter a member reference into a rule.
-
Refer to one slice of a data cube.
Entering a Member Reference into a Rule
To enter a member reference into a rule:
-
Select to access PeopleSoft Application Designer.
-
After signing in to the PeopleSoft Application Designer, open an analytic model definition.
-
Select the data cube whose formula you want to define or edit.
-
Place the cursor at the position in the rule where you want to enter a member reference.
-
Select
The Choose Member Reference dialog box appears.
-
Click the dimension for which you want to enter a member reference.
The dimension and a generic member reference appears in the rule bar.
-
Highlight the word member.
-
Replace the word member with the name of the dimension member.
Referring to One Slice of a Data Cube
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:
-
Select to access PeopleSoft Application Designer.
-
After signing in to the PeopleSoft Application Designer, open an analytic model definition.
-
Select the data cube whose formula you want to define or edit.
-
Enter the data cube in the rule.
For example, SALES, which uses the MONTHS, PRODUCTS, and REGIONS dimensions.
-
Enter a member reference.
For example, the East region from the REGIONS dimension.
The rule bar now displays
SALES [REGIONS.East]. This rule returns SALES for the East region for all PRODUCTS and all MONTHS. -
Repeat step 3 to make the slice as small as you want.
A single value from the data cube is the smallest possible slice.
For example, to access SALES for the East region for the Hard Drives product for 2004/03, use the following rule:
SALES [REGIONS.East] [PRODUCTS.Hard Drives] [MONTHS.2004/03]
Related Topics