Editing the Formula of a Column

Before you start

You must have one of the following user type permissions:

• BI Author Limited

• BI Author Developer

• BI Tenant Administrator

Home > Oracle Analytics > Catalog

Here's what to do

1. Navigate to the analysis.
2. Edit the analysis.
3. In the Selected Columns pane, click the Options button beside the column whose formula you want to edit and select Edit Formula.
4. Use the Edit Column Formula dialog: Column Formula tab to perform various tasks such as creating customized headers and creating or editing the formula for the column. You can build a simple mathematical formula using operator and character buttons, such as "Base Facts"."1-Revenue"*1.10. You can click the Variable button to create and use a global variable to maintain a value that may need to be changed during the course of business across multiple analyses. You create a global variable as part of the process of creating an analysis. For example, you can create a global variable for the start of the fiscal year and change it as necessary for the start of each new fiscal year.
5. Optionally, use the Edit Column Formula dialog: Bins tab to combine values for the column into sets.
6. Click OK.

Results:

The column formula is saved with the analysis in which it is used.