Technical data
Creating Analytic Model Definitions Chapter 4
• Define formulas and user functions to calculate the data cubes.
Define a formula for each data cube that you want to calculate. If you want to reuse the formula
in more than one data cube, create a user function and reference the user function in the formula
for each of the data cubes.
See C
hapter 10
, “Creating Rules, Formulas, and User Functions,” Defining and Editing Data Cube
Formulas, pag
e 119.
• Attach dimens
ions to the data cubes.
Attach the dim
ensions to the data cubes after you have created the dimensions and data cubes.
See C
hapter 6, “Creating Dimensions,” Attaching a Dimension to a Data Cube, page 50.
• Define the analytic model’s cube collections.
See C
hapter 7, “Creating Cube Collections,” page 53.
• Define the analytic model definition’s filter functions.
See C
hapter 10
, “Creating Rules, Form ulas, a nd User Functions,” Filter User Functions, page 113.
•Definetheana
lytic model definition’s organizers.
See C
hapter 4, “Creating Analytic Model Definitions,” Creating Organizers, page 29.
3. Save the analytic model definition.
Understandin
g Conventions for Naming Analytic
Models and Parts
You must adhe
re to these rules when naming analytic models and all analytic model parts:
• Names must consist only of letters, numbers, and underscores (_).
Other than underscores, do not use n onalphanumeric characters.
• All letters must be uppercase.
• The first character in a name must c onsist of a letter.
Do not use a number or underscore as the first character in a name.
• Blank spaces are not allowed in names.
Use underscores instead of blank spaces.
• Names must not exceed 30 characters.
See Also
Chapter 16, “
Converting BAM 8.8 Models to Analytic Models,” Understanding Par t Conversion De t ails,
page 255
Enterprise PeopleTools 8.49 PeopleBook: PeopleCode API Reference, “Analytic Calculation Engine Metadata
Classes,” AnalyticModelDefn Class
28 Copyright © 1988-2007, Oracl e. All rights reserved.