Everything You Need to Know About Formatting Part 1: BEx Analyzer and BEx Query Designer

  • by Ned Falk, Senior Education Consultant, SAP
  • February 1, 2008
SAP NetWeaver BI 7.0 has increased formatting options over SAP BW 3.5. Learn how to create custom workbooks in SAP NetWeaver BI 7.0. Also, find out about other enhancements, including creating company default workbooks for logos and corporate formatting.
Key Concept

New in SAP NetWeaver BI 7.0, are improvements to the concept of a customized default workbook in BEx Analyzer. In addition to the logos and formatting controls available in SAP BW 3.5, you can also add buttons and other graphical user interface features to carry out specific tasks, such as to toggle the status of an exception or a condition.

SAP NetWeaver BI provides expanded options for formatting queries and reports in both the Web and Excel (BEx Analyzer) worlds. In this three-part series, I will discuss the choices you have for formatting. In this first part, I focus on BEx Analyzer and the formatting control available in queries. This includes discussion of enhanced key figures and cells in BEx Query Designer as well as default workbooks (logos, formatting control, and default properties for items).

The second article focuses on workbook themes, Excel controlled formatting, and the Formula mode and its formatting possibilities. The third article covers the Web, including portal themes, style commands, enhanced key figures, display options for exceptions, and an overview of the new format-intensive BEx reports.

Highlighted Display Setting

Before I go into the options you have for customizing the default workbooks, I want to bring your attention to a setting that’s changed with SAP NetWeaver BI 7.0. In previous versions of SAP BW, if you wanted to make a particular cell show up in bold font, you set the display to Emphasis in the key figure properties for the cell. In SAP NetWeaver BI 7.0, the Emphasis setting is now referred to as Highlighted Display, as shown in Figure 1.

Ned Falk

Ned Falk is a senior education consultant at SAP. In prior positions, he implemented many ERP solutions, including SAP R/3. While at SAP, he initially focused on logistics. Now he focuses on SAP HANA, SAP BW (formerly SAP NetWeaver BW), SAP CRM, and the integration of SAP BW and SAP BusinessObjects tools. You can meet him in person when he teaches SAP HANA, SAP BW, or SAP CRM classes from the Atlanta SAP office, or in a virtual training class over the web. If you need an SAP education plan for SAP HANA, SAP BW, BusinessObjects, or SAP CRM, you may contact Ned via email.

See more by this author


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.