Home > OLAP Dialog Boxes and Wizards > Code Editing Window for OLA...
![]() Previous |
![]() Next |
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 |
---|---|
![]() |
Displays options for pattern matching in a search. |
![]() |
Searches for a string that matches your entry in this text box. |
![]() |
Checks the syntax of the selected code and shows whether it is valid or invalid. |
![]() |
Refreshes the cube metadata. Use this tool after making any changes to the cube. |
![]() |
Displays the OLAP Templates and Snippets window, if it does not appear automatically. |
![]() |
Opens the Cube Data Viewer. |
![]() |
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:
Enter Ctrl+A.
Triple-click the primary mouse button.
Click and drag the cursor over the code.
Related Topics
Oracle OLAP Expression Syntax Reference