The grid point of view (POV) enables designers to specify the members for a dimension on a grid without placing the dimension on the row, column, or page intersection. After a dimension is specified on the grid POV, the designer determines the ways that the viewer can select members, as follows:
Any member. The viewer can select any member for the dimension.
A member from list. The viewer can select from a limited list of members that the designer previously defines.
Nothing, Lock Member Selection. The viewer cannot select any member for the dimension.
To improve report performance, do not use dimensions with only one member selected (for the entire grid) into a row, column, or page axis. Although, it does not increase the potential cell count, it adds overhead to the entire query. Dimensions that are variable or set to one member should be left in the POV. For variable members, include the user POV and for fixed members, include the grid POV. The rules for each database connection for a grid are as follows: - If the dimension is on a grid axis (row, column, or page), use the member selected for that dimension. - If the dimension is set on the grid POV, use the member selected for the grid POV dimension. - Use the member selected for the user POV dimension. |