1. Analytical Application Infrastructure User Guide
  2. Unified Analytical Metadata
  3. Measure

Measure

Business Measure refers to a uniquely named data element of relevance which can be used to define views within the data warehouse. It typically implies aggregated information as opposed to information at a detailed granular level that is available before adequate transformations.

Based on the role that you are mapped to, you can access read, modify or authorize Measure. For all the roles and descriptions, see Appendix A. The roles mapped to Measure are as follows:
  • Measure Access
  • Measure Advanced
  • Measure Authorize
  • Measure Phantom
  • Measure Read Only
  • Measure Write

Business Measure function within the Infrastructure system facilitates you to create measures based on the area of analysis. While creating a measure, you can choose the aggregation type and apply business exclusion rules based on your query/area of analysis. Business Measures can be stored as Base and Computed Measures and can also be reused in defining other multi-dimensional stores and query data using the various modules of Oracle Analytical Application Infrastructure.

Figure 8-22 Business Measure Summary window


This illustration shows the Business Measures window, which displays the list of pre-defined Business Measures with their Code, Short Description, Long Description, Aggregation Function, Entity, and Attribute. The window has the Search and Filter and Business Measures pane. In the Search and Filter pane, you can specify the details of the business measure to search. In the Business Measures pane, the search results are displayed, you can also Add, Edit, View, Delete, and Copy the business measures.

The Business Measures window displays the list of pre-defined Business Measures with their Code, Short Description, Long Description, Aggregation Function, Entity, and Attribute. You can add, view, edit, copy, and delete the required Business Measures. You can also search for a specific Business Measure based on the Code, Short Description, and Authorization status or view the list of existing Business Measures within the system.