OBIEE – Views

Oracle BI Enterprise Edition enables you to look at results of analyses in a meaningful way using its presentation capabilities. Different types of views can be added, such as graphs and pivot tables that allow drilling down to more detailed information and many more options like using filters, etc.

The results of the analysis is displayed using a table/Pivot table view and depends on the type of columns that the analysis contains −

• Table view is used if the analysis contains only attribute columns/only measure columns or a combination of both.
• Pivot table is the default view if the analysis contains at least one hierarchical column.
• A title view displays the name of the saved analysis.
• You can edit or delete an existing view, add another view to an analysis and can also combine views.

Types of Views

There are different types of views available −

All view types except logical SQL view can be edited. Each view has its own editor in which you can perform edit task.

Each view editor contains a unique functionality for that view type but might also contain functionality that is the same across view types.

Edit a View

Open the analysis that contains the view to edit. Click the "Analysis editor: Results tab."

Click the Edit View button for the view. View editors is displayed. Now, using the editor for the view, make the required edits. Click done and then save the view.

Delete a View

You can delete a view from −

• A compound layout − If you remove a view from a compound layout, it is only removed from the compound layout and not from the analysis.
• An analysis − If you remove a view from an analysis, it removes the view from the analysis and also from any compound layout to which it had been added.

Remove a View

If you want to remove a view from −

• A compound layout − In the view in the Compound Layout → click the Remove View from Compound Layout button.
• An analysis − In the Views pane → select the view and then click the Remove View from Analysis toolbar button.