Data Warehousing Architecture

· Global DW: Global Data Warehouse

· North America DW : North American Data Warehouse

· Packages : Cognos Package used for reporting.

· Cognos 10: Cognos Enterprise Server supporting Cube analysis

· PDW : Proposed Data Warehouse.

· Qlikview desktop: Qlikview desktop version installed on user computers

· Qlikview : in memory OLAP tool

· SQL Server: Server with SQL server installed

· Access: Server with MS Access installed.

· Source System 1 and 2: OLTP systems

· Power User: Internal Key user who facilitates end user reporting

· End User : Internal Users using reports and cubes.

· Pricing server : pricing information feed into data warehouse.

· Logistic server: logistic business data feed into data warehouse

· SAP server: ERP system data feed into data warehouse.

· Mainframe server: legacy application data feed into Data warehouse