|
|
Publish
Date
December, 2007
Pages: 248
Sample Extract
To see a
sample extract from Chapter one
<Click Here> - 10 Pages
|
Cover
Click Thumbnail to enlarge (See
Front and Back)
|
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
Table
of Contents
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
Chapter
3 : EXTRACTION ....................................... 57
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
Chapter
4 : LOADING ................................................93
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 |
