Grid

See also Grid Toolbar.

gridwindow.png

1numbercallout.png

Rows and Columns - The grid displays levels along the rows and columns axis. You can create views with levels on one axis (rows or columns) or levels on both axes.

  • anumbercallout.png Header Cells - Header cells contain names of levels and attribute relationships. In the above image, the row levels are Region and Customer Ship-To. The column level is Sales Dir. The other header cells are for their attribute relationships that were selected for display in the view.

  • bnumbercallout.png Detail Cells - Detail cells contain level member and attribute relationship values. In this example, the member values for first level on rows are 330 and 331. That set of cells is known as the display text. Next are the values for the Rgn Long Description attribute relationship. You have the option of designating an attribute relationship as the display text rather than the member value. The detail cells on the columns axis show the 231 member and Helen Briggs attribute relationship value.

  • Pop-up Menus - Right-click objects to display actions that you can take related to that object or axis, such as editing hierarchies. See Grid Pop-up Menus.

  • Drill Path and Drilldown View Links - If multiple levels have been defined for an axis, you can click on links in the grid to drill between levels. You can drill on level names (drill by header) or members (drill by detail). If a drilldown view has been assigned to an axis, the last level in the drilldown path for that axis will be a link -- click a link to display the drilldown view. See Drill Up or Down Within a View and Working with Drilldown Views.

  • Sort and Filter Icons - Icons display next to grid objects that have been sorted ezsortflyasc.gif ezsortflydes.gif or filtered filterbutton.png. Pop-up labels display the sort and filter details when the cursor is moved over the respective icon. See also Use Sort and Filter Icons as Task Shortcuts.

2numbercallout.png

Measure Items - Measure items can be assigned to one axis, either rows or columns. If you create any distinct calculated measure items, you can position them before all other measure items or after all other measure items.

  • Double-click Enabled and Pop-up Menus - You can double-click captions of regular measure items to access the Edit Measure Item window and double-click captions of calculated measure items to access the Expression window for editing purposes. You can also right-click measure items to display all actions that you can take related to that object or axis, such as inserting additional measure items. See Grid Pop-up Menus.

  • Drag and Drop Enabled - You can drag and drop measure items to change their order. Drag and drop within the grid or between the grid and view explorer. See Edit the Order of View Objects Using Drag and Drop.

  • Drill Path and Drilldown View Links - If a drilldown view has been assigned to the measure item axis, the measure items will display as links. Click a link to display the drilldown view. See Working with Drilldown Views. The grid shown above doesn’t have a drilldown view assigned to its measure items axis. Here is what the grid would look like had a drilldown view been assigned.

gridwindow2.png

  • Sort and Filter Icons - Icons display next to measure items that have been sorted ezsortflyasc.gif ezsortflydes.gif or filtered filterbutton.png. Pop-up labels display the sort and filter details when the cursor is moved over the respective icon. See also Use Sort and Filter Icons as Task Shortcuts.

3numbercallout.png

Totals - Grand totals and sub-totals are displayed in darker grey rows and columns. Totals can be displayed for some, all, or no objects in the view. You can control totals by measure items, individual levels, or an entire axis. Grand Totals that are on the same axis as measure items can be sorted and filtered.

4numbercallout.png

View Name - Displays the view name. Right-click to display actions that you can take related to the overall grid, such as exporting to excel. See Grid Pop-up Menus.

Expand View expandview.gif or Collapse View collapseview.gif - In collapsed mode, the grid displays a select number of  rows and columns per page. The number of rows or columns that display per page is controlled by your administrator, but you can customize the setting with an Override View Page Size setting in your User Options. In expanded mode, all rows and columns are displayed.  If you want to change the mode, click this toggle. The collapsed mode is recommended for views with large row and column counts.

Axis Icons - An icon exists for rows rowsaxis.gif and columns columnsaxis.gif.

  • Pop-up Menus - Right-click to display actions that you can take related to that axis, such as controlling the display of totals by axis. See Grid Pop-up Menus.

View Filter - If you used this section to apply a filter to the entire grid, levels used in the filter will display here. See Apply a View Filter.  

  • Pop-up Menus - Right-click the View Filter header or levels in it to display actions that you can take related to that object or section of the grid, such as filtering levels in that section. See Grid Pop-up Menus.