Matrix Grid

The matrix grid organizes members and measures into columns and rows with headers. Users may determine which members and measures will be displayed as columns or rows. The matrix grid is highly customizable in terms of formatting, enabling users to tailor the grid's look and feel as required.

Unlike tabular grids and raw results grids, each member element in the given hierarchy is displayed as a header in the matrix grid. For instance, in the image below, the Country hierarchy was added to the Columns drop zone, and Promotion Type to Rows. Each member element within the Country hierarchy is displayed as a column in the grid, while each element under Promotion Type is displayed as a row:

In the tabular grid below, the same 2 hierarchies are displayed as columns; however, the column headers are named according to the hierarchy name, and each row within the column contains an element from that hierarchy: