MicroStrategy ONE

Auto text codes for dataset report information

The auto text codes listed in the table below allow you to add dataset report information to your document.

For all these codes, replace REPORTNAME with the name of the related dataset report. If it contains any spaces or special characters, type the name within square brackets, that is, [ ]. For example, for a report named Sales Forecast, type {&[Sales Forecast]:}. Special characters are defined as anything other than a-z, A-Z, #, _, . (period), and 0-9.

If you do not specify the report's REPORTNAME as part of the code, the information from the document's grouping and sorting dataset is printed. For a document that contains multiple datasets, one dataset must be defined as the grouping and sorting dataset; you can group and sort only by the objects on this dataset.

Description

Code

Sample Output

Comments

Dataset report description

{&REPORTNAME:DESCRIPTION}

Revenue, profit, & cost by employee & region

Displays the report description of the specified dataset report. If the report 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: (2027)
Filter for Year = 2027
Year = 2027

Report Limits:
Revenue > 2000000

Template:
Region
Employee

Metrics:
Revenue

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

You can configure how this auto text code is displayed (for example, if the report description is shown). For details, 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=2022 or Year=2023)

Displays the report filter and report limit used in the dataset report.

If the dataset report has a report filter and a report limit, the system prints an "or" between them. If the report does not have a filter, "Empty Filter" is printed. If the report does not have a limit, the text "Empty Limit" is printed.

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

{&PROMPTDETAILS}

Prompt 1: Region prompt
Northwest, Southwest

Prompt 2: Year

Displays the prompt information for all prompts in the document. You cannot specify a dataset report.

You can configure how this auto text code is displayed (for example, if the prompt name is shown). For details, see Configuring the report prompt details auto text code.

Dataset report filter details

{&REPORTNAME:
REPORTFILTERDETAILS}

Report Filter:
Year = 2027

Displays the report filter used in the specified dataset report.

Dataset report limit details

{&REPORTNAME:
REPORTLIMITDETAILS}

Report Limits:
Revenue > 2000000

Displays the report limit used in the specified dataset report.

Dataset report template details

{&REPORTNAME:
TEMPLATEDETAILS}

Template:
Region
Employee

Metrics:
Revenue

Returns the complete template details, including attribute details and metric details.

You can configure how this auto text code is displayed (for example, if the template name is shown). For details, see Configuring the template details auto text code.

Dataset report execution time

{&REPORTNAME:
EXECUTIONTIME}

11/15/2023 7:10:55 PM

Displays the date and time the dataset report was executed, or, for an Intelligent Cube, the cube publication date and time.

Related Topics