Index_D

Team-Fly

---

D

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