Sheet Content

What content do Sheets contain?

Line Groups and Line Items

Variables, Assumptions and Metrics are all added to Sheets via Line Groups and Line Items.

Line Groups and Line Items in Models (left) and Excel (right)

Line Items

All Variables, Assumptions and Metrics in your Layout are represented by a Line Item. As shown in the screenshot above, when a Variable or Metric has a Dimension applied (the Variable Gym members in the example), you only need to add a single item to the Layout for all child items, and the summary line, to be generated in the Excel.

Line Groups

Each Line Item must be a child of a Line Group. Line Groups can be added to other Line Groups in a tree-like structure, and numbering will be automatically added, as in the example screenshots above.

Dashboards

Dashboard Sheets contain a reference to a single Dashboard. In the Sheet wizard, if you select the Dashboard Sheet type, you will be shown a step in which you can choose a Dashboard to display. Only one Dashboard can be shown on any single Sheet.