SAP BI concepts,
technology, and
best practices
Part of the
knowledgebase
|
|
SAP BI concepts,
|
Part of the
|
|
This article was printed from the BI Expert knowledgebase. You can find the original version here: http://www.bi-expertonline.com/article.cfm?id=1981 Reproduction of this article is strictly prohibited. |
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. |
|
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.
|
|
Copyright © 2010 Wellesley Information Services. All rights reserved. Email: customer.service@bi-expertonline.com.
|