Making General Settings for Precalculation and Creating Links 

Use

If you have selected a particular file format (HTML, PDF, PS, or PCL, for example) as the output format, you can make a number of different settings on the General Precalculation tab page.

If you have selected an online link as the output format, you can use the setting options on the General Link Generation tab page.

Features

Theme

You can specify the theme you want to use here. The theme determines the colors and appearance of the precalculated BI object.

The themes that are available depend on the selected output format. The BEx Broadcaster provides the relevant themes for the output format.

More information: Portal Themes.

Only Upon Data Change

Here, you specify that the broadcast setting is only distributed when the data displayed in the distributed document has been changed since the last distribution in the underlying data provider (for example in the query). If the displayed data has not changed, the document is not distributed.

You can only make this setting for queries and Web templates.

The BEx Broadcaster can only apply this function if the broadcast setting itself has not been changed. If the broadcast setting has been changed, the BEx Broadcaster distributes the document in accordance with your settings, without checking whether changes have been made to the displayed data.

Excel 2000 Format

If you selected XML (MS Excel) as the output format for queries and query views, you can define that the system creates a format that is supported by Microsoft Excel 2000. To do this, choose the option Excel 2000 Format.

Otherwise the system creates a format for Microsoft Excel 2003.

Transfer Navigational State

This function is only available when you start the BEx Broadcasting Wizard from a Web application (by choosing Distribute in the context menu) and then navigate to the BEx Broadcaster.

●      If you want the precalculated document or the online link to have the current navigational state of the Web application, choose Apply. The current navigational state is the state from which you called the BEx Broadcaster in the context menu by choosing Distribute.

●      If you want the precalculated document or the online link to have the initial navigational state of the Web application, choose Delete. The initial navigational state is the start view when the Web application is called (from the Web Application Designer, for example).

Variable Assignment

Ignore: When creating an online link, you can make a setting on the Link Creation tab page to define that the values for input-ready variables are not set. When the recipient opens the online link, the variable screen can appear, allowing the recipient to enter the required variable values. This is the case, for example, if the variable has the setting Mandatory, Initial Value not Allowed.

Variable Assignment: You can create values for the BI object’s input-ready variables (Query, Query View, Report, or Web Application). The BI object is precalculated using these variable values. These variable values are set whenever an online link is opened.

Take from Variant: You can select from a variant for the BI object (Query, Query View, Report, or Web Application). The BI object is precalculated with the values of the variant. These variable values are set in accordance with the variant whenever an online link is opened.

Variables can also be assigned from variants for workbooks. For more information about the settings on the Workbook Precalculation tab page, see Precalculating and Distributing Workbooks.

If you have selected Online Link to Current Data as the output format, the variable assignment is appended to the URL. When the recipient opens the online link, the BI object is started with these variable values.

When you precalculate a file, you can specify one or more variable assignments on the General Precalculation tab page. When you generate online links, you can assign only one variable.

Exceptions

If the query or Web application contains exceptions, you can specify whether they are to be considered during precalculation or generation of online links.

●      No Consideration: The system precalculates the query or Web application or generates an online link regardless of whether an alert occurred.

●      Only Precalculate at Minimum Alert Level: The query or Web application is only precalculated or distributed as an online link if an exception occurs within it that has a specific minimum alert level or a worse alert level. Specify the required minimum alert level.

Starting a Query or Query View in BEx Analyzer

When creating an online link to a query or query view, you can go to the General Link Generation tab page and specify under Start in BEx Analyzer whether you want the online link to start the query or query view in BEx Analyzer.

If you activate this function, you cannot specify variables or variable assignment. If exceptions are used in the query or query view, it is not possible to check the alert level.