Editing Table and Pivot Table Views

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. Edit the analysis.
2. Display the Results tab: Table editor or the "Results tab: Pivot Table editor". For information, see "Editing Views".
3. To set the properties of the table or pivot table, click the Table View Properties or the Pivot Table View Properties button on the toolbar.
   The Table Properties dialog or the Pivot Table Properties dialog is displayed, where you can:

   • Specify formatting preferences for tables and pivot tables.

4. Use the buttons on the toolbar of the editor to perform functions such as the following:

   • To modify formatting, see "Adding Cosmetic Formatting to a Table or Pivot Table".

   • To add a group or calculated item to the view, see Groups and Calculated Items.

5. To affect the contents of the view, use the following panes:

   • The Subject Areas pane.

   • The Catalog pane.

   • The Layout pane.

   • The Selection Steps pane.

6. To specify the sort order for a column in the view, see "Sorting Data in Views".
7. To drill in the data in the view, see "Drilling in Views".
8. Right-click to perform basic view interactions.