+612 9045 4394
 
CHECKOUT
Business Intelligence: The IBM Solution : Datawarehousing and OLAP - Mark Whitehorn

Business Intelligence: The IBM Solution

Datawarehousing and OLAP

Book with Other Items

Published: 31st March 1999
Ships: 7 to 10 business days
7 to 10 business days
RRP $284.99
$196.90
31%
OFF
or 4 easy payments of $49.23 with Learn more

Business Intelligence is an umbrella term, broadly covering the processes involved in extracting valuable business information from the mass of data that exists within a typical enterprise. This book concentrates on two aspects of Business Intelligence, together with the associated IBM products: Data Warehousing - IBM's Visual Warehouse OLAP (On-Line Analytical Processing) - IBM' DB2 OLAP Server If you are a Manager needing an overview of data warehousing and OLAP or a Practitioner needing to understand and use these tools then this book will provide you with all the information you need to make the most of Business Intelligence.

Acknowledgementsp. vii
Contentsp. ix
Introductionp. 1
Who are you?p. 1
What this book doesp. 2
Our approachp. 3
Your previous experiencep. 4
So do you need this book?p. 5
Disclaimerp. 5
Backupp. 5
Yo IBM (or 'Nobody was ever fired for buying IBM')p. 6
Versioningp. 7
Who should you be?p. 7
Do you need Business Intelligence?p. 9
Do you need Business Intelligence?p. 9
What we think you havep. 9
Problems addressed by Business Intelligence softwarep. 10
So what is Business Intelligence?p. 11
Visual Warehousep. 11
DB2 OLAP Serverp. 12
Terminologyp. 13
The "proof of concept" (POC) conceptp. 13
What do you need?p. 14
Communicationsp. 16
Overviewp. 16
What next?p. 18
Installationp. 19
Where to install all the bitsp. 19
First stepsp. 19
Databases and connectivityp. 20
Metadatap. 21
Creating the control and target databasesp. 22
Andp. 26
Finallyp. 27
The installationp. 28
Checking that everything is Okp. 34
Recap/overviewp. 37
Creating a data warehousep. 38
Overview of what you are about to do nextp. 38
Which data source to use?p. 39
Building a test sourcep. 39
Defining the target database for the warehousep. 60
Business Viewsp. 61
Building a Business Viewp. 62
Running a Business Viewp. 74
Solving problem onep. 77
Summaryp. 78
What do you do next?p. 79
Making a connection to the data warehousep. 81
Making a connection to the data warehousep. 81
Business Viewsp. 84
Your starting pointp. 84
Business Viewsp. 84
Statusp. 85
Status summaryp. 88
Deleting your workp. 88
Scheduling - why schedule?p. 89
Time-based schedulingp. 90
Testing a schedulep. 93
Cascade schedulingp. 95
Recap of the Business View story so farp. 100
More about Business Viewsp. 101
Business Views are cleverp. 101
Business Views can act as sources for other Business Viewsp. 101
Tree Viewsp. 107
Editionsp. 109
Setting the number of editionsp. 110
Business Views for data transformationp. 117
Data transformationp. 117
Creating a Business View to transform datap. 118
Transformersp. 126
Summaryp. 127
Subjectsp. 127
Visual Warehouse programsp. 128
More summaryp. 129
The Work in Progress Windowp. 130
The Work in Progress Windowp. 130
Statusp. 130
Work in Progressp. 133
Logp. 137
Progressp. 141
Summaryp. 141
Data from disparate sourcesp. 142
Solving problem twop. 142
What are we going to use for demonstration purposes?p. 142
What do you need to know before we get started?p. 143
Recapp. 143
Fundamental information and recursionp. 143
The practical bitp. 145
Creating a source for the text filep. 145
Creating a Business View to pull data togetherp. 148
A totally different recapp. 152
Potential problemsp. 153
Securityp. 154
Securityp. 154
DataGuidep. 158
DataGuide a.k.a. Visual Warehouse Information Catalogp. 158
So what is DataGuide?p. 158
DataGuide componentsp. 159
Where do we go from here?p. 160
How do we move information about the contents of the data warehouse into DataGuide?p. 160
Metadatap. 161
Getting ready to export to DataGuidep. 161
Exportingp. 163
DataGuide Administratorp. 166
How do we add associated objects?p. 168
Creating an objectp. 170
Adding an object from outside the warehousep. 172
Looking for objectsp. 173
Helpp. 174
Further organizational controlsp. 175
A few other snippetsp. 176
Summaryp. 177
Overview of Visual Warehouse componentsp. 178
Visual Warehouse componentsp. 178
Visual Warehouse Managerp. 178
Visual Warehouse Agentp. 179
Visual Warehouse Administration Clientp. 179
Data Warehouse Administratorp. 180
OLAP concepts and terminologyp. 181
OLAP concepts and terminologyp. 181
What does OLAP mean?p. 181
Dimensions and membersp. 182
Developing a hierarchyp. 184
What about more dimensions?p. 184
A cubic perspectivep. 185
The database growsp. 185
Sparse and dense dimensionsp. 185
Data collectionp. 186
Why is this so important?p. 186
Summaryp. 189
Installing DB2 OLAP Serverp. 190
Setting the scenep. 190
Before starting to install DB2 OLAP Serverp. 191
Installationp. 192
Starting Essbase for the first timep. 194
Post-installation tweaksp. 196
Troubleshootingp. 199
Progressp. 201
Using the ready-built samplesp. 202
Where you arep. 202
Creating the samplesp. 202
Starting Essbasep. 202
Running sample.exep. 203
Starting the Application Managerp. 205
Outline Editorp. 211
Viewing datap. 213
Using Excelp. 214
Helpp. 219
Recapp. 219
Closing everything downp. 220
More about the Outline Editorp. 221
Where you arep. 221
More about the Outline Editorp. 221
Dimension typesp. 222
Hierarchy descriptionsp. 222
Consolidation objectsp. 224
Formula objectsp. 225
What's next?p. 227
Creating your first cubep. 228
Creating your first cubep. 228
Creating an applicationp. 228
Creating a databasep. 229
Creating an outlinep. 230
Adding consolidation objectsp. 232
Adding dimension typesp. 232
Saving an outlinep. 233
Adding datap. 234
Recapp. 236
Calculating datap. 238
Checking the data is presentp. 238
DB2 tablesp. 240
Sparse and dense dimensionsp. 241
Recapp. 242
Data load rulesp. 244
Rules filesp. 244
Editing the outlinep. 245
Building a rules filep. 246
Selecting recordsp. 252
Validating a rules filep. 254
Saving a rules filep. 256
Loading data with a rules filep. 256
Summaryp. 258
Solving problem threep. 259
Anchor dimensions and a few more concepts and pointersp. 260
Anchor dimensionsp. 260
A few more concepts and pointersp. 265
Dynamic calculationsp. 266
Partitioningp. 266
Calculating sizep. 267
Calc Script Editorp. 267
Reportsp. 268
Visual Warehouse and DB2 OLAP Server symbiosisp. 269
Bringing it all togetherp. 269
Last wordsp. 269
Overview of data warehousingp. 270
Data warehousesp. 270
Backgroundp. 270
Challengesp. 271
Solutionsp. 273
Summary so far, plus some additional informationp. 275
IBM's Business Intelligence solutionp. 278
Visual Warehouse and DB2 OLAP Serverp. 278
DataJoinerp. 278
ETI*Extractp. 279
Vality Integrityp. 279
Intelligent Miner for Datap. 279
Intelligent Miner for Textp. 279
Net.Datap. 279
DataPropagator Relational and DataPropagator NonRelationalp. 280
Data Refresherp. 280
Appendix 3p. 281
Overview of data warehouse componentsp. 283
Indexp. 285
Table of Contents provided by Syndetics. All Rights Reserved.

ISBN: 9781852330859
ISBN-10: 1852330856
Audience: Professional
Format: Book with Other Items
Language: English
Number Of Pages: 289
Published: 31st March 1999
Publisher: Springer London Ltd
Country of Publication: GB
Dimensions (cm): 23.29 x 17.02  x 1.78
Weight (kg): 0.52