Saving Columns to the Catalog

You can save a column to the catalog for reuse in other analyses. This is helpful for example, if you have edited the formula of a column or set column properties that you would like to save and reuse in other analyses.

When you save a column to the catalog:

• Oracle recommends that you save the column to the subject area folder. If a subject area folder does not exist in your /My Folders folder or within the /Shared Folders folder, then Oracle BI EE creates a subject area folder and the Save As dialog defaults a save path to /My Folders/Subject Area Contents/<subject area>. Saving the column to the subject area folders ensures that it is available when you build an analysis for the same subject area.

• Selections, filters, conditional actions links, and conditional formatting are not saved.

• References to the column are changed from the subject area to the catalog.

• You can reuse the saved column in another analysis by dragging and dropping it from the Catalog pane.

• You can edit the saved column from

  • The "Catalog pane"

  • The "Catalog page"

  • Within an analysis in which you reuse it.

  Changes that you make from the Catalog pane and Catalog page apply to all versions of the saved column. Edits that you make within an analysis apply only to that analysis.

To be able to save columns to the catalog, you must have been granted the Save Column privilege by the administrator.

To save a column to the catalog:

1. In the "Selected Columns pane," click the Options button beside the column that you want to save and select Save Column As. The "Save As dialog" is displayed.

2. Complete the dialog to save the column to the catalog.