EP 1747517 A1 20070131 - METHOD AND APPARATUS FOR AUTOMATICALLY CREATING A DATA WAREHOUSE AND OLAP CUBE
Title (en)
METHOD AND APPARATUS FOR AUTOMATICALLY CREATING A DATA WAREHOUSE AND OLAP CUBE
Title (de)
VERFAHREN UND VORRICHTUNG ZUM AUTOMATISCHEN ERZEUGEN EINES DATEN-WAREHOUSE UND OLAP-WÜRFEL
Title (fr)
PROCEDE ET DISPOSITIF PERMETTANT DE CREER AUTOMATIQUEMENT UN ENTREPOT DE DONNEES ET UN CUBE OLAP (TRAITEMENT ANALYTIQUE EN LIGNE)
Publication
Application
Priority
- GB 2005001645 W 20050429
- GB 0409674 A 20040430
Abstract (en)
[origin: WO2005106711A1] A data warehouse design that combines data from multiple source ledgers or modules is constructed and from that an associated, single physical Star or Snow-Flake schema and OLAP hyper-cube analytic structure is generated to enable cross-functional analysis of any those multiple source ledgers or modules. The step of constructing the data warehouse or the step of generating the associated OLAP cube is achieved without significant human intervention using software. The present invention is based on the insight that the technical bias against generating individual data marts and OLAP cubes from multiple source ledgers is not well founded. Previously, the norm has been to generate a single physical OLAP cube for each individual ledger - hence one for the General Ledger, a further one for sales order processing etc. This prior art approach makes cross functional analysis multiple source ledgers and sub-ledgers difficult since it requires the creation of a further level of physical or virtual cubes across multiple physical cubes and complex querying. This is no longer necessary with the present invention.
IPC 8 full level
G06F 17/30 (2006.01)
CPC (source: EP)
G06F 16/972 (2018.12)
Citation (search report)
See references of WO 2005106711A1
Designated contracting state (EPC)
AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IS IT LI LT LU MC NL PL PT RO SE SI SK TR
DOCDB simple family (publication)
WO 2005106711 A1 20051110; EP 1747517 A1 20070131; GB 0409674 D0 20040602; GB 0508852 D0 20050608; GB 2413665 A 20051102
DOCDB simple family (application)
GB 2005001645 W 20050429; EP 05738895 A 20050429; GB 0409674 A 20040430; GB 0508852 A 20050429