Bookmarks and Query Views Demystified

  • by Ned Falk, Senior Education Consultant, SAP
  • July 23, 2009
Bookmarks can improve performance, reduce query proliferation, and give users more of what they want: easily accessible targeted information. Find out how you can publish them through SAP NetWeaver Portal. Also, take a deeper look at bookmarks and query views to see how you can integrate both into dashboards.

Dear BI Expert,

I would like to know more about how to publish BEx Web bookmarks through SAP NetWeaver Portal 7.0. Could you help?

Thanks,
Jacques Renaux, Lhoist Group

Thank you for your letter. To best answer your question, I’ll use a typical business scenario. A company has a mix of users, including:

  • Analysts, who carry out numerous slice-and-dice navigations of varied information

  • Semi-analysts, who perform a few navigations of a contained scope of information

  • Executives/information consumers just obtaining information from reports with out much or any navigation

The company uses BEx Analyzer (Excel) and allows many users to author queries so they can view the data they need. The company now has a query proliferation issue with too many similar queries, causing system performance issues. It wants to move to the Web and limit query authoring to a few users, enabling these users to save specific data navigations. You can reduce the number of query authors by using bookmarks to enable users to view the data as needed. Figure 1 illustrates how bookmarks work with data.

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


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.