1. User's Guide
  2. Smart View and Oracle BI EE
  3. Working with Oracle BI EE Analyses, Views, and Dashboards
  4. Inserting Compound Views

Inserting Compound Views

To insert a compound view:

  1. From the catalog, select the compound view to insert.
  2. Right-click and select Insert All Views.
  3. When prompted, choose an option:

    • One object per sheet/slide to insert each object in the compound view on a separate sheet in Excel, or a separate slide in PowerPoint.

    • All objects on one sheet/slide to display all objects on one Excel sheet or PowerPoint slide.

    In Excel, objects are inserted on a new sheet or sheets, even if there are unused sheets in the workbook.

    In Word, objects are placed adjacent to and below other objects on a sheet until the sheet is filled, and then continues filling as many sheets as required to hold all the objects.

    The default display is selected for the table, pivot table, and graph view types; that is, the Insert action will be used automatically.

    A message notifies you of unsupported view types in the compound view. Unsupported view types are not inserted.

Notes:

  • You can do a Refresh and edit prompt and page prompts for selected views. Unselected views from the compound view remain unchanged. See Refreshing Views, Working with Prompts, and Working with Page Prompts.

  • In Word and PowerPoint, there can be some overlapping of tables and charts when inserting a compound view or when a compound view is either inserted from the catalog or copied and pasted. This is especially true when any of the objects in the compound view are particularly large.

  • When inserting multiple objects from a compound view into PowerPoint and selecting the "one object per slide" option, an Excel instance is opened for each object and then minimized in the Windows Taskbar. However, when the insert operation is complete, the Excel instances are not automatically closed. This can clutter the Taskbar when inserting a large number of objects. To minimize the number of Excel instances shown in the Taskbar, click the Office button (in the upper left corner of Excel), select Excel Options, and then select the Advanced tab. In Display options, clear the Show all windows in the Taskbar check box.