DSS Architecture

To provide scalable DSS and allow evolution linked to strategic and financial restructuring, it is necessary to develop a dual structure based on relational DatawareHousing and multidimensional Databases (Hypercubes) :

DSS Architecture

The roles of these two parts of a DSS are perfectly defined :

DataWarehouse based on Relational Databases:
  • Concentration and basic aggregation of all enterprise data
  • Data durability guarantee
  • Data format and name normalization
  • Codes transformation and normalization
  • Data synchronization and accessibility
  • Independence of DSS from operational systems
  • Implementation Tools : Relational Databases (Oracle, SQL Server, DB/2, ...)
  • ETL Tools : (Extract Transform and Load) Informatica, Sagent, ...
Multidimensional Databases based on OLAP Essbase Hypercubes :
  • Measures, ratios, aggregations and consolidations calculations
  • Request and multidimensional navigation services
  • Executive Information Systems (EIS) data feeding
  • Data access security
  • Implementation Tools : Hyperion Essbase, DB2 OLAP server
Front-End Application on PC :
  • Data presentation
  • Multidimensional navigation services
  • Executive Information Systems (EIS) presentation
  • Worldwide data access using WEB internet technology
  • Implementation Tools : Excel/ Essbase, Wired and various Essbase front-ends

Book your consulting resource on line now!