Unlike regular tables, each data cell in a pivot table contains a unique value. Pivot tables structure data similarly to standard tables that contain column groups, but can display multiple levels of both row and column headings. A table provides a summary view of data and allows users to see different views of data by dragging and dropping rows and columns.ĭisplays results in a pivot table, which provides a summary view of data in cross-tab format and allows users to see different views of data by dragging and dropping rows and columns. Table 3-1 View Names and Descriptions View Nameĭisplays a title, a subtitle, a logo, a link to a custom online help page, and timestamps to the results.ĭisplays results in a visual representation of data organized by rows and columns. You can then save the analysis with the collection of views. If you are customizing results for display on a dashboard, then you can preview how the combination and position of views will look when viewed on a dashboard. Preparing multiple views of results can help you identify trends and relationships in data. You can customize or delete the existing views for an analysis, add other views, and combine and position views anywhere in the pane. If the analysis contains at least one hierarchical column, then a pivot table is the default view. If the analysis contains only attribute columns, only measure columns, or a combination of both, then a table is the default view.
When you display the results of a new analysis, the following views are displayed by default in the "Compound Layout" in the "Analysis editor: Results tab":Ī title view, which displays the name of the saved analysis.Ī table or pivot table view, which displays the results of the analysis, depending on the types of columns that the analysis contains: You can add a variety of views to the results, such as graphs and pivot tables that allow drilling down to more detailed information, explanatory text, a list of filters that were used to limit the results, and more.
Views use the presentation capabilities of Oracle BI Enterprise Edition to help you look at results of analyses in meaningful, intuitive ways.