SAP NetWeaver BI 7.0 Discover New BEx Themes and Excel Formatting Options

  • by Ned Falk, Senior Education Consultant, SAP
  • March 1, 2008
Find out how to apply themes to your BEx Analyzer workbooks. In addition, see how you can use advanced Microsoft Excel options to further format your workbooks.
Key Concept
The themes formatting option for BEx Analyzer is modeled after the themes feature in SAP NetWeaver Portal. Themes allow you to separate the color and font scheme from the design elements of your workbook, such as buttons and tables of data. This means that you can have a different color scheme for an individual while keeping the basics of the workbook design the same for everyone.

SAP NetWeaver BI 7.0 provides expanded options for formatting and reusing formatting in both the Web and Microsoft Excel (BEx Analyzer) worlds. In this second part of my three-part series, I address a new use for custom collections of styles called workbook themes. I also discuss Excel formatting, including the new formula mode. I did all my testing on release level 70015.


In part one of this series I discussed styles in connection with default workbooks. In part 3 I will discuss the Web and its formatting options.



Just as styles are collections of formatting options, themes are collections of styles stored in a group, or theme name, on the SAP NetWeaver BI server. Normally administrators or experienced Excel people modify the styles, but instead of connecting the modified styles to a default workbook, you can create a theme for them and save them on the server.

Users allowed to save workbooks can select different themes to target different groups with differing color schemes. This control over styles does not affect the overall design because themes do not control the design elements, such as buttons or logos. These users can retrieve the styles and assign them to any workbook, thus overwriting the settings for any styles on the existing workbook. It doesn’t matter if the workbook started as a corporate default workbook or SAP’s delivered default.

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.