【正文】
otal credit postingsTotal debit postingsSales volume in periodDimensionsCustomerSectorCustomer numberCountryCompany codeCurrency typeTimeUnitRowsCust...ColumnsStructureAccumulated b.Accumul.CustomersCustomersOLTP Vs. OLAP特性Primary OperationLevel of AnalysisAmount of data per transactionType of dataTimeliness of dataUpdates to dataDatabase designNumber of transactions/usersResponse timeDatabase dataNumber of tables per transactionType of processingOLTPUpdateLowVery smallDetailedMust be current FrequentlyComplexMany (100s to 1000s)QuickNormalizedSeveralWell definedOLAPAnalyzeHighVery largeSummaryCurrent and historicalLess frequent, new data onlySimpleFewReasonableDenormalizedFewAd hocl 描述 BW的主要結(jié)構(gòu)和組件l 描述 BW的星型結(jié)構(gòu) l 能夠描述數(shù)據(jù)如何從源系統(tǒng)進(jìn)入 BW系統(tǒng)l 了解業(yè)務(wù)內(nèi)容的目的 l 創(chuàng)建最基本的查詢你現(xiàn)在能夠 :BW 概述 : 總結(jié)演講完畢,謝謝觀看!