Multiple-Grid Example: Butterfly Report

Data source types: Oracle Essbase, Oracle Analytics Cloud - Essbase

Typically, Oracle Smart View for Office grids consist of member names on rows above and columns on the left of the data grid. Using the range retrieval capabilities of worksheets enabled for multiple grids, you can create grids with different layouts.

For example, you can create "butterfly" reports, with a column of members between two columns of data cells.

Figure 6-15 Butterfly Report


Shows a report with three columns.