Databases Reference
In-Depth Information
You can choose one, all, or none of the
Suppress
options.
Next up are the
Cells
options. Here you have four choices that you can
choose between:
1.
Use Styles:
This option will use any styles that have been defined for
this member in Essbase
2.
Adjust Columns:
This option when checked, will automatically adjust
the Microsoft Excel columns to fit the member names being retrieved
3.
Auto Sort Row:
This option tells Essbase to sort the member data according
to the structure of the database outline and is only available if you have the
Free Form
setting checked
4.
Repeat Member Labels:
This setting will populate every row of the
retrieved data with the member name or label
In the
Replacement
section of the
Essbase Options
screen, you have two choices:
1.
#Missing Label:
This allows you to tell Essbase what value to substitute
for null values that are returned in your report
2.
#No Access Label:
This allows you to substitute a value in cells that you
do not have the proper access to view
In the
Aliases
section, you have the choices of:
1.
Use Aliases:
This option will return the data using the member names
stored in an alias table. If you select this option, the
Alias
table combo-box
is available for you to choose the alias table from.
2.
Use Both Member Names and Aliases for Row Dimensions
: This setting
will fill two columns as row headers with both the member names and the
names stored in the selected alias table.
The
Query Designer
option will only affect you if you are using EQD. If checked,
it will apply the sheet options to the resultant report created from an Essbase query.
Lastly, the
Dynamic Time Series
option, when checked, allows you to choose
the last date from the time dimension to be used in dynamic time calculations.
As you can see in the next screenshot, we have indented the sub or children items by
checking the
Indent SubItems
selection, the columns are automatically adjusted to
fit the column names by checking the
Adjust Columns
checkbox, and the #Missing
and Zero values have been suppressed because only the calendar periods with data
have been displayed. You can tell this because the value for Quarter 1 is the same as
the value to 2009. If there were values for the subsequent calendar periods, the total
for 2009 would be different than the Quarter 1 2009 value.
