Select language:

Query, Reporting and Analysis Design

Query, Reporting and Analysis Design refers to the following functional area in Business Explorer:

With BEx Query Designer, business experts provide queries that can be used to perform flexible and user-friendly analyses of  BW data.

The queries serve as data providers for Web applications created with BEx Web Application Designer. You can modify Web applications to meet the requirements of various types of users. For example, BW data can be presented in a concise form for quick information purposes, or in complex and interactive applications for business analysts.

Business can experts use BEx Report Designer to create formatted reports. This tool provides various functions, for example to select formats, fonts, and data layouts to add header and footer rows to reports. These reports are optimized for displaying and printing.

BEx Report Designer is integrated into BEx Web Application Designer. This means that reports can be integrated into BEx Web applications using the Report Web item.

BEx Web applications and reports are accessed in the portal.

Prerequisites

To use Query, Reporting, and Analysis Design, you have to configure SAP NetWeaver Application Server (SAP NetWeaver AS). Before you can use SAP NetWeaver AS functions, you have to set the relevant profile parameters for configuring SAP NetWeaver AS. For detailed documentation about profile parameters, seeParameterization of ICM and the ICM Server Cache.

Note

Note that the BW standard client is used when you log on to SAP NetWeaver AS. The BW standard client is determined using the profile parameter login/system_client. You normally log on to SAP NetWeaver AS in the BW standard client. Alternatively, you can enter the client with the URL parameter &sap-client=<CLIENT>. To log on, you need either the BW default client or the URL parameter.

Tasks on Demand

The major administration tasks to be executed on demand are:

Tasks to Be Performed Once Further Information

Migrating Web templates

A migration tool is available that enables you, if required, to migrate Web templates that were created in the ABAP runtime to Web templates that can be used in the JAVA runtime.

More information:Web Templates andMigration Tool

Specifying standard Web templates for ad hoc analysis and reports

You can use the Standard Web Templates for Ad Hoc Analysis (0ANALYSIS_PATTERN) to display queries from BEx Query Designer on the Web on an ad hoc basis.

Reports from BEx Report Designer are displayed on the Web using the Standard Web Template for Reports (0REPORT_TEMPLATE).

You can also define other Web templates as standard Web templates, for example Web templates that include your company logo. You can also change the delivered standard Web templates to meet your requirements.

For more information, see the SAP Reference IMG →   SAP Customizing Implementation Guide →   SAP NetWeaver →   Business Warehouse →   Settings for Reporting and Analysis →   BEx Web →   Set Standard Web Templates.

Specifying settings for Web templates

You can set the properties of Web templates for all Web applications in Customizing.

You make these settings in the SAP Reference IMG → SAP Customizing Implementation Guide → SAP NetWeaver → Business Warehouse → Settings for Reporting and Analysis → BEx Web → Determine Settings for Web Templates.

More information:Web Template Properties andWeb Template Parameters

Setting the size restriction for result sets

Using report SAP_RSADMIN_MAINTAIN (transaction SA38), you can specify the maximum size of the result set that users can query. This allows you to avoid result sets that are too large and that can have a negative impact on the performance and quality of Web applications.

More information:Setting the Size Restriction for Result Sets

Activating export services

To export PDF, PostScript and PCL files from BEx web applications, activate the Export Library for SAP Business Explorer. This is optimized for exporting larger documents.

More information:Activating Export Library for SAP Business Explorer.

To create PDF files (for example, if you want to create a print version of a Web application), you can also use the Adobe document services.

More information:Adobe Document Services Configuration Guide.

Activating personalization in BEx

Personalization in Business Explorer allows users to fill variables with user-specific entries, to save user-specific access to BW objects for the history view in the BEx open dialog, and to save user-specific start views for Web applications.

You activate personalization in the SAP Reference IMG → SAP Customizing Implementation Guide → SAP NetWeaver → Business Warehouse → Settings for Reporting and Analysis → General Settings for Reporting and Analysis → Activate Personalization in BEx.

More information:Personalization in BEx

Display query runtime statistics on the Web

You can display technical information about the performance of a Web application directly on the Web. If performance problems occur, you can send this information to SAP in a customer message for error analysis purposes.

To display the statistics data on the Web, add parameter &PROFILING=X to the start URL of the Web application.

More information:Displaying BW Query Runtime Statistics on the Web

Create external data sources in the portal's system landscape

To enable users to perform ad hoc analyses in BEx Web applications and reports based on multidimensionally stored data from third-party providers, you have to create the appropriate data sources in the portal system landscape. You do this using BI Java Connectors. Business experts can create Web applications and reports in BEx Web Application Designer and BEx Report Designer using this data.

You make these settings in the SAP Reference IMG → SAP Customizing Implementation Guide → SAP NetWeaver → Business Warehouse → UDI Settings by Purpose → Integration of BEx Web.

More information:Accessing External Data Sources

Tasks to Be Performed More Than Once

Further Information

Mass maintenance and mass conversion of Web templates and reusable Web items

Mass maintenance of Web templates and reusable Web items enables you to automatically change multiple Web templates or reusable Web items at the same time. You can simultaneously export or import multiple objects and execute simple replacement operations.

More information:Mass Maintenance and Conversion of Web Templates and Reusable Web Items

Setting the portal theme

Themes determine the colors and appearance of the portal desktop. In the portal, BEx and BW objects are always displayed with the current user theme.

You can set the user themes in system administration.

More information:Formatting of Web Applications andUnderstanding Portal Themes

Assigning roles in the portal

You assign roles to users for working with BW content in the portal. These are managed by the Portal Content Directory (PCD).

More information:Assigning Portal Roles to Users and Groups.

Maintaining sender-recipient assignment

You make the required settings for connecting a query to the report-report interface (RRI) by choosing SAP Menu → Business Explorer → Query → Jump Targets.

More information:Changing and Creating Sender/Receiver Assignments

Setting intervals and hierarchies for time characteristics

For time characteristics, you can specify the time interval that appears in the F4 help for the characteristic values. You normally have to make this setting once a year.

You can also specify hierarchies for the time characteristics that you want to use in reporting. The leaves of the hierarchy are then located in the time interval that you have set.

You make these settings in the SAP Reference IMG → SAP Customizing Implementation Guide → SAP NetWeaver → Business Warehouse → Settings for Reporting and Analysis → General Settings for Reporting and Analysis → Set F4 Help and Hierarchies for Time Characteristics/OLAP Settings.

More information:Activating Virtual Time Hierarchies

Deleting query objects

You can delete queries, structures, and calculated or restricted key figures by choosing SAP Menu → Business Explorer → Query → Delete Objects.

More information:Deleting Query Objects

Copying queries between InfoCubes

You can copy queries and their subobjects (structures, calculated key figures, and restricted key figures) between various InfoCubes by choosing SAP Menu → Business Explorer → Query → Copy.

More information:Copying Queries Between InfoCubes

Tasks Performed Regularly

The following tasks are performed periodically:

Tasks Further Information

Monitoring log files (when using Java components)

The log files can be found in the Log Viewer in logging category /Application/BIunder ./log/Application/BI/*.

More information:Monitoring and Displaying Log Files

Reorganize bookmarks

You can use report RSWR_BOOKMARK_REORG (transaction SA38) to reorganize and delete bookmarks.

Bookmarks are saved navigational states of Web applications. In the BW system, they are created when:

  • You execute the Broadcast and Export → Bookmark function in the context menu of a Web application
  • You personalize Web applications

More information:Reorganizing Bookmarks

Monitoring the availability of BEx Web Applications and information broadcasting

The central monitoring system in the CCMS uses the Generic Request and Message Generator (GRMG) to check the availability of the SAP J2EE Engine at set intervals. If the availability check fails, an alert is triggered in the central monitoring system. This helps you to establish whether servers or processes in the J2EE Engine have failed. You can use the CCMS Alert Monitor (transaction RZ20) to check whether alerts have been triggered for BEx Web Applications and information broadcasting.

For more information about availability monitoring for BEx Web Applications and Information Broadcasting, see Customizing for SAP NetWeaver BW, under SAP NetWeaver →   Business Warehouse →   Settings for Reporting and Analysis →   General Settings for Reporting and Analysis →   Availability Monitoring for Information Broadcasting and BEx Weband SAP Note 883356.

Troubleshooting

In BEx Web Application Designer, you can record traces to analyze problems in Web applications. For more information, seeFunctions in the Tools Menu under → Settings → General.

The function for recording traces is automatically always activated in BEx Report Designer.

The trace file is a text file that contains a log of the activities performed by the BEx tool in question. It is stored in your system's temporary folder. You can find the TRACE location in the log configuration under com.sap.ip.bi.webapplications. The default importance level is ERROR. More information:Log Configuration with SAP NetWeaver Administration.

The recorded traces help to resolve problems that you report to SAP as customer messages.