Auto text codes for dataset information

The following auto text codes allow you to add dataset information to your document. For all these codes, replace REPORTNAME with the name of the related dataset. If the name contains any spaces or special characters, type the name within square brackets [ ]. For example, to display the report details for a report named Sales Forecast, type {&[Sales Forecast]:REPORTDETAILS}. Special characters are anything other than a - z, A - Z, #, _, . (period), and 0 - 9.

Description	Code	Sample Output	Comments
Dataset report description	`{&REPORTNAME: DESCRIPTION}`	Revenue, profit, & cost by employee & region	The short description of the specified dataset. If the dataset does not have a description, the text field remains blank.
Dataset report details	`{&REPORTNAME: REPORTDETAILS}`	Report Description: Revenue, profit, & cost by region & employee Report Filter: (2007) Filter for Year = 2007 Year = 2007 Report Limits: Revenue > 2000000 Template: Region, Employee Metrics: Revenue, Revenue {~+}, Cost, Sum(Cost){~+}, Profit, Sum(Profit){~+}	The complete report details, including report description, prompt details, filter details, and template details of the specified dataset. You can configure how this auto text code is displayed (for example, if the report description is shown). For steps, see Configuring the report details auto text code.
Dataset report filter and limit details	`{&REPORTNAME: FILTERDETAILS}` or `{&FILTERDETAILS}`	If the filter in the dataset's Filter editor is defined as: A=1 AND B=2 OR C=3 it prints as: A=1 and (B=2 or C=3) For example, Region=South and (Year=2002 or Year=2003)	The report filter and report limit used in the dataset. An example is `{&[Sales Forecast]: FILTERDETAILS}` for the Sales Forecast report. If the dataset has a report filter and a report limit, the system displays an "or" between them. If there is no filter, "Empty Filter" is displayed. If there is no limit, "Empty Limit" is displayed. If you do not replace `REPORTNAME` with the name of the dataset, the filter and limit information from the document's grouping and sorting dataset are displayed. By default, only the report filter and report limit are displayed, but other filters, such as view filters and security filters, can be displayed as well. For details, see Configuring the filter details auto text code.
Dataset report prompt details	`{&REPORTNAME: PROMPTDETAILS}`	Prompt 1: Region prompt Northwest, Southwest Prompt 2: Year Year (ID)= 2007	The prompt information for all prompts in the specified dataset. You can configure how this auto text code is displayed (for example, if the prompt name is shown). For details, see Configuring the prompt details auto text code.
Dataset report filter details	`{&REPORTNAME: REPORTFILTER DETAILS}`	Report Filter: Year = 2007	The report filter used in the specified dataset. If you do not replace `REPORTNAME` with the name of the dataset, the filter information from the document's grouping and sorting dataset is displayed.
Dataset report limit details	`{&REPORTNAME: REPORTLIMIT DETAILS}`	Report Limits: Revenue > 2000000	The report limit used in the specified dataset. If you do not replace `REPORTNAME` with the name of the dataset, the report limit information from the document's grouping and sorting dataset is displayed.
Dataset report template details	`{&REPORTNAME: TEMPLATEDETAILS}`	Template: Region, Employee Metrics: Revenue, Revenue {~+}, Cost, Sum(Cost){~+}, Profit, Sum(Profit){~+}	The complete template details, including attribute details and metric details. You can define how this auto text code is displayed (for example, if the template name is shown). For steps, see Configuring the template details auto text code.
Dataset report execution time	`{&REPORTNAME: EXECUTIONTIME}`	11/15/2003 7:10:55 PM	The date and time the dataset was executed, or, for an Intelligent Cube, the cube publication date and time.