SAP BusinessObjects: Two Tips to Improve the Look of Your Reports

  • by Isha Gupta, SAP BI Consultant, Accenture
  • June 22, 2011
Understand your custom formatting options when you are designing and creating SAP BusinessObjects Web Intelligence reports.
Key Concept
SAP BusinessObjects Web Intelligence is the flagship product for ad hoc, Web-based query creation and reporting for the casual end user. SAP BusinessObjects Web Intelligence allows you to access, analyze, and share reports on corporate data over intranets and extranets. It delivers a self-service reporting environment. You can use SAP BusinessObjects Web Intelligence on top of an SAP NetWeaver BW landscape and create user-friendly and interactive reports.

The introduction of the SAP BusinessObjects application as a part of SAP’s BI offerings led many companies to want to combine the SAP BusinessObjects applications with SAP NetWeaver BW. SAP BusinessObjects Web Intelligence is an ideal application to use data from SAP NetWeaver BW because it allows self-service reporting. However, you need to be cautious when combining the two applications to create SAP BusinessObjects Web Intelligence reports to ensure you achieve the desired functionality and interactivity.

I’ll take you through the basic steps with SAP BusinessObjects Web Intelligence XI Release 3.1 in combination with an SAP NetWeaver BW landscape to achieve some advanced formatting and display functionality available with SAP BusinessObjects Web Intelligence. I’ll focus on two key objectives:

  • How to display key figures from a custom structure
  • How to display the values selected by users for various variables

How to Display Key Figures from a Custom Structure

You may have a scenario in which you have a structure in a BEx query that contains many key figures, but in the SAP BusinessObjects Web Intelligence report you want to display only a selected few key figures from that structure. For example, in Figure 1, which shows a BEx query, you see a structure called Rolling Periods that has key figures related to various months and quarter time periods of a year.



Figure 1
BEx query with the structure Rolling Periods in columns

Isha Gupta

Isha Gupta is an SAP BI consultant in Accenture within its India Delivery Center. She is a subject matter expert with almost five years of experience in BI data model design, development, and reporting. She is a certified solution consultant in SAP NetWeaver 2004 Business Intelligence. She is proficient in various SAP BusinessObjects tools. Isha also has been involved in various SAP BI capability development activities within Accenture, including management of IDC SAP BI reusable assets, thought leadership, planning, and executing various client demos.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.