Skip Headers
Oracle® Business Intelligence Enterprise Edition Help
11g Release 1 (11.1.1)
  Go To Table Of Contents
Contents


Edit Column Formula dialog: Column Formula tab

Use this tab of the "Edit Column Formula dialog" to:

For more information, see:

This dialog is also displayed as:


Edit Formula dialog
New Calculated Measure dialog

Components

Folder Heading

Not available for KPIs.

Use this field to enter the text for the heading for the column's folder. To enable this field, select the Custom Headings box.

Column Heading

Not available for KPIs or new calculated measures.

Use this field to customize the heading to reflect the data in the column. To enable this field, select the Custom Headings box. For example, to change the column heading to "Dollars Increased by 10%", select the Custom Headings box and then, in the Column Heading field enter Dollars Increased by 10%.

Custom Headings

Not available for KPIs.

Use this box to enable the Folder Heading and Column Heading fields so that you can customize the headings to suit your needs. For example, if you change the formula of a column, you might want to change the column heading to something that is more representative of the column.

Contains HTML Markup

If you are customizing the headings, use this option to work with HTML codes, as described in "Working with HTML Markup."

Aggregation Rule (Totals Row)

Not available for KPIs.

Use this box to select the aggregation rule for the column totals for attribute or measure columns. For example, if you want column totals to show the minimum value of the rows in the result set, then select Min. If you want them to show the sum of all the values in the result set, then select Sum, which is the default.

For a list of the valid values, see "Aggregation Rules and Functions."

Available

Displays the primary subject area and any related subject areas that have been added to the "Subject Areas pane." Use this area to select columns to use in formulas. To insert a column in a formula, select the column and click the Add Column button (the arrow button between the Available and Column Formula areas). Note that when you insert a column, if you have something highlighted in the Column Formula area, it is replaced.


Note:

Only measure columns will display in the "Subject Areas pane" for a calculated measure.


Column Formula

Use this area to perform these tasks:

When you have text selected in the Column Formula box, it is replaced by values that you select elsewhere, such as in the Available list or by inserting functions or filters. The selected text is also displayed in the Insert Function and Insert Filter dialogs when you invoke them.

You can enter the formula manually or use these components:

Treat as an attribute column

Not available for calculated measures.

Available only for measure columns and only when the dialog is invoked from the Criteria tab. The default is that the box is not selected. Use this box to specify that a measure column be treated as an attribute column. This setting forces a Group By of the column values when the measure column is positioned outside the Measures area to an edge of the view This setting is not applied to a measure column in the Columns and Measures area of a table or the Measures area for a pivot table or graph.

This box is required to facilitate functionality in this release that specifies to not show all the detail when a measure column is moved to an edge but rather to aggregate the measure column to the grain of the edge. For example, aggregating dollar values to the Region grain.

Suppose that you have an analysis that contains the Region, Units, and Dollars columns. Using the Bins tab of the Edit Column Formula dialog for Units, you create one bin for values greater than or equal to 10 million and you specify that bin name as X. All other values use the bin name of Y. These bins create a CASE statement in the formula for this column.

When you display that analysis in a table on the Results tab, you see values for X and Y in the Units column. If you display that analysis in a pivot table with the Units column on the Measures edge, you also see values for X and Y. If you move the Units column to another edge, such as the row edge of a pivot table, then you see only values for X. This is because the values of the column were aggregated for each region and none are now less than 10 million.

To resolve this problem and have views display data as in previous releases (prior to 11g), you select the Treat as an attribute column check box to specify that the measure column be handled as an attribute column, which prevents the aggregation of the values.

All analyses are upgraded from Release 10g with all measure columns having the Treat as an attribute column check box selected, to ensure that the measure columns are treated as attribute columns, as they were in Release 10g.


Note:

When the Treat as an attribute column option is selected, and you move a measure to an edge for which a forced Group By of the column values does not make sense (for example, because you want to show one measure value per row to avoid repeating values by the columns in the column edge), an error may occur. To resolve this error, deselect the Treat as an attribute column option.


Notes

To manually enter a variable in an expression in the Formula area, follow the guidelines for referencing variables in expressions that are described in Table 2-2.

Related Topics


"Edit Column Formula dialog: Bins tab"