Dimension

Business Dimension within the Infrastructure system facilitates you to create a logical connection with measures. It gives you various options across which you can view measures. A Business Dimension is a structure of one or more logical grouping (hierarchies) that classifies data. It is the categorization across which measures are viewed. A dimension can have one or more hierarchies.

You can access Business Dimension window by expanding Unified Analytical Metadata and Analytics Metadata within the tree structure of the LHS menu and selecting Dimension.

The dimension specific details are explained in the following table.

Table 8-18 Fields in the Dimension window and their Description

Field Description
Dimension Properties Displays the Dimension Type and Data Type of the selected dimension object.
Depends on

Displays the Hierarchy object which is used in creating the dimension.

Click the object link to drill down for more details.

Used In

Displays the Essbase cube object in which the dimension is used.

Click the object link to drill down for more details.

Applications Displays the applications in which the dimension is used.

Based on the role that you are mapped to, you can access read, modify or authorize Dimension. For all the roles and descriptions, see Appendix A. The roles mapped to Business Dimension are as follows:

  • Dimension Access
  • Dimension Advanced
  • Dimension Authorize
  • Dimension Phantom
  • Dimension Read Only
  • Dimension Write

Based on the user requirements you can define different dimensions as Regular, Time, or Measure. A Dimension combined with measures helps in business query. Since dimension data is collected at the lowest level of detail and then aggregated into higher-level totals, it is useful for analysis.

Figure 8-42 Business Dimension window


The illustration shows the Business Dimension window, which displays the list of pre-defined Business Dimensions with their Code, Short Description, Long Description, and Dimension Type. The window has the Search and Filter pane, you can specify the details of the business dimension and search, the results are displayed in this pane. You can also Add, View, Edit, Copy, and Delete the Business Dimension from this pane.

The Business Dimension window displays the list of pre-defined Business Dimensions with their Code, Short Description, Long Description, and Dimension Type. In the Business Dimension window, the user is required to enter the Dimension code and a description when the user is defining it for the first time. The user is required to select the dimension type, data type, and map available hierarchies to a dimension.

You can also make search for a specific business dimension based on the Code, Short Description, and Authorization status or view the list of existing business dimensions within the system.