Contents
History of Changes..........3
1 Introduction.......... 7
1.1 Purpose....................7
1.2 About This Document...............7
1.2.1 Scope..................7
1.2.2 Constraints............... 7
2 Understanding BI and ETL.............8
2.1 What is ETL...................8
2.2 Components of POB BI.............8
2.2.1 External Data..................8
2.2.2 Warehouse Data Objects.................8
2.2.3 Process Chains.................9
2.3 Default Configuration................9
2.3.1 Changing the Default Dataset...........9
3 Creating and Staging External Data.......10
3.1 Data Input Types..................10
3.1.1 Master Data.................10
3.1.2 Data Stores...................10
3.2 Data Input Definitions.................10
3.2.1 Product Attributes Files.................10
3.2.2 Product ID, Market Group Files...............11
3.2.3 Transaction & Rate Files ..................................11
3.2.4 CMP (Competitor) Product Attributes Files..........11
3.2.5 CMP Product Files......................12
3.2.6 CMP Rate History File.................12
4 Loading Data to BI.................13
4.1 Input File set..................13
4.2 Loading the File set........................14
4.2.1 Executing Customer Product Loads......................15
4.2.2 Executing Customer Transaction & Rate Loads............15
4.2.3 Executing CMP Product Loads......................16
4.2.4 Executing CMP Rate Loads......................17
5 Attribute Hierarchies..................18
5.1 Hierarchy types...........................18
5.2 Hierarchy Input Data................18
5.3 Mapping Hierarchies.........................19
5.3.1 Product Attributes Hierarchy..................19
5.3.2 Market Group Attribute Hierarchy......................20
6 Reporting.................21
6.1 Updating Report Data................21
6.2 Executing Reports................21
Appendix A – Using Variants............24
Appendix B – Data Input Samples..................27
Download attached file: You must be Loged in to download file