Show TOC

Using Text VariablesLocate this document in the navigation structure

Use

In the BEx Broadcaster, you can use text variables in different places. The variables are used as placeholders and are filled with the relevant text when the broadcast setting is executed.

For example, you can use text variables in the subject line and contents of an e-mail when the document is distributed by e-mail. The same applies when you define the file name and display name of a document that is distributed to the portal.

When broadcasting by exception, which you normally perform in system administration, you can use text variables when assigning parameters to an alert, for example.

Procedure

At the point where you want the text variable to appear in place of a fixed text, choose with the quick info text Attach Text Variable.

The possible text variants appear in the BEx Broadcaster as context-sensitive. Depending on the settings made in a broadcast setting, different text variables are suited to different places. The BEx Broadcaster only displays the text variables that are available.

The following text variable groupings exist:

Grouping Examples

Text variables for the broadcast setting

OWNER: Specifies the first and second name of the creator of the broadcast setting

OBJECT_TYPE: Specifies the object type (for example, Query, Web Template, Report)

OBJECT_ID: Specifies the technical name of the query (query, query view, Web template, report, workbook)

OBJECT_DESCRIPTION: Specifies the description of the object

Text variables for the system settings

LANGUAGE: Specifies the language (for example, English)

LANGUAGE_ID: Specifies the language ID (for example, EN)

DATE: Specifies the date

TIME: Specifies the time

Text variables for times

WEEK: Specifies calendar year/week

MONTH: Specifies calendar year/month

QUARTER: Specifies calendar year/quarter

YEAR: Specifies the calendar year

Text variables for document attributes

PR_ONLINE_LINK: You can use this to add an online link to the distributed object in the text.

PR_MAX_ALERT_LEVEL: Specifies the highest alert level

Text variables in exception reporting context

XML_ER_NUMBER_TOTAL: Specifies the total number of exceptions that occurred

XML_ER_NUMBER_BAD: Specifies the number of bad exceptions

XML_ER_NUMBER_CRITICAL: Specifies the number of critical exceptions

XML_ER_NUMBER_GOOD: Specifies the number of good exceptions

With some cells, you can use the text variable XML_ER_EXCEPTION, for example, which provides the text for the exception.

When generating SAP alerts, all the details of the exception cell are available as text variables, such as the text variables for the characteristic values.

Text variables cannot be selected in the broadcasting wizard.