How to Enhance SAP BEx Web
Analyzer (0ANALYSIS_PATTERN)
Applies to:
SAP BI 7.0.
Summary
This article explains some features that can be used to enhance SAP BI Standard Web Template associated
to BEx Web Analyzer (0ANALYSIS_PATTERN) in order to create a new Customer Web Template that can
be used to define the Default (Standard) Web Template, or to deploy new Web Applications or to create link
items in Role Menu / Favorites.
Author: Gianfranco Vallese
Company: BGP Management Consulting S.p.A.
Created on: 09 May 2008
Author Bio
Gianfranco Vallese is Project Leader at BGP Management Consulting S.p.A..
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 1
How to Enhance SAP BEx Web Analyzer (0ANALYSIS_PATTERN)
Table of Contents
Standard Web Template – Additional Features..................................................................................................3
Step by step procedure.......................................................................................................................................4
Create a copy of Standard Web Template......................................................................................................5
Change default number or rows / columns of Analysis grid (table) ................................................................5
Add Push Button to call Variable Screen ........................................................................................................6
Enhance Web Template Layout......................................................................................................................8
Final Result .......................................................................................................................................................11
Default (Standard) Web Template ................................................................................................................12
Master Template to deploy new Web Applications.......................................................................................12
Generate links in Roles Menu / Favorites .....................................................................................................13
Related Content................................................................................................................................................15
Disclaimer and Liability Notice..........................................................................................................................16
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 2
How to Enhance SAP BEx Web Analyzer (0ANALYSIS_PATTERN)
Standard Web Template – Additional Features
The SAP BI Standard Web Template 0ANALYSIS_PATTERN, used with the BEx Web Analyzer, can be
enhanced with some simple customizing step. 0ANALYSIS_PATTERN Web Template brings all the main
features as BroadCasting, Export to XLS, CSV, PDF Printing, Graph: replicating these functionalities in a
Custom Template can be time consuming.
In this article we explain how to create a copy of BEx Web Analyzer (0ANALYSIS_PATTERN) and then how
to:
• Change default number or rows / columns of Analysis grid (table)
• Add Push Button to call Variable Screen
• Enhance Web Template Layout (e.g. adding Company Logo, InfoField)
The final result can be used as:
• Default (Standard) Web Template
• Master Template to Deploy New Web Applications
•
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 3
How to Enhance SAP BEx Web Analyzer (0ANALYSIS_PATTERN)
Generate Links in Roles Menu / Favorites
Step by Step Procedure
In the following paragraphs we explain how to create a new Web Application:
• Create a Copy of Standard Web Template
• Change Default number or rows / columns of Analysis Grid (Table)
• Add Push Button to Call Variable Screen
•
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 4
How to Enhance SAP BEx Web Analyzer (0ANALYSIS_PATTERN)
Enhance Web Template Layout
Create a Copy of Standard Web Template
Open SAP BEx Web Application Designer (Start Programs Business Explorer Web Application
Designer) and then search for the Web Template named 0ANALYSIS_PATTERN.
When the Web Template is opened you should receive some messages “E23 – The data provider could not
be instantiated”: that’s why no data provider (Query / View / InfoProvider) is assigned to the DataProvider
DP_1. Ignore these messages and save a copy (select Web Template menu -> Save as …) of the Web
Template: we named the copy “ZANALYSIS_PATTERN”.
This kind of message isn’t properly an “error”: it is used to highlight the fact that the DataProvider is not
assigned. The DataProvider will be instantiated dynamically during navigation, for example, when you start a
New Analysis or if the URL will be completed with a specific Query name.
Change Default number or rows / columns of Analysis Grid (Table)
The original Web Template shows a limited number of rows (17) / columns (4). When using “large” Queries
these are not fully displayed and users must scroll to see additional columns / rows.
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 5
How to Enhance SAP BEx Web Analyzer (0ANALYSIS_PATTERN)
In order to change the default setting switch to Overview tab in the Web Application Designer.
Locate the ANALYSIS Item: in the Web Item Parametes tab (Properties Panel) change both parameters
“Number of Data Rows Displayed at Once” (BLOCK_ROWS_SIZE) and “Number of Data Columns Displayed
at Once” (BLOCK_COLUMNS_SIZE) to 0.
Add Push Button to Call Variable Screen
In order to add a Push Button to call Variable Screen during Query navigation, in the Overview tab of Web
Application Designer locate BUTTON_OPEN_SAVE Item. Within this Button Group add a new button that
will be displayed near the others (“New Analysis”, “Open”, “Save as”).
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 6
How to Enhance SAP BEx Web Analyzer (0ANALYSIS_PATTERN)
Using the guided procedure you must set the following parameters:
• Command: OPEN_VARIABLE_DIALOG. In “All Commands” tab, search within “Command for
Web Templates”.
• Caption: you have many option to manage the pushbutton description. We decided to use
report text 707 from SAPLRRSV, therefore we decide to use “Language Dependent
Report Text” even if obsolete.
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 7
How to Enhance SAP BEx Web Analyzer (0ANALYSIS_PATTERN)
Enhance Web Template Layout
In this paragraph we will see a couple of sample customizations that can be done to enhance the Web
Template Layout: adding Company Logo and InfoField.
In order to manage objects positioning we decided to use a table: in the Layout tab of the Web Application
designer locate the Web Item QUERY_TITLE. This Item provides, during navigation, the description of the
Query in use in the header area. Place the cursor near the left side of QUERY_TITLE item and, using the
appropriate pushbutton from the toolbar, insert a table object made of 1 Rows and 3 Columns.
Then drag the QUERY_TITLE element in the second cell of the Table. In the first cell we are going to insert
Company Logo. To do this place the cursor in the first cell and from the ToolBar choose: Insert Image.
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 8
How to Enhance SAP BEx Web Analyzer (0ANALYSIS_PATTERN)
In the next screen you have to locate the picture you want to use as Company Logo in the MIME repository.
Images can be loaded in to the system, under the appropriate path, with transaction code SE80 – Object
Navigator MIME Repository SAP BW Customer Images Import MIME Objects. In the example
we are going to use the SAP Logo (corresponding file “images.jpg”); you can use your own images as well.
In the third cell of the added Table you can add additional Web Items to provide additional information about
the Query / Web Template. In our example we will add ad InfoField: place the cursor in the third cell and then
in the Web Items panel, switch to the “Advanced” section and choose Web Item type “InfoField”.
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 9
How to Enhance SAP BEx Web Analyzer (0ANALYSIS_PATTERN)
Move to the Properties panel and in the Data Binding section make the following settings:
• Text Element Type: GENERIC_TEXT_ELEMENT
• General Text Element for a Data Provider: CURRENT_USER
This kind of Web Item can be used in many other ways in order to display Dynamic or Static Filter values and
Variable value as well.
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 10
How to Enhance SAP BEx Web Analyzer (0ANALYSIS_PATTERN)
Final Result
The Web Template we have created can be used in several ways: for example if you haven’t deployed the
Portal you can use the Template as a sort of Web Analyzer that can be directly added as shortcut in MS IE
Favorites. Other ways to use the Custom Web Template we have created are:
• Default (Standard) Web Template
• Master Template to Deploy New Web Applications
•
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 11
How to Enhance SAP BEx Web Analyzer (0ANALYSIS_PATTERN)
Generate Links in Roles Menu / Favorites
Default (Standard) Web Template
You can set the Custom Web Template ZANALYSIS_PATTERN as Default (Standard) Web Template with
Transaction RSCUSTV27 (in SPRO Customizing Settings SAP NetWeaver Business Intelligence
Settings for Reporting and Analysis BEx Web Set Standard Web Templates).
Master Template to Deploy New Web Applications
In order to deploy new Web Applications based on the Custom Web Template open ZANALYSIS_PATTERN
through Web Application Designer and assign a Query or a View or directly an InfoProvider to the
DataProvider DP_1.
Then Save a copy of the Web Template providing suitable Technical Name and Description.
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 12
How to Enhance SAP BEx Web Analyzer (0ANALYSIS_PATTERN)
Generate Links in Roles Menu / Favorites
The Customer Web Template ZANALYSIS_PATTERN can be included both in Role Menu or in User’s
Favorites. The procedure is the same: we will explain the concept creating a link in User’s Favorites.
Place the cursor over Favorites folder and, from the context menu choose the option “Add other objects“
In the next screen you can choose different Object Types: BEx Web Template or SAP BW Query URL.
Within “Text” field you have to specify the Description. In the “Object description” field you have to type the
following address, taking care to replace the substring “QUERY_X” with the technical name of the Query you
want to be instantiated as DataProvider at runtime.
String elements as , and are variables that will be replaced
automatically by the system at runtime and are very helpful to create links that are independent from the
environment (Development, Quality or Production) you are working in.
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 13
How to Enhance SAP BEx Web Analyzer (0ANALYSIS_PATTERN)
Finally, in the following picture, you can see the result:
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 14
How to Enhance SAP BEx Web Analyzer (0ANALYSIS_PATTERN)
Related Content
Further information on these topics can be found using the links below.
BEx Web Analyzer
Analysis Web Item
Button Group Web Item
Open Variable Dialog Command
InfoField
Storing and Including Images and Icons
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 15
How to Enhance SAP BEx Web Analyzer (0ANALYSIS_PATTERN)
Disclaimer and Liability Notice
This document may discuss sample coding or other information that does not include SAP official interfaces and therefore is not
supported by SAP. Changes made based on this information are not supported and can be overwritten during an upgrade.
SAP will not be held liable for any damages caused by using or misusing the information, code or methods suggested in this document,
and anyone using these methods does so at his/her own risk.
SAP offers no guarantees and assumes no responsibility or liability of any type with respect to the content of this technical article or
code sample, including any liability resulting from incompatibility between the content within this document and the materials and
services offered by SAP. You agree that you will not hold, or seek to hold, SAP responsible or liable with respect to the content of this
document.
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2008 SAP AG 16