Data warehouse system

Patent metadata

Field	Value
Publication number	US-9740992-B2
Application number	US-55922209-A
Country	US
Kind code	B2
Filing date	Sep 14, 2009
Priority date	Jan 19, 2001
Publication date	Aug 22, 2017
Grant date	Aug 22, 2017

Abstract

A data warehouse system for managing performance of organizations is provided. The data warehouse system comprises a data model for storing data representing dimensions and measures applicable for multiple organizations, and a configuration unit for setting the placeholders such that the data model represents the particular organization. The data model has placeholders settable such that the data model represents a particular organization.

First claim

The invention claimed is:

1. A data warehouse system for managing performance of organizations, the data warehouse system comprising:
a database;
a business model comprising:
a set of common dimensions representing business reference aspects related to a plurality of organizations; and
a set of measures representing measurements of business activity aspects applicable to the plurality of organizations, wherein the set of measures is grouped into areas of analysis related to the plurality of organizations; and

a data model corresponding to the business model, the data model including fact tables and dimension tables, wherein the dimension tables correspond to the set of common dimensions, and wherein the fact tables include the set of measures; and
a hardware-based processor configured to execute a configuration unit to configure the data model to represent a particular organization and to configure the database according to the configured data model, wherein to configure the data model, the hardware-based processor is configured to:
determine a subset of dimensions from the set of common dimensions that are related to the particular organization;
extract the subset of dimensions from the common dimensions such that only dimensions of the set of common dimensions that are related to the particular organization are included in the data model for the particular organization;
determine a subset of measures of the set of measures that are related to the particular organization; and
extract the subset of measures from the set of measures such that only measures of the set of measures that are related to the particular organization are included in the data model for the particular organization, and

wherein the hardware-based processor is further configured to configure the database to conform to the configured data model such that the database includes the dimensions that are related to the particular organization and the measures that are related to the particular organization.

2. The data warehouse system of claim 1 , wherein a dimension of the set of common dimensions includes a placeholder settable to reflect at least one of:
a fiscal pattern of the particular organization;
a common currency used by the data warehouse data model;
one or more categories defined by a user, the categories usable to analyze information in the data warehouse data model; and
one or more multipliers usable by the data warehouse data model.

3. The data warehouse system of claim 1 , wherein the configuration unit comprises at least one of:
a fiscal pattern settor configured to set a placeholder in the data model to reflect a fiscal pattern of the particular organization;
a currency settor configured to set a placeholder in the data model to reflect a common currency used by the data model;
a user category settor configured to set a placeholder in the data model to reflect a category defined by a user, the category used to analyze information in the data model; and
a multiplier settor configured to aggregate amounts loaded into the data model.

4. The data warehouse system of claim 1 , further comprising a connector module configured to extract data from at least one of a plurality of data source systems and load the data into the data model, the connector module having configurable parameters for extracting data from a particular one of a plurality of data source systems.

5. The data warehouse system according to claim 4 , wherein the particular one of the plurality of data source systems comprises an enterprise resource planning (ERP) system.

6. The data warehouse system of claim 1 , further comprising an operational framework for managing the data warehouse system, the operational framework comprising a console for providing user configuration options for configuring the data warehouse system, wherein the configuration unit is provided in the operational framework.

7. The data warehouse system according to claim 1 , further comprising a content explorer for generating reports based on the analysis performed by the data warehouse data model.

8. The data warehouse system according to claim 1 , wherein the fact tables are grouped into functional areas.

9. The data warehouse system according to claim 1 , wherein the dimension tables are connected to the fact tables in a star schema.

10. The data warehouse system according to claim 1 , wherein the functional areas are selected from a group consisting of: sales analysis, AR analysis, GL analysis, AP analysis, inventory analysis, and procurement analysis.

11. The data warehouse system according to claim 1 , wherein the business model is extendible by including additional areas of analysis.

12. The data warehouse system according to claim 1 , wherein the set of measures represents a union of measures used to perform analysis for the plurality of organizations.

13. The data warehouse system according to claim 12 , wherein the union of measures comprises a minimum set of measures needed to perform analysis for all of the plurality of organizations.

14. The data warehouse system according to claim 1 , wherein the areas of analysis comprise Key Performance Indicator (KPI) or attributes.

15. The data warehouse system according to claim 1 , wherein the areas of analysis are grouped into a plurality of functional areas.

16. The data warehouse system according to claim 15 , wherein the areas of analysis are configured to jointly use a dimension of the predefined set of shared common dimensions.

17. A method comprising:
generating, by a processor, a business model comprising:
a set of common dimensions representing business reference aspects related to a plurality of organizations; and
a set of measures representing measurements of business activity aspects applicable to the plurality of organizations, wherein the set of measures is grouped into areas of analysis related to the plurality of organizations;

generating, by the processor, a data model corresponding to the business model, the data model including fact tables and dimension tables, wherein the dimension tables correspond the set of common dimensions, and wherein the fact tables include the set of measures; and
configuring, by the processor, the data model to represent a particular organization by configuring at least one of:
a fiscal pattern settor to set a placeholder in the data model to reflect a fiscal pattern of the particular organization;
a currency settor to set a placeholder in the data model to reflect a common currency used by the data model;
a user category settor to set a placeholder in the data model to reflect a category defined by a user, the category used to analyze information in the data model; and
a multiplier settor to aggregate amounts loaded into the data model, wherein configuring the data model comprises:
determining a subset of dimensions from the set of common dimensions that are related to the particular organization;
extracting the subset of dimensions from the common dimensions such that only dimensions of the set of common dimensions that are related to the particular organization are included in the data model for the particular organization;
determining a subset of measures of the set of measures that are related to the particular organization; and
extracting the subset of measures from the set of measures such that only measures of the set of measures that are related to the particular organization are included in the data model for the particular organization;

the method further comprising configuring a database to conform to the confi

Assignees

• Fazal Thomas
• Strutt David
• Gibb Robert
• Armstrong Michael
• Adendorff Michael
• Helal Robert
• IBM

Inventors

• Fazal Thomas
• Strutt David
• Gibb Robert
• Armstrong Michael
• Adendorff Michael
• Helal Robert

Classifications

• G06F16/254

  Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses · CPC title

• G06Q10/06 Primary

  Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling · CPC title

• G06Q10/063

  Operations research, analysis or management · CPC title

• G06Q10/103

  Workflow collaboration or project management · CPC title

• G06Q10/067

  Enterprise or organisation modelling · CPC title