The Zoom page controls the behavior of all Zoom In operations except within the selected group.
Next Level—Select to retrieve data for the children of the selected member or members, which is the default zoom option. For example, in the Sample Basic database, a zoom in on Year retrieves Qtr1, Qtr2, Qtr3, and Qtr4.
All Levels—Select to retrieve data for all descendants of the selected member or members. For example, in the Sample Basic database, a zoom in operation on Year retrieves all quarterly and monthly members.
Bottom Level—Select to retrieve data for the lowest level of members in a dimension. For example, in the Sample Basic database, a zoom in operation on Year retrieves Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, and Dec.
Sibling Level—Select to retrieve data for the siblings of the selected member or members. For example, in the Sample Basic database, a zoom in operation on Jan retrieves Jan, Feb, and Mar.
Same Level—Select to retrieve data for all members at the same level as the selected member or members. For example, in the Sample Basic database, a zoom in operation on Sales retrieves COGS, Marketing, Payroll, Misc, Opening Inventory, Additions, Ending Inventory, Margin %, and Profit %.
Same Generation—Select to retrieve data for all members of the same generation as the selected member or members. For example, in the Sample Basic database, a zoom in operation on Sales retrieves COGS, Marketing, Payroll, and Misc.
Formulas—Select to retrieve data for all members those are defined in the formula of the selected member or members. The formula can be a member equation or a consolidation to the parent. For example, in the Sample Basic database, a zoom in operation on Margin % retrieves Margin and Sales.
Include Selection—Select to retain the selected member and the other members retrieved as a result of the zoom. By default, Include Selection is enabled. For example, in the Sample Basic database, a zoom in on Qtr1 retrieves data for Jan, Feb, and Mar, and Qtr1. When this option is disabled, the zoom in retrieves only Jan, Feb, and Mar; Qtr1 is eliminated.
Within Selected Group—Select to apply only to the group of members in which the selection is made. By default, this setting is disabled. This setting is only meaningful when the worksheet contains two or more dimensions of data down a worksheet as rows or across a worksheet as columns. (This setting also affects the behavior of Keep Only and Remove Only operations.)
Remove Unselected Groups—Select to remove all dimension groups that are not in the selected group.
Enable Hybrid Analysis—Select to display members from a Hybrid Analysis relational source in the report. By default, this option is not selected. In the Outline Editor of Administration Services Console, if the Hybrid Analysis tag for a dimension is disabled, this tag setting overrides the Enable Hybrid Analysis setting.
Sampling Percentage—Enter an integer between 1 and 100 to represent the approximate percentage amount of an Essbase cube to query during a Zoom In operation. If Hybrid Analysis is enabled and in use, this percentage also applies to queries to the underlying relational database.
For example, if you enter 50, approximately 50% of the members of the Essbase database and, if applicable, the specified columns of the relational database are queried when you select the Zoom In command.
To use this functionality, the sampling feature must be enabled. Use the Sample Data (Zoom In) command to enable sampling.