Skip Headers
Previous
Previous
 
Next
Next

Code Editing Window for OLAP Calculated Measures

The code editing window enables you to define custom calculated measures. The easiest way to begin is by copying a template from the OLAP Templates and Snippets window. You can then either modify the code directly or modify the template. The code is written in the OLAP expression syntax.

Right-click the window to see a menu of editing tools.

A toolbar at the top of the window provides these functions:

Icon Description
Surrounding text describes options.png.
Displays options for pattern matching in a search.
Surrounding text describes find.png.
Searches for a string that matches your entry in this text box.
Surrounding text describes validate.png.
Checks the syntax of the selected code and shows whether it is valid or invalid.
Surrounding text describes refresh_source.png.
Refreshes the cube metadata. Use this tool after making any changes to the cube.
Surrounding text describes snippet.png.
Displays the OLAP Templates and Snippets window, if it does not appear automatically.
Surrounding text describes run.png.
Opens the Cube Data Viewer.
Surrounding text describes compile.png.
Compiles the code and reports the results on the Calculated Measures Compiler page.

Displaying a Template

When you first insert an analytic function into the code editing window, the code appears at the top of the window and the template appears at the bottom. If you edit the code directly, then the template disappears. If the code is invalid (that is, it cannot be compiled), then the template is disabled and cannot be displayed.

To display the template, select all the code in the window by doing one of the following: 

Related Topics

Oracle OLAP Expression Syntax Reference

"About Calculated Measures"

"Creating Calculated Measures"