Column Properties dialog

Use this dialog to:

• Edit the properties for a column or hierarchy level to control the appearance and layout of a column or hierarchy level and its contents

• Specify formatting to apply only if the contents of the column or hierarchy level meet certain conditions

• Specify the interactions that are to occur when users click in a data view

• Set the properties of a column that affect write back

This dialog is also displayed as:

Hierarchical Level Properties dialog

For more information, see:

• Chapter 7, "Formatting Analyses, Views, and Dashboard Pages"

• "Adding Actions to Analyses"

• "Editing Actions and Action Links Added to Analyses"

Components

Style

Use the "Column Properties dialog: Style tab" to format the content of columns and hierarchy levels.

Column Format

Use the "Column Properties dialog: Column Format tab" to modify how folder and column headings are displayed in the analysis and to specify how repeated values display in the column.

Data Format

Use the "Column Properties dialog: Data Format tab" to override the data's default display characteristics.

Conditional Format

Use the "Column Properties dialog: Conditional Format tab" to add a condition, or filter, to the column or hierarchy level.

Interaction

Use the "Column Properties dialog: Interaction tab" to specify what you want to happen when the user clicks a value for a column or hierarchy level.

Write Back

Use the "Column Properties dialog: Write Back tab" to set the properties of a column that enables it for writing back values from a table.

Save As Default

Use this button to affect the default property settings for columns and hierarchy levels, based on the specifications in this dialog. You need the appropriate privileges to save the properties as a systemwide default.

• Select Restore properties defaults to return the property values for the column or hierarchy level back to the last saved default values.

  To restore the defaults that were shipped with the product, you must manually delete the default formats file from the Oracle BI Presentation Catalog.

• Select Save as the system-wide default for <name> to save these properties as the systemwide default for this column or hierarchy level in all analyses in which it is used.

• Select Save as the system-wide default for this data type to save these properties as the systemwide default for all columns or hierarchy levels that have the same data type as this column or hierarchy level.

Click OK to save these properties for this column or hierarchy level in this analysis only.

The Save as Default button applies slightly differently to the various tabs of this dialog:

• The properties on the Style, Column Format, and Data Format tabs are saved or restored when you select an option with this button.

• The settings on the Conditional Format tab cannot be saved or restored.

• On the Write Back tab, only the Enable Write Back property can be saved or restored.

• On the Interaction tab, you can save and restore properties, but the display differs for action links. If you set the interaction mode to action links, then you can create action links and they are displayed in the Action Links area of the tab. If you save the default settings, click OK to close the dialog, then re-display the dialog, you do not see the action links in the Action Links area. You can click the Add Action Link button to display a list of the saved actions so that you can select one to use.