(BWFT-1711) User guide
DataVard
Headquarters in Germany Datavard GmbH Römerstraße 9 69115 Heidelberg
Germany
About Datavard
We deliver end-to-end support for your data!
Datavard is a global provider of SAP® performance management and system optimization solutions. Fortune 1000 customers have benefited from best practices that significantly reduce database size and solve performance issue that significantly impact cost and user satisfaction. In addition, The Datavard consulting model consists of templates for large IT events like SAP HANA™ migrations, upgrades, landscape transformations and more. SAP® customers benefit from smart and effective solutions that demonstrate achievement in reduction of operational budgets by allowing customers to focus on activities that enable them to excel in their field of expertise.
Datavard employs more than 180 people in six countries to support you in your everyday business as well as in strategic projects.
Find out more about Datavard at www.datavard.com
About the Datavard BW Fitness Test
Get a detailed overview of your business warehouse with the BW Fitness Test. This solution collects various data from your system and runs a comprehensive analysis that indicates problematic areas. It also allows you to benchmark your system against over 300 other SAP BW systems, so that you know where you stand and what needs to be improved to unlock the full potential of your system
Find a sample BW Fitness Test result here:
http://bwftsample.datavard.com/
Copyright
This manual and its content is copyright of DataVard GmbH - © DataVard 2017 . All rights reserved.
Any redistribution or reproduction of part or all of the contents in any form is prohibited other than the following:
- you may print or download to a local hard disk extracts for your personal and non-commercial use only.
- you may copy the content to individual third parties for their personal use, but only if you acknowledge this document as the source of the material.
You may not, except with our express written permission, distribute or commercially exploit the content. Nor may you transmit it or store it in any website or other form of electronic retrieval system.
SAP, ABAP, SAP Business Suite, SAP ERP, SAP Customer Relationship Management (SAP CRM), SAP ERP Human Capital Management (SAP ERP HCM), SAP ERP Operations, SAP ERP Financials, SAP Product Lifecycle Management (SAP PLM), SAP Supplier Relationship Management (SAP SRM), SAP Supply Chain Management (SAP SCM), SAP Business One, SAP Business All-in-One, SAP NetWeaver Business Intelligence (SAP NetWeaver BI), SAP NetWeaver Master Data Management, SAP NetWeaver, SAP Solution Manager, SAP Exchange Infrastructure (SAP NetWeaver XI) SAP Business Information Warehouse (SAP BW), SAP Strategic Enterprise Management (SAP SEM), SAP R/3, SAP R/3 Enterprise, SAP Business ByDesign, SAP BusinessObjects GRC Global Trade Services, SAP GTS are the trademarks or registered trademarks of SAP AG in Germany and in several other countries.
About this document
The purpose of this document is to explain to the end user the process of the installation and execution of the BW Fitness Test.
Table of Contents
DataVard
Copyright
About this document
Installation
Prerequisites to run BWFT successfully
DB statistics should be up to date
Query statistics should be turned ON prior to the BWFT execution
InfoProvider statistics should be turned ON prior to the BWFT execution
Steplist
Installation
Steps to install the transport requests:
- The installation files should be copied into a transport directory. Normally, the 'cofiles' should be copied into /usr/sap/trans/cofiles and the 'data' should be copied into /usr/sap/trans/data.
- Then the transports can be added to the Import Queue using the menu in STMS (Extras->Other Request->Add).
- Then the transports can be imported in the order, which is described in the transports.txt file. You obtained this file in the zipped folder, which you received from a DataVard consultant.
- User executing BW Fitness test should have this role assigned - /DVD/BWFT. It is part of the given transport.
Supported BW versions: 7.00 – 7.51 with up-to-date SPs
Supported database systems:
- MaxDB
- MSSQL
- DB2
- DB4
- DB6
- HANA
- Oracle
- Sybase ASE
- Informix
Prerequisites to run BWFT successfully
DB statistics should be up to date
- Details: In order to get accurate results for most of the BWFT collectors, database table statistics of all tables that are analysed must be up to date. DataVard BWFT analyses sizes and row counts of the database tables used for SAP system from its database statistics. Current and most accurate row count and size of a table cannot be retrieved during the BWFT execution due to performance reasons.
- Impact: If DB table statistics are not up to date, results don't have to be accurate. Outdated statistics on RS* tables can also cause performance issues during the BWFT execution.
- Action: Please check with your basis team if DB statistics can be updated short before the BWFT execution. Database statistics can be checked in DB20 transaction.
Query statistics should be turned ON prior to the BWFT execution
- Details: DataVard BWFT analyses a query and load performance in a BW system. In order to see runtime of queries executed in the past it is necessary that Query statistics (RSDDSTAT) are turned ON before the BWFT is executed. Our recommended period for the analysis of queries is 6 months, however capturing a month is sufficient. It is required that for analysed objects Query statistics must be turned ON with the setting - OLAP Statistics Detail Level = 2 - All (a system records all data from an area for the front end and calculation layer as well as data from an area for an aggregation layer and aggregation information).
- Impact: If Query statistics are turned OFF or turned ON only for selected queries this can cause some KPIs cannot be calculated properly. This applies also if query statistics are not turned on with Detail level "2 - All". This impacts only a single KPI of the BWFT - Query Performance. Query Performance KPI is not a showstopper for executing the rest of the BWFT.
- Action: Please check with your basis administrator or check the setting in a transaction RSDDSTAT.
InfoProvider statistics should be turned ON prior to the BWFT execution
- Details: DataVard BWFT analyses load performance in a BW system. In order to see details of executed InfoPackages in the past it is necessary that InfoProvider statistics (RSDDSTAT) are turned ON for all InfoProviders before the BWFT is executed (OLAP Detail level is not important here). Our recommended period for the analysis of InfoPackages is 6 months, however capturing a month is sufficient.
- Impact: If InfoProvider statistics are turned OFF or turned ON only for selected InfoProviders this can cause some KPIs cannot be calculated properly. This impacts only a single KPI of the BWFT - InfoPackage Performance analysis. This KPI is not a showstopper for executing the rest of the BWFT.
- Action: Please check with your basis administrator or check the setting in a transaction RSDDSTAT.
Steplist
- Run the transaction /DVD/BWFT.
- Create Run ID: enter a Run ID (max 9 characters) and click Create.
Recommendation: YY<abbreviation_of_company>##
Figure 1: Create Run ID
3. Double-click on Initialization
Figure 2: Main Menu on non-HANA system
Figure 3: Main Menu on HANA system
4. Fill the field Customer name with the name of your company. Do not change the values in "Time characteristics for analyses". After filling the field Customer name click on the Execute button. Then navigate back to the main screen.
Figure 4: Customer name & Time characteristics
5. Prerequisite check controls if system is ready for BWFT execution. There are three checked areas:
- Query statistics settings
- InfoProvider statistics settings
- Oracle statistics (only for Oracle DB)
Figure 5: Prerequisite check on Oracle DB
Query statistics settings:
Checks if all queries have proper Query statistics' setting – Detail level 2. If it's not the case for all queries, these are listed. You can check and change these settings in transaction RSDDSTAT. Please check Prerequisites part in the beginning of the documentation to check the impact.
Figure 6: Successful prerequisite check on non-Oracle system
InfoProvider statistics settings:
Checks if InfoProvider statistics are turned ON for all InfoProviders. If this is not the case, these are listed. You can check and change these settings in transaction RSDDSTAT. Please check Prerequisites part in the beginning of the documentation to check the impact.
Figure 7: InfoProvider statistics settings
Oracle DB:
If BWFT is executed on Oracle database, Prerequisite check contains Queries' statistics and DB statistics check as well. User can check which tables have their DB statistics out of date. If some tables have yellow/red icon assigned, the DB statistics of these tables should be updated. The up-to-date DB statistics are crucial for valid execution of BWFT. Please check Prerequisites part in the beginning of the documentation to see the impact.
Figure 8: DB statistics check on Oracle system
6. Once the Prerequisite part is completed double click on Main collectors. Set the Number of jobs. We recommend using 3 background processes. The run has no impact on the performance of the system. Leave field "App. server name" empty and "Keep alive" checked as seen below.
Figure 9: Main collector pop-up (number of background jobs)
7. You can monitor the running analyses by clicking on the monitor icon on the main screen.
8. When all the collectors from the group Main collectors are done, except for the Number range buffer collector (as can be seen in the picture below), you can continue according to point 10. If you execute HANA BWFT, continue with the point 9. Collector Number range is scheduled automatically to run again on fifth day to reach 100%.
Figure 10: Finished Main collectors on non-HANA system
Figure 11: Finished Main collectors on HANA system
9. If executing HANA BWFT, execute HANA post-processing task now.
Figure 12: Finished HANA post-processing task
10. Back in the main menu, please execute the step Dependent collectors. At the prompt, confirm that you would like to continue.
Figure 13: Confirm continuation
And in the settings box, enter similar values as in step 6.
Figure 14: Dependent collector pop-up (number of background jobs)
11.When all the collectors from the group Dependent collectors are done or done except for the item Biggest InfoProviders in three runs (as can be seen in the picture below) you can continue according to point. Collector Biggest InfoProviders in three runs is scheduled automatically to run on third and fifth day to collect the data about InfoProviders' growth in this period.
Figure 15: Finished Dependent collectors
12. Additional collectors' folder contains collectors which are not obligatory to execute, but are suitable for SLO project analysis. If you are not interested in organizational structure overview, you can skip this collector section and move to next steps. For detailed description of this section check Information button. If you execute BWFT on HANA system, please proceed directly to point 16 now.
Figure 16: Additional collectors
13. Back in the main menu double click on Generate tasks for DIMID collector. At the prompt, confirm that you would like to continue.
Figure 17: Confirm continuation
In the next screen click Execute. When the tasks are generated successfully, navigate back to the main menu.
14. Double click on DIMID collector tasks. Set the Number of jobs. We recommend using 3 background processes. The run has no impact on the performance of the system. Leave App. server name empty and Keep alive checked as can be seen in the picture below.
Figure 18: DIMID collector pop-up (number of background jobs)
15. When all the collectors from the DIMID collector tasks are done, continue with point 16. Sometimes the status displays a flash icon ; this means that a processed object was not accessible due to for example, data loading.
16. Make sure all of the Main Collectors and Dependent Collectors have completed their runs and scheduled jobs. This should not take more than 5 days (also with Number range and Biggest InfoProviders in three runs collector, which are executed in multiple runs). Once these jobs have run, just double click on Download analyses results into XML format in the main menu. The pop-up will ask you if you want to continue. Click Yes. Fill the File to save field with the path on your hard drive and specify the name of the file (e.g. results.xml…note that the extension .xml has to be entered as well). Leave package size as can be seen in picture below. When the XML files are generated, provide these to a DataVard consultant.
Figure 19: Download XML results