MicroStrategy ONE

Viewing a report in Grid view

Grid reports consist of rows and columns, each row or column having a heading. Each heading of a row or column represents an attribute, a consolidation, a custom group, or a metric. This report format is characterized by its capability to display report results in a flexible, easy-to-modify level of detail. Report results are calculated based on:

  • Hierarchies: primary criteria for selecting template components. Commonly used hierarchies include Geography, Time, Product, and Customer.

  • Attributes: hierarchy components. Geography may consist of the attributes Region, State, City, and so on.

  • Consolidations: groupings of same-attribute elements that accommodate inter-row arithmetic operations.

  • Custom groups: special filters that can be placed on a template. They contain ordered collections of elements.

  • Metrics: analytical calculations performed against template or filter data.

  • Prompts: conditions applied to one or more attributes, filters, or metrics on a report.

If you are publishing an Intelligent Cube rather than creating a standard report, this view indicates that the Intelligent Cube has been published and can now be reported on. For information on Intelligent Cubes, which are part of MicroStrategy OLAP Services, see Sharing sets of data among reports: Intelligent Cubes. For information on reporting on Intelligent Cubes, see Reporting on Intelligent Cubes.

To view a report in Grid view

  1. Locate and open a report that you want to display in Grid view. (For steps to run a report, see Running a report.)

  2. If the report is not already in Grid view, select View, then select Grid View to display the report in Grid view.

Related Topics