Workbook Sheet Automatic Generation
You can automatically generate several reports in several sheets within the current workbook, based on an existing report.
This feature helps you to quickly create several
worksheets inside a single workbook, based on a specific report but including
variable dimension members, and it saves you from having to create several
reports for different dimension members.
Note Each sheet is automatically named with the
dimension member combinations.
To automatically generate several sheets in the
current workbook, follow these steps:
- Create a report.
- For each dimension of the report, leave the context members selected by default, do not select other members.
- Select
EPM 
Report Actions Worksheet
Generation 
. The
Worksheet
Generation dialog box opens.
- Select the dimension, then click Select Members and select the members you want for the dimension. If needed, repeat the selection for the other dimensions.
Note The number of selected members for all
dimensions is displayed. Each time you select an additional member, the number
is updated.
Each automatically created sheet displays the initial report, but with different dimension members: the members you have selected. The dimensions for which you have selected members are automatically locked in the context bar on each worksheet. You can then unlock the dimension. For more information about the context lock, see Context.
Example Creating as many reports as quarters: For the year 2009, you
want to create one sheet per quarter. Create a report that meets your needs. Select EPM Report Actions Worksheet Generation . In the dialog box that opens, select the Period dimension, then select
the four quarters and click OK. Four sheets are automatically
created in the current workbook. Each one contains the same report, except for the
period members. The first sheet contains the report displaying data for quarter 1 of
2009; the second sheet contains the report displaying data for quarter 2 of 2009, and so
on.
EPM Report Actions Worksheet Generation . In the dialog box that opens, select the Period dimension, then select
the four quarters and click OK. Four sheets are automatically
created in the current workbook. Each one contains the same report, except for the
period members. The first sheet contains the report displaying data for quarter 1 of
2009; the second sheet contains the report displaying data for quarter 2 of 2009, and so
on.
The resulting workbook can contain different
worksheets, depending on the
Remove EPM Worksheets
Before Generation user option ( Options User Options Others ):
Options User Options Others ):
- If the
Remove EPM Worksheets
Before Generation option is selected:
- The workbook will contain the worksheets resulting from the generation, the dynamic formatting sheet (if any) and any other Microsoft Excel sheets (if any).
- The workbook will not contain any of the EPM worksheets existing in the workbook before you launch the generation, including the current worksheet.
- If the Remove EPM Worksheets Before Generation option is not selected, the workbook will contain all the worksheets existing in the workbook before you launch the generation and all the worksheets resulting from the generation.