Login Form
Main Menu
Consultant Corner
Customer Corner
ERPGenie Websites
ERP Software Corner
Publications (28)
Books, Magazines.
ERPGenie.COM has an affiliate ID with Amazon.com. Books bought through clicking an amazon link on ERPGenie.COM allows ERPGenie.COM to collect a small % that is put towards it's operational cost.
|
Quick Guide - SAP BW Performance Tuning
December 2007
SAP BW Performance Tuning
By Shreekant Shiralkar and Bharat Patel
To purchase the book or read more
<click here >
Publish Date
December, 2007
Pages: 248
Sample Extract
To see a sample extract from Chapter one
About the Authors
Shreekant is Mechanical Engineer having over 20 years of experience. He is a certified SAP-BW and SAP R/3 consultant. His SAP expertise is well complemented by a rich experience of managing business functions. He has played a significant role in large scale SAP R/3, SAP-BW & SAP-APO implementation projects for various a fortune 500 companies.
His articles on SAP-BW, RFID, SAP-APO are published in professional journals from WIS Publications USA. He has presented papers at conferences such as SAP Summit, Computer Society of India, Business Intelligence India Group. Shreekant has been a faculty at SAPient Academy & SAP Labs, India
During his former avatar in 'business' he shaped a business unit from "Concept to Reality" for one of the largest Oil Companies in the world. He developed Supply Chain Strategy for another Oil Company. He is currently heading the SAP-BW practice at one of the largest software consulting firms from South-East Asia.
Bharat is highly experienced in managing data warehouse technology. He is an SAP-certified BW and ABAP consultant. Bharat is a regular faculty for SAP-BW and ABAP at the Sapient Academy and SAP Labs in India. Bharat has presented papers about BW at Business Intelligence India Group (BIIG) conferences. Bharat manages one of the largest BW systems for a fortune 500 company from India.
Technical Editor
Dr. Thomas Becker studied Computer Science at University of Kaiserslautern, Germany, from where he received his Ph.D. in 1995. From 1995 to 1998 he worked for SAS Institute as a Product Manager in the Business Intelligence area. In 1998 Dr. Becker joined infor business solutions as a development manager. Since 2001, he has been working for SAP AG, where he is responsible for NetWeaver Business Intelligence Performance.
Foreword Extract
The business environment is changing at a rapid pace and so is the fierceness in competition. Today’s business demands decision at the ‘speed of thought’. It is obvious that such decisions need most efficient information acquisition, integration, transformation and finally presentation in the most efficient way at a matching speed and without increasing the cost of doing so.
A data warehouse is set up in a company with a clear focus to support decision support system involving collecting useful information, harmonizing it and transforming and finally presenting it for answering business questions. For instance ‘What is the sales trend of a specific material?’
It is an established fact that most SAP-BW projects succeed when they deliver the above objectives by providing;
1. Acquiring data from various data sources like OLTP system and presenting accurate information.
2. A Capability to provide drill-down or ‘slice-n-dice’ capability for analyzing the different perspective of the information.
3. Decision support enablers like Self service options, Exception reporting etc.
...
In this book we have listed performance tuning parameters right through the data model, to extraction of data, to data loading, to fine tuning of the database while ending with proactive operational maintenance mode (e.g. review aggregates, build new ones, delete unused ones, find problem queries) as an ongoing cycle.
Also covered in the book is how to evaluate the actual performance whether there is a scope of improvement or other avenues of performance tuning have to be explored. However the book is not dealing with ‘extremely technical’ aspects of the performance tuning, as such content would cater to “purely technical” readers.
ISBN13: 978-0-9777251-4-4
ISBN: 0-9777251-4-6
FOREWORD .............................................................. 11
INTRODUCTION ........................................................ 13
CHAPTER 1 : IDENTIFY PERFORMANCE BOTTLENECKS .........17
1.1 BW - Statistics ........................................................ 18
1.2 Extraction ............................................................... 21
1.3 Loading .................................................................. 21
1.4 Modeling ................................................................ 23
1.5 Reporting ............................................................... 25
1.6 Workload Monitor (ST03N) .................................... 26
1.7 DB Statistics ........................................................... 28
1.8 Query Execution Plan ............................................ 28
1.9 Other Symptoms/Parameters ................................. 29
Chapter 2 : BW STATISTICS .................................. 31
2.1 BW Queries for Monitoring performance ................41
2.2 Administration of BW Statistics ................................ 47
2.3 List of Other BW Statistics Queries ......................... 49
3.1 SAP R/3 ............................................................... 58
3.2 Analysis of the SQL Statements ............................ 76
>3.3 Customer Enhancement ........................................ 84
3.4 Extraction from Flat files ......................................... 87
3.5 Extraction from External database using
DBConnect................................................................... 88
4.1 Timing .................................................................... 95
4.2 Load Sequence - Master Data ............................... 96
4.3 Load Sequence - Transaction Data ....................... 101
4.4 Loading into PSA .................................................. 103
4.5 Transfer Rules ...................................................... 105
4.6 Update Rules ........................................................ 108
4.7 Attribute Hierarchy Change Run ........................... 108
4.8 Specific Issues : ODS Related ........ ......................109
4.9 Parallel Loading into ODS ...................................... 111
4.10 Transfer Method .................................................. 113
4.11 Deletion & Creation of indexes ............................ 116
4.12 Roll-up request into aggregates .......................... 117
4.13 Database statistics ............................................... 118
Chapter 5 : MODELING ........................................... 121
5.1 InfoObject Design .................................................. 122
5.2 InfoCube Design ................................................... 131
5.3 ODS Object Design ............................................... 141
5.4 Maintenance of InfoCube ..................................... 150
5.5 Maintenance of ODS ............................................. 170
Chapter 6 : REPORTING ...........................................179
6.1. Query design ........................................................ 181
6.2. Read mode of the query ...................................... 189
6.3. Using query monitor (Transaction Code RSRT) ... 194
6.4. Global cache ........................................................ 201
6.5. Web application design ........................................ 209
6.6. Pre-calculation ..................................................... 211
6.7. Front end ............................................................. 213
Chapter 7 : USEFUL TRANSACTIONS ................... 215
Chapter 8 : OSS NOTES .......................................... 221
Chapter 9 : GLOSSARY ............................................229
Click the image to go to the book at Amazon.com
by: Alan Rickayzen, Jocelyn Dart, Carsten Brennecke, Markus Schneider
"SAP's WebFlow Engine is the SAP tool for managing business processes over the Internet as well as internally within and mySAP components..."
by Heinz-Dieter Knoll, Roland W. a. Kuhl, Lukas W. H. Kuhl
by Andrew N. Fletcher, Markus Brahm, Hergen Pargmann "This book is aimed at managers and those involved in business processes who are interested in the potential benefits available to them by applying SAP..."
REPORTING FOR SAP ASSET ACCOUNTING: (SAP Press) Based on SAP ECC 6.0, this in-depth technical guide uncovers the complete reporting solution for the Asset Accounting sub-module of SAP. You’ll learn about standard SAP-delivered asset reports, including balance-based reports and transaction-based reports. You'll also expand your knowledge of asset-specific reporting tools such as sort versions, simulation versions, and currency translations. Readers quickly get a keen understanding of how to effectively use all of the reporting options available within Asset Accounting.
"201 Interview Questions - SAP FICO" by A. Vishwanath (Genie Press)
A. Vishwanath has more than 11 years of FICO project experience spanning multiple industries and countries. He also leads an organization specializing in providing configuration, end user and presentation documentation for a range of SAP modules. These materials significantly enhance the implementation and configuration skills of newcomers and even more experienced consultants. He welcomes comments and feedback on this book and will be updating it, and the bonus material, to keep it in line with any future releases of FICO.
SAP NETWEAVER BI INTEGRATED PLANNING FOR FINANCE: (SAP Press) Readers learn how best to configure, develop, and manage a planning application, plus much more. The highly detailed examples help you develop a deeper understanding of the various features and allow you the opportunity to then reproduce them in your own environment, showing you firsthand how the BI Integrated Planning tool really works. Plus, readers also get expert guidance on the fundamentals of developing their own custom financial planning applications. This book goes beyond the basics to help you build world-class planning applications in support of your organization's most important business processes.
- ENHANCING SUPPLIER RELATIONSHIP MANAGEMENT USING SAP SRM:(SAP Press) Packed with exclusive tips and tricks, practical examples, and expert analysis on the changes in SAP® SRM 5.0 and 6.0, this book also helps you better understand integration issues and SAP SRM interactions with core SAP R/3® components such as MM, FI, and HR. You'll also get clarification on where and how SAP SRM fits into a corporate landscape and you'll learn the ins and outs of strategic purchasing, operational procurement, integration, implementation, and performance reporting with SAP NetWeaver® BI, plus much more.
"201 Interview Questions - SAP SRM" by Frank Tibackx (Genie Press)
Frank Tibackx is SAP Certified in SD and MM and has many years of business consulting, implementation and teaching experience in partner-facing SAP modules including SD, MM, SRM, SM and CRM. His all-round skills have helped many SAP customers over the years with the Positioning and Integration aspects of their SAP implementations with focus on the Extended Supply Chain.
Frank holds a Masters Degree in Business Economics and Information Systems Engineering and has already conducted a number of seminars on various SAP related topics. He spent most of his career working for former Big Five Management Consulting companies and as an independent SAP contractor in Europe and the USA. He currently lives in Southern California and is available for project-based work.
New Book launched by Genie Press
August 20th – 2007
201 Interview Questions
SAP® Workflow
By Rehan Zaidi
This is not only for employers.This book will allow consultants or analysts to better prepare for the dream job and set them apart from the crowd. Self confidence and knowledge are the two most common traits employers seek in potential candidates. This book allows you to refine both.
Whether you are an analyst seeking a permanent position or a consultant looking for your next project, this book allows you to impress the future employer with a clear understanding and self confidence expected from a subject matter expert.
Table of Contents
KEY QUESTIONS
CHAPTER 1: Workflow Basics and Customizing
CHAPTER 2: Working with the Workflow Builder
CHAPTER 3: Programming in Workflow
CHAPTER 4: Roles and Role Resolution
CHAPTER 5: Tools and Standard Programs Relevant to Workflow
CHAPTER 6: Debugging Workflows
About the Author
Rehan displays superior aptitude for the topic of SAP workflow and, having worked with him over the past year, I have come to see both his professionalism and talent first hand. Rehan is also the founder and webmaster of the web site ERPDomain.COM." Kevin Wilson, founder of ERPGenie.COM
Click here to see more detail or Buy Today!!!
© 2007 Genieholdings.com, Inc.
