You use the Properties tab to specify how values are displayed in the data preview grid.
The tab provides the following read-only boxes:
Name—Name of the grid worksheet
Connection pool—Name of the Deployment Services connection pool, if the target database uses one
The tab provides the following boxes, which you use to edit grid properties.
Description—Enter text (maximum of 128 characters) that describes the grid. Descriptions are not required.
Drill level—Select the level at which a drill operation retrieves data. The default, Next level, retrieves the child members. For example, if Year is selected, Qtr1, Qtr2, Qtr3, and Qtr4 are retrieved.
Indent Style—Select a setting (None not to indent values;, “Sub items” to indent descendants; or Totals, the default, to indent ancestors).
Latest member name—If working with a block storage database, enter the level 0 member of the time dimension. Also, select the “Specify latest member” option.
Alias table name—Select the alias table that is used to display alias names.
The tab provides numerous options, which, when selected, modify the grid in some way:
Include selection—The member on which a drill operation is performed is included in the list of retrieved members. For example, if you select the option and drill down on Qtr1, data is retrieved for Jan, Feb, Mar, and Qtr1.
Selection only—Only the members on which a drill operation is performed are retained after zooming in.
Within selected group— A drill operation is applied only to the members of the selected group. This setting, which is meaningful only if two or more dimensions as rows or columns contain data, also affects the behavior of Keep Only and Remove Only operations.
Suppress missing—Missing rows are excluded.
Suppress zero—Data rows that contain only zeros are excluded. When the option is cleared, Essbase does not redisplay data that contains zeros. To display zero data, you must clear the option, click Save, and reopen the grid.
Suppress underscore—Underscore characters within member names are not displayed.
Alias names—For retrievals, alias names, rather than member names, are displayed. This option is effective only if you selected an alias table from the “Alias table name” box.
Enable dataless navigation—You can perform grid operations, such as drilling and pivoting, without retrieving data. Be sure to clear the option before you initiate a data retrieval.
Empty grid error—If the grid is empty, an error is returned.
Repeat member names—For retrievals, member names are repeated. Because you can immediately see the member names associated with the data, this feature may be particularly useful for large grids. When the option is cleared, Essbase does not remove repeated members from the grid. To remove repeated member names, clear the option, click Save, and reopen the grid.
Use both for row dimensions—For each row member, member name and alias are displayed.
Specify latest member—For retrieval from block storage databases, the member specified in the “Latest member name” box is used.
Enable mid-tier caching—Grid data is stored in a middle-tier cache and, thus, retrieval time is reduced. Deployment Server runs as a servlet in the Essbase Administration Server application server. If the option is not selected, grid data is stored on Essbase Server.
Enable hybrid analysis—Members from Hybrid Analysis relational sources are displayed. If the selection of this option contradicts an Outline Editor “Enable hybrid analysis” setting, this option takes precedence. For outlines that contain multiple levels of Hybrid Analysis members, a drill-up operation on the bottom-level Hybrid Analysis member moves directly to the Essbase parent member, thus bypassing all other Hybrid Analysis levels.
Display unknown members—For retrievals, names that do not match database member names are displayed.