"Identifying Required Business Facts" identifies the business measures required by the Global Corporation. Only three measures were acquired from the star schema: Units, Unit Price, and Unit Cost. The remaining business measures can be calculated from those three.
Custom measures can either be solved at run-time or stored in variables. Run-time calculations do not require disk storage space and do not extend the processing time required for data maintenance. However, they may slow performance. You need to decide which measures to calculate on the fly and which, if any, to store. Many of the required business measures are based on sales, extended cost, and margin, as shown in Table. Because these three calculated measures are used so heavily, the example stores them in variables. The other measures can be implemented as formulas and calculated on demand.
Custom Measures for the GLOBAL Analytic Workspace
Creating Measures for SALES, EXTENDED_COST, and MARGIN
The variables for Sales, Extended Cost, and Margin will have the same dimensions as Units, and will be added to the Units cube.
Creating New Variables in GLOBAL
Follow these steps to create SALES_VARIABLE.
Calculating and Storing Values in Variables
The following commands calculate data just at the base level so that the new variables can be aggregated separately. The ACROSS command loops over the dimension members currently in status.
A hyphen at the end of a line continues a command to the next line.
Creating Measure Formulas
Follow these steps to create and register the SALES formula. Repeat them for EXTENDED_COST and MARGIN.
Aggregating the New Global Variables
After you have created a standard form measure, you can aggregate it the same as any other measure. Because the new measures were added to an existing cube, you can either modify an existing aggregation plan or create a new one for the new measures. Follow these steps:
Adding More Custom Measures to GLOBAL
The remaining measures can be calculated at runtime using any of the available methods. The following steps create a new formula object and register it as a measure, using the method described in this chapter. Alternatively, you can use the DBMS_AW_UTILITIES package to define permanent custom measures.
To define the SALES_PP measure, take these steps:
Repeat these steps for the other measures listed in Table
Using an OLAP DML Program to Add Measures to GLOBAL
The previous examples showed how to define measures manually using Analytic Workspace Manager. Another option is to use an OLAP DML program. Example shows a sample program for adding measures. It takes three arguments:
This is the command to run the program:CALL create_measure('display_name' 'source_variable')
For example, CALL create_measure('Sales' 'sales_variable')
All of the other information is provided in local variables at the beginning of the program. If you use this program as a template for creating measures in your own analytic workspace, then either change the settings of these local variables or change the variables to command-line arguments.
This is the basic sequence of the program:
Comments are used throughout the program to help you understand how it works. You will also see these symbols:
" (double quote) begins or ends a comment
' (single quote) encloses literal text
& (ampersand) substitutes the value of an expression for the expression itself
(backslash) identifies the next character as literal, not part of command syntax
= (equal) sets the variable on the left to the value of the expression on the right
- (hyphen) continues command onto next line
: (colon) follows the name of label used to redirect processing
For the full syntax and usage of the commands and functions in this program, refer to the Oracle OLAP DML Reference.
DML Program for Adding Measures to UNITS_CUBE
OLAP Related Interview Questions
|Informatica Interview Questions||Data Warehouse ETL Toolkit Interview Questions|
|PL/SQL Interview Questions||Data Warehousing Interview Questions|
|Testing Tools Interview Questions||SQL Database Interview Questions|
|MySQL Interview Questions||ERP Tools Interview Questions|
|Oracle 11g Interview Questions||Hyperion Financial Management Interview Questions|
|Hyperion Essbase 5 Interview Questions||Database Design Interview Questions|
|Data modeling Interview Questions||Oracle Hyperion Planning Interview Questions|
|Biztalk Esb Toolkit Interview Questions|
OLAP Related Practice Tests
|Informatica Practice Tests||PL/SQL Practice Tests|
|Data Warehousing Practice Tests||Testing Tools Practice Tests|
|SQL Database Practice Tests||MySQL Practice Tests|
|ERP Tools Practice Tests||Oracle 11g Practice Tests|
|Hyperion Financial Management Practice Tests||Hyperion Essbase 5 Practice Tests|
|Database Design Practice Tests|
The Multidimensional Data Model
The Sample Schema
Developing Java Applications For Olap
Defining A Logical Multidimensional Model
Creating An Analytic Workspace
Sql Access To Analytic Workspaces
Exploring A Standard Form Analytic Workspace
Adding Measures To A Standard Form Analytic Workspace
Predicting Future Performance
Acquiring Data From Other Sources
Administering Oracle Olap
Materialized Views For The Olap Api
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.