The Grid component can display a table with data in your dashboard. Therefore, it looks a bit like the List View and Spreadsheet Table components. There are a number of differences between these two sets of components, stated as follows:
Open a new SAP BusinessObjects Dashboards file and enter the values in the spreadsheet as shown in the following screenshot:
5
.5
.As you can see, the way the Grid component works is quite straightforward. It displays a simple table with the values in the spreadsheet cells we bound to the component. The value of each cell can then be adjusted when we run the dashboard. As with all the insertion-like components, the actual value in the spreadsheet cell will change as well and can be used in Excel functions or other components that refer to this cell.
In the General tab, we can set the Minimum Limit and Maximum Limit fields that we can change a value to. This means that if the initial value of a cell lies outside this range and you want to change the value, you can only change it to a value within the range.
Under the Common sub-tab of the Behavior tab, these limits can be set to Fixed or Open. If you choose the Open option, the Scale fields on the General tab are grayed out.
Furthermore, you can set the Mouse Sensitivity level. This will set the speed in which the values will increase or decrease when changing them. If you set Scroll Behavior to Auto, the values keep changing if you click the cell and drag the cursor a bit above or below the cell. If you use the Manual option instead, you have to keep moving your cursor up or down to change the value.