Show TOC

Overall Layout Rules Locate this document in the navigation structure

This layout structure needs to be followed for each sheet that you refresh but can appear anywhere on the worksheet. In addition, you can also request a refresh on ranges of selected cells; in those cases, only the selected range needs to contain a valid layout of recognizable members.

The overall layout sections and terminology is as follows:



Page axis members are members that act as a specification (filter) for the whole report. An axis is a set of one or more dimensions that define the row axis or column axis in a report (see the red and blue boxes in the layout picture above). The data grid is where the amounts from the database appear.

Here is a sample report with the same highlighted borders to indicate all four sections. Notice that the three axes contain more than one dimension:



Note Formatting and spacing is completely up to you.