Your SAP Resource  »  Publications  »  SAP Experts  »  BI Expert Online

Log In  |  Help

BI Expert

SAP BI/BW/BusinessObjects
concepts, technology, and
best practices

Part of the
SAP Experts
knowledgebase

Subscribe/Renew Now

Browse by Category  |  Advanced Search »

Go

Home

Knowledgebase Overview

Article Index  |  PDF

Free Sample Article

Frequently Asked Questions

Downloads

Webinars

SAP NetWeaver/BI and Portals 2011 Conference

SAP Insider Event Calendar

SAP Experts Knowledgebases

About Us

Contact Us

Knowledgebase  »  Volume 1 (2003)  »  Issue 10 (November)

Find Reporting and Performance Problems Before Your Users Do  Print

by Joerg Boeke, Director, Business Intelligence, syskoplan AG

Problems with the reports or routines you build are not always obvious until they are in live use. In some cases, performance might be slower than it should be, or in other cases incorrect data finds its way into important reports. The author shows you how to create an audit workbook, which bundles all your test queries, so that you can automate your testing process. You will also learn how to audit BW metadata and query performance.

Categories: Performance, Reporting

Has a user ever called you about a reporting performance problem even though all your scheduled tasks ended properly? Or, has a reporting user complained to you about obviously false data in a report? More and more important decisions are being made based on BW reports, but problems with query performance and data correctness make your BI installation less reliable (and your job less enjoyable).

For example, what about the case where an InfoPackage for loading data into an InfoCube ends properly, when the data in the InfoCube is visible, but either the performance is nasty or the data itself is buggy due to a failure in processing or booking data into an InfoProvider without causing a short dump? Your manual checks, process chains, or third-party scheduling tool do not spot the problems.

Would you like to see the full version of this article?

If you are an electronic license holder to BI Expert, please click here to log in.

If you would like information about becoming an electronic license holder — and having 24/7 unrestricted access to all articles and content in the BI Expert online knowledgebase — click here to see the available subscription options.

Or call 1-781-751-8799 to speak directly with a subscription and licensing specialist about customized access for you and your team.

Isn't your SAP implementation worth world-class information support?

Copyright © 2010 Wellesley Information Services. All rights reserved. Email: customer.service@bi-expertonline.com.
BI Expert, 20 Carematrix Drive, Dedham, MA 02026, USA.
Sales and Customer Service: 1-781-751-8799
SAP and the SAP logo are trademarks or registered trademarks of SAP AG in Germany and several other countries.