Using Report Output to Perform Zoom Operations

To perform a simple (one-level) zoom in on a member in a view, send the output from the report that created the view as a script with the <CHILD (or <ICHILD) command before the member to be zoomed on. To perform a multilevel zoom in, use the <DESC or <IDESC commands. To perform a zoom out, use the <PARENT (or possibly the <ANCESTORS) command.

For example, consider the following report output:

       Actual  Sales  Cola
          Jan    Feb   Mar
East      109     85   112

If the user chooses to drill down on East, the report script might be as follows:

{SSFORMAT}{DECIMALS 0} <PAGE(Scenario, Measures, Product) <COL(Year) <ROW(Market)
Actual Sales Cola Jan Feb Mar <ICHILD East
!

This script generates the following report output:

           Actual  Sales  Cola
              Jan    Feb   Mar
New York       36     32    39
Massachusetts  24     09    14
Florida        37     29    37
Connecticut     0      5    11
New Hampshire  12     10    11
 East         109     85   112