Strategy ONE

Auto Text Codes for Dataset Information

You can manually enter these auto text codes in a field to display relevant dataset information.

Description

Code

Comments

Dataset report description

{&REPORTNAME:
DESCRIPTION}

The short description of the specified dataset.

Dataset report details

{&REPORTNAME:
REPORTDETAILS}

The complete report details, including report description, prompt details, filter details, and template details of the specified dataset.

Dataset report filter and limit details

{&REPORTNAME: FILTERDETAILS}

or

{&FILTERDETAILS}

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" appears. If there is no limit, "Empty Limit" appears.

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 appear.

The report filter and report limit appear by default, but you can display other filters, such as view and security filters.

Dataset report prompt details

{&REPORTNAME:
PROMPTDETAILS}

The prompt information for all prompts in the specified dataset.

Dataset report filter details

{&REPORTNAME:
REPORTFILTER
DETAILS}

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 appears.

Dataset report limit details

{&REPORTNAME:
REPORTLIMIT
DETAILS}

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 appears.

Dataset report template details

{&REPORTNAME:
TEMPLATEDETAILS}

The complete template details, including attribute and metric details.

Dataset report execution time

{&REPORTNAME: EXECUTIONTIME}

The date and time of the dataset execution or the cube publication date and time.