Defining a Web Templates Setting 

Use

The Reporting Agent allows you to pre-calculate Web templates, that is, HTML documents with BW-specific placeholders, in the background. In the Web browser, if you call up a Web Report that is structured on the basis of a pre-calculated Web Template, you can access pre-calculated data without having to execute an OLAP query. This means that access time is considerably reduced and strain on the application server is relieved.

However, please note that the pre-calculated Web Templates are static and do not allow OLAP navigation.

Prerequisites

You can find more information under:

Web Templates

Creating Web Applications with the BEx Web Application Designer

You can find further information under Control Query for Pre-calculating Web Templates.

Procedure

  1. You are in the Reporting Agent function area of the Administrator Workbench. Choose Web templates in the navigation frame of the Administrator Workbench. You can see available roles as well as the workbooks and Web templates assigned to them in the left-hand Reporting Agent Scheduler tree.
  2. Navigate to the required Web Template.
  3. You have the following options to create a new setting:

The "New Reporting Agent Setting" dialog box then appears.

  1. Enter a technical name and a description.

The following information can be found in the General tab page:

  1. Choose the Parameters tab page.
  2. Select from the Calculating group header what the system is to pre-calculate.

Pre-calculate

Information

 Data

Accessing pre-calculated data leads to a marked improvement in performance: The data is no longer requested from the OLAP processor, and only the HTML pages must be generated.

With complex queries with

  • complex selection criteria
  • TopN conditions
  • calculated indicators

We recommend that you pre-calculate the data.

 HTML pages:

  • HTML for Web Browsers
  • HTML for Pocket IEs

The Reporting Agent supports various device classes. You can pre-calculate HTML documents for Web Browsers and mobile devices.

When managing HTML(HyperText Markup Protocol) documents and the MIME(Multipurpose Internet Mail Extensions) objects that belong to them, the BW uses the SAP Document and Content Management service (Content Management Framework).

 Excel

The data is exported into MS Excel. (You can find further information in the documentation for the corresponding command for Query Views under Exporting Data .)

You can also select more than one options.

  1. In the Language group header, set the language(s) for which you want to calculate the data. There are the following options to choose from:
  1. Under the Recipient group header, you can set authorization for access to pre-calculated Web templates. There are the following options to choose from:

You can find a more detailed description of the procedure under Editing Follow-Up Actions: Send Message in the Select Message Recipient section.

  1. Under the Filtering group header, you can determine whether you want to parameterize the Web template using the result of a control query.

Enter the technical name. Input help functions are available. After saving, the system updates the information according to your selections.

  1. If the control query contains entry-ready mandatory variables, you need to assign a variant in the Variant field.
  2. If the Web application requires you to enter a variable, under the Variants group header, you can generate one or more pre-allocated variables in the form of a URL parameter string.

Variant

Procedure

 Create

  1. Choose Create. The Generate Variant for Web Template dialog box appears. The variable screen appears if the Web application uses variables.
  2. Make the settings you want , enter a technical name and a description.
  3. Choose Next. The system adds the new variant to the list of variants.

 Change

If one or more variants have been created for a Web template, you can complete the associate parameter string with additional parameters.

  1. Highlight the variant to be changed.
  2. Choose Change. The Generate Variant for Web Template dialog box appears. The system displays the parameter string for the pre-allocated variables.
  3. Make any changes that you want to make.
  4. Choose Next.

 Execute

Choose Execute if you want to change the pre-allocated variables for a variant you have already created. The variable screen appears again.

 Delete

 

Example for pre-assigned variables: Interval variables.

&var_name_1=myIntVar&var_value_low_ext_1=LowVal&var_value_high_ext_1=HighVal

Further information is available under Pre-assigning Variables for Web Applications.

  1. Select the Preview tab page.

A preview window is shown in the right-hand screen area of the tab page.

  1. To display the template’s source code, choose the Template tab page.
  2. Save your setting.
  3. Choose Activate.

Result

Once you have defined the Reporting Agent settings, you have to assign them to a scheduling package for the background run.

For more information see Processing a Scheduling Package.

Once the background run has finished, HTML pages, MS Excel files, and the pre-calculated data for the Web template is available for you to use.

Further information about accessing pre-calculated data or HTML pages when calling up Web templates can be found under Parameter DATA_MODE.

You can also access pre-calculated HTML pages via Web folder.

You can store pre-calculated HTML pages locally using the document storage WebDAV Service in the content management framework. This is a simple procedure. (Restricted) offline reporting is thus possible.

You can find further information about the WebDAV service under Using External Tools .

See also:

WebDAV(World Wide Web Distributed Authoring and Versioning)