After creating the application, you must select the dimensions that are to be included in the application.
The following dimensions are required for Profitability and Cost Management applications:
Measures dimension contains the members required to build, validate and calculate a model, including driver measures, reporting measures, and allocation measures. Users may add user-defined driver measures (or sub-hierarchies) to the hierarchy under the member 'UserDefinedDriverMeasures'.
AllocationType dimension is used to store direct allocations and genealogy allocations.
POV dimensions provide a specific view of your model information for a selected time period, such as a year, status and scenario. At least one Point of View (POV) dimension must be defined by the user. You can also create a POV Version.
At least one Business Dimension must be defined by the user. Business, or user-defined, dimensions contain members that store information that is specifically related to the requirements of your business or organization, such as product types, sales regions, manufacturing processes, general ledger, payroll, departments, and so on. This dimension type does not apply to aggregate storage outlines.
Business dimensions may include some or all of the following dimension types, and may apply to one or more stages or models:
Generic
Account
Entity
Time
Country
Note: | Although these business dimensions can be included as part of a Profitability and Cost Management application, when the Essbase outlines are deployed, they are created as basic or generic dimensions, with no type. |
Attribute dimensions are a special type of dimension that are associated with a business dimension. Attributes describe characteristics of data, such as the size or color of products.
There are two Attribute dimension types in Performance Management Architect:
Attribute dimensions:
The attribute can be created using different structures, such as Boolean, Date, Numeric and Text.
An attribute has a hierarchy, and the hierarchies can be rolled up for aggregate values.
Only one attribute can be associated with one member.
User-defined attribute dimensions (UDAs):
The attribute can only be created using Text.
A UDA does not have a hierarchy, and cannot be easily used in reports to generate sums.
Multiple UDAs can be associated with a member.
Each type of attribute dimension offers different advantages, depending on the requirements for your model and reporting needs. For detailed information about working with attribute dimensions, see Oracle Essbase Database Administrator's Guide.
Alias is optional, and only required if you want to use aliases in your model. For naming conventions, see Essbase Naming Restrictions for Dimensions, Members, and Aliases.
Caution! | Duplicate member names or aliases are not allowed within the same dimension. |
Note: | Model stages are not dimensions, and are therefore not available in Performance Management Architect. Stages are added to a model in Profitability and Cost Management, and are used to organize dimensions into logical steps or stages. |
After creating the application, select the dimensions to be added to the application using the appropriate procedure:
If you are using the wizard, see Adding Dimensions Using the Wizard.
If you created a blank application, see Adding Dimensions Manually .