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.
To see the full detail click here
No comments:
Post a Comment