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.