Document Contents is a task pane in the Smart View Panel that provides a view of—and allows you to perform actions on—the content existing in the current Office document.
The Document Contents pane displays Office objects in a tree format, allowing you to easily see and interact with the content in a workbook, presentation, or document, regardless of the provider or type of content and including content from extensions. Content is displayed based on the provider connection, or the document layout on sheets, slides, or pages. Figure 34, Document Contents Pane Displaying Oracle BI EE Content shows an example of Oracle BI EE content in Document Contents in Excel.
Depending on the provider, you can perform a subset of tasks on selected objects from the Document Contents pane.
For most providers, you can Select, Refresh or Delete content on a sheet, slide, or document.
For Oracle BI EE providers, you can perform additional tasks on individual views; for example, you can Mask a view, or review the properties of a view.
For Reporting and Analysis providers, you can insert reporting objects and perform other tasks.
For example, in Figure 37, An Essbase Ad Hoc Grid Selected in Document Contents, Sheet1 contains an Essbase ad hoc view. With the Sheet node selected, the Refresh and Sheet Information options appear at the bottom of the Document Contents pane.
Click Sheet Information to view the Sheet Information dialog box (Figure 36, Sheet Information Dialog Box for an Essbase Ad Hoc Grid), where you can also choose to Save or Delete the sheet.
Select the object node in Document Contents, and the context changes showing the Select, Refresh, and Delete options at the bottom of the pane (Figure 37, An Essbase Ad Hoc Grid Selected in Document Contents).
In general, content is grouped by Smart View providers (Essbase, Financial Management, Planning, and Reporting and Analysis). Content from Oracle BI EE is grouped separately. In workbooks containing multiple objects from different data sources, you can switch the view using the Document Contents drop-down menu shown in Figure 38, Available Options in Document Contents Drop-Down Menu.
Select the Current Document option under Smart View and the Document Contents view changes to show the Smart View objects sorted by sheet (Figure 39, Smart View Provider Content Listed by Sheet in Document Contents).
Select the All Connections option under Smart View, and the Document Contents view changes to show objects sorted by provider (Figure 40, Smart View Provider Content Listed by Provider in Document Contents).
Select the Document Hierarchy option under Oracle BI EE to see the Oracle BI EE views listed (Figure 41, Oracle BI EE Content Listed in Document Contents).
For Smart View provider content, such as Planning or Essbase objects, you can click in the tree area of Document Contents and then hover over an object icon to view connection properties, such as Server, Application, Cube, URL, Provider, POV and Alias Table, as shown in Figure 42, Connection Properties of an Essbase Ad Hoc Query. Properties vary depending on the provider.
For Oracle BI EE content, select an Oracle BI EE object, and then use the Properties link at the bottom of Document Contents to view connection properties (see Figure 34, Document Contents Pane Displaying Oracle BI EE Content).
Refer to the following for more information on working with Document Contents: