Grid Views

Grid View components display data from a Data Adapter in a grid. Data Adapters query and return data from various sources like Cube Views and SQL Database Tables. Grid View components are like the SQL Table Editor component, but the data in the Grid View cannot be mutated. This component is not compatible with Mobile Dashboards.

When to use

Use the Grid View component when you want to view data from a Data Adapter in a structured, grid format. Grid Views give users the ability to sort, group, and filter columns for reporting. Grid View selections can be captured in a bound parameter and used to customize data at runtime.

When not to use

The Grid View dashboard component should not be used for large data sets as it is not a component that uses pagination. In this instance, a SQL Table Editor component should be used to display the data to the end user, and it will use pagination to return the full data set.

Properties

Configuration Settings

• Table Name: The name of the table being displayed in the control.

• Show Column Settings Button: Shows (if set to True) or Hides (if set to False) the Column Setting Button which allows user to reorder and set visibility of columns.

• Show Deselect All Button: Shows or Hides Deselect All Button which allows the user to deselect all selected rows.

• Allow Multiselect: If set to True, the multiple selection of records will be enabled by item selection or using a selection check box. The active selected items will be passed to the defined Bound Parameter field as a comma delimited list. The Bound Parameter format will be as: Item1, Item2, Item3. If the 3 values A, B, C, D are selected (where C,D is one value) the resulting bound parameter string is A, B, "C,D". If set to False, only a single Bound Parameter can be passed at a time and the selection boxes will be deactivated from the user interface.

Create a Grid View

1. Click Application > Presentation > Workspaces

2. Expand the Workspace and Dashboard Maintenance Unit where the Grid View will be created, then click Components.

3. Click Create Dashboard Component in the dashboard toolbar.

4. Select Grid View from the dialog then click OK.

5. In Name and Description, enter a name and description for the Grid View component. Do not use special characters, dashes (-) or underscores (_) in names.

6. In the Data Adapters tab, assign a Data Adapter to the Grid View.

7. Configure the rest of the Grid View fields.

8. Click Save.

9. Add the Grid View component to a Dashboard.

10. Click Save.

11. Test the Dashboard by clicking View Dashboard. The Dashboard with the Grid View data pulling from the Data Adapter will be displayed in OneStream.