D20BW: Business Information Warehouse (BW)-Delta with Release 2.0, 380
data, 241
quality, 195
refresh, 15
replication services, 93
replication tools, 93
scrubbing, 19
transfer methods in SAP BW, 200-202
data access
BW (Business Information Warehouse), 49-50
interfaces, 310-311
database
activating and adjusting, 283
objects managing data flow and storage, 51-54
size, 344-346
database-centric data warehouses, 37-39
Database Utility command, 283
Data Cleansing service, 10
Data Consolidation service, 10
data conversions, 11
data dictionary, 142
Data Dictionary service, 12
data distribution, 16
Data Distribution service, 10
data extraction, 18, 328-329
techniques, 41
Data Extraction service, 10
data extractors, 45, 97, 384-385
calling, 169
debugging, 287-288
data files
application server, 226
client workstation, 224-226
field values, 229
header lines, 223
location, 224-225
data flow between SAP R/3, 166
data load, 203-210
ALE IDOCs mechanism, 206
background, 226
breaking into smaller jobs, 208
data providers, 216-217
defining scheme, 205
delta, 209-210
exceeding time limit, 211
fatal errors, 211
flat files, 216, 217-229
initial, 208-209
in-limbo state, 211
master data attributes, 224-226
method, 205
monitoring, 210-213, 227
monitoring utility, 210-213
non-SAP R/3 data source, 216-217
optimizing, 330
periodic, 205
platform-independent technologies, 217
pre- and post-load activities, 204-205
in progress, 211
reducing time for, 19
resolving problems, 212, 227
Staging Business API (BAPI), 216-217
successful, 211
text and hierarchy data, 226-227
tRFC with ODS transfer method, 207-208
data loader, building with staging BAPIs, 294-296
data loads, 203-210
pre-and post-load activities, 204-205
Data Management layer, 27-28
Data Manager, 51-54
data marts, 7
data modeling, 258-259
data modeling team, 261
data objects
classes, 199
loading data, 203-210
managing, 11-12
managing and distributing, 10
Data Partitioning service, 10
Data Profiling, 10
Data Provider layer, 10
data providers, 216-217
data puddles, 6
data sets statistical update, 192
DataSource, 48
Data Source object, 157
data sources, 216
definitions, 298-299
extracting data, 295-296
gateway, 10
naming, 135
sending extracted data to SAP BW, 295-296
Data Staging service, 10
Data Storage service, 10
Data Transformation service, 10
Data Transport service, 10
(The) Data Warehouse Lifecycle Toolkit, 95, 99
Data Warehouse Management layer, 11-12
data warehouses, 6
24-7 mode, 12
adaptation of new technologies, 14
ALE-centric, 39-40
architecture, 8
availability, 15
baseline data, 192
bottom-up approach, 87
bulk-load utilities, 217
business intelligence, 6, 260
categories, 6-8
components, 9-12
Conceptual model, 259
construction steps, 4
consulting services Web sites, 373-374
continual improvements, 15
database-centric, 37-39
data distribution, 16
data extraction techniques, 41
data growth pattern, 333
data marts, 7
Data Provider layer, 10
Data Warehouse Management layer, 11-12
Deployment model, 260
dimensions, 17
enterprise business intelligence needs, 260
extraprise, 5, 8
flat files, 216
Global catalog, 13
Global Information Delivery services, 13
high-performance, 17
hybrid approach, 87-88
implementation methodologies, 86
industry, 65
industry analysts and consulting services providers, 63
Information Consumer layer, 11
integrated enterprise, 133
loading large data volumes, 19
Logical data model, 260
magazines and literature Web sites, 372-373
manageability, 13-14
managing content, 130
metadata management, 13
modeling, 258-262
modeling in SAP BW, 261-262
network bandwidth, 16, 329
number of users, 17
ODS (operational data store), 7
performance metrics, 16-20
Physical data model, 260
poor performance, 16-17
product vendor Web sites, 374
purpose, 99
reliability, 15
SAP approach, 87-88
SAP R/3-centric environments, 37-42
scalability, 16
security, 14-15
Service Provider layer, 10
technical issues in constructing, 12-16
third-party-tool-centric, 41-42
top-down approach, 87
traditional, 5
upgradability, 15
usage patterns, 333
(The) Data Warehouse Toolkit, 263
data warehousing
books, 370-372
data quality, 195
definition of, 4
evolution, 22
tight integration with OLTP, 22
time, 149-150
DB2, 53
DEBUG_FLAG, 288
debugging data extractors, 287-288
defining
active client, 117-118
dimensions, 264-265
facts, 265
Delta Change table, 210
delta data loads, 209-210
DELTA logs, 192
DEMO.IS_application file, 322
dependent data marts, 7, 16
dependent InfoObjects, 178
Deployment model, 260
Development Management service, 12
dimensions, 180, 314
assigning characteristics, 270-271
attributes, 264-265
defining, 264-265
InfoCubes, 264
normalizing, 264
slicing and dicing, 265
star schema model, 264
time independent, 264
user-definable, 264
dimension tables, 51, 52
keys, 263
size, 265
disk I/O subsystem, 347
disk storage requirement, 345-346
Display InfoCube Data Model command, 181
Dresner, Howard, 6
drill-down analysis, 236, 265
drill down data, 241
D-versioned objects, 173
DynaSite, 67
Team-Fly |