QUOTEMBRNAMES
The Essbase Report Writer QUOTEMBRNAMES command displays all the member names within quotation marks in the report script output.
Note that when the report script is run through Smart View or another grid client, the members are not returned within quotation marks.
Syntax
<QUOTEMBRNAMES
Notes
QUOTEMBRNAMES can occur anywhere in a report script. This command is useful when using the Report Writer to export data intended for reloading a cube without the use of a data load rule file.
Note:
When used in a report script that also uses the RENAME report command, names substituted using the RENAME command are not enclosed in quotation marks.
Example
The following report script is designed for the Sample Basic cube, available in the gallery.
<PAGE (Scenario)
<COLUMN (Year)
<ROW (Product, Market, Measures)
<QUOTEMBRNAMES
{ROWREPEAT}
<ICHILDREN Year
<DIMBOTTOM Product
<DIMBOTTOM Market
<CHILDREN Profit
!
which produces the following report (truncated in this example):
"Scenario"
"Qtr1" "Qtr2" "Qtr3" "Qtr4" "Year"
======== ======== ======== ======== ========
"100-10" "New York" "Margin" 1,199 1,416 1,568 1,184 5,367
"100-10" "New York" "Total Expenses" 433 488 518 430 1,869
"100-10" "Massachusetts" "Margin" 1,237 1,533 1,741 1,224 5,735
"100-10" "Massachusetts" "Total Expenses" 164 155 149 162 630
...