SAP NetWeaver 7.01: Hidden Feature Enables End Users to Define Ad Hoc Formulas in Web Analyzer

  • by Gary Nolan, SAP BI Strategic Architect, Sapiex Associates LLC
  • April 6, 2010
A new feature in SAP NetWeaver 7.01 enables end users to alter existing queries, or to change key figures in a query.
Key Concept
Ad hoc formulas were implemented as part of SAP enhancement package 1. This feature allows the end user to create formulas and add them to Web queries. They can then save the formulas when the query is saved as a favorite. The formulas can be reused as if they existed in the original query.

Many SAP NetWeaver BW administrators lock or severely restrict the capabilities of changing queries by end users. This is to prevent the end user from altering the query in some way that would adversely affect the result set or overall performance. Often, end users would like the ability to alter or add their own key figures to the existing query. Without the ability to modify the query, this is not possible.

To address this need, SAP added a new feature called ad hoc formulas to the Web Analyzer. I will discuss how to enable this feature to create ad hoc formulas and embed them into a Web Analyzer query. To use ad hoc formulas, the system must be upgraded to SAP enhancement package 1 in SAP NetWeaver 7.0 (also known as SAP NetWeaver 7.01). This SAP enhancement package makes the new ad hoc formula function available in the Web template for the end user to use. Before upgrading to SAP enhancement package 1, you need to take care of some prerequisites, which are described in SAP Note 1248905.

Gary Nolan

Gary Nolan is an SAP NetWeaver BW-certified consultant and author of Efficient SAP NetWeaver BW Implementation and Upgrade Guide and Efficient SAP NetWeaver BI Implementation and Project Management. Gary specializes in gathering and evaluating requirements, configuring SAP NetWeaver BW, and providing project management, performance management, and data architecture and data modeling expertise. A former platinum consultant with SAP America, Inc., Gary has more than 20 years of SAP experience, working with SAP NetWeaver BW since version 1.2B.

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.