System, method and program product for classifying data elements into different levels of a business hierarchy

A computer system for classifying data elements, said computer system comprising:

• first program instructions to select a first logic decision tree for evaluating a plurality of data elements identified for classification of said plurality of data elements into one or more levels of a business hierarchy, said first program instructions including instructions to identify said plurality of data elements stored in a data warehouse system to be classified into one or more levels of said business hierarchy and to load said plurality of data elements into a fact table in said data warehouse system, wherein said first program instructions include instructions to provide a business rules database comprising one or more logic decision trees corresponding to said one or more levels of said business hierarchy for classification of said plurality of data elements into said one or more levels of said business hierarchy, wherein each logic decision tree of said one or more logic decision trees comprises a binary decision tree;
• second program instructions to execute said first logic decision tree selected from one or more logic decision trees for recursively evaluating each data element of said plurality of data elements identified until said first logic decision tree has been traversed;
• third program instructions to dynamically create configurable anchor point classifications for said plurality of data elements evaluated through said first logic decision tree;
• and
• fourth program instructions to assign a respective anchor point classification to a respective data element evaluated, wherein said respective anchor point classification assigned to said respective data element evaluated links said respective data element to a lowest level of said one or more levels of said business hierarchy, and wherein said respective anchor point classification assigned to said respective data element of said plurality of data elements conveys classification information as to each higher level of said one or more levels of said business hierarchy that said respective data element belongs to, for facilitating hierarchical summarizing and reporting of said plurality of data elements across said business hierarchy;
• a computer readable storage medium, said computer readable storage medium storing each of said first, second, third and fourth program instructions;
• and
• a central processing unit for executing each of said first, second, third and fourth program instructions.

A computer program product for classifying data elements, said computer program product comprising:

• a computer readable storage medium;
• first program instructions to select a first logic decision tree for evaluating a plurality of data elements identified for classification of said plurality of data elements into one or more levels of a business hierarchy, said first program instructions including instructions to identify said plurality of data elements stored in a data warehouse system to be classified into one or more levels of said business hierarchy and to load said plurality of data elements into a fact table in said data warehouse system, wherein said first program instructions include instructions to provide a business rules database comprising one or more logic decision trees corresponding to said one or more levels of said business hierarchy for classification of said plurality of data elements into said one or more levels of said business hierarchy, wherein each logic decision tree of said one or more logic decision trees comprises a binary decision tree;
• second program instructions to execute the first logic decision tree selected from one or more logic decision trees for recursively evaluating each data element of said plurality of data elements identified until said first logic decision tree has been traversed;
• third program instructions to dynamically create configurable anchor point classifications for said plurality of data elements evaluated through said first logic decision tree;
• and
• fourth program instructions to assign a respective anchor point classification to a respective data element evaluated, wherein said respective anchor point classification assigned to said respective data element evaluated links said respective data element to a lowest level of said one or more levels of said business hierarchy, and wherein said respective anchor point classification assigned to said respective data element of said plurality of data elements conveys classification information as to each higher level of said one or more levels of said business hierarchy that said respective data element belongs to, for facilitating hierarchical summarizing and reporting of said plurality of data elements across said business hierarchy, and wherein each of said first, second, third and fourth program instructions are recorded on said computer readable storage medium.

A process for deploying computing infrastructure comprising integrating computer-readable code into a computing system, wherein said code in combination with said computing system is capable of performing a process for classifying data elements, said process comprising:

• identifying a plurality of data elements stored in a data warehouse system to be classified into one or more levels of a business hierarchy and loading said plurality of data elements into a fact table in said data warehouse system;
• selecting a first logic decision tree of one or more logic decision trees for evaluating said plurality of data elements identified for classification of said plurality of data elements into said one or more levels of said business hierarchy, wherein said selecting step further comprises providing a business rules database comprising said one or more logic is decision trees corresponding to said one or more levels of said business hierarchy for classification of said plurality of data elements into said one or more levels of said business hierarchy, wherein each logic decision tree of said one or more logic decision trees comprises a binary decision tree;
• executing said first logic decision tree for recursively evaluating each data element of said plurality of data elements identified until said first logic decision tree has been traversed;
• dynamically creating configurable anchor point classifications for said plurality of data elements evaluated through said first logic decision tree;
• assigning a respective anchor point classification to a respective data element evaluated, wherein said respective anchor point classification assigned to said respective data element evaluated links said respective data element to a lowest level of said one or more levels of said business hierarchy, and wherein said respective anchor point classification assigned to said respective data element of said plurality of data elements conveys classification information as to each higher level of said one or more levels of said business hierarchy that said respective data element belongs to, for facilitating hierarchical summarizing and reporting of said plurality of data elements across said business hierarchy;
• and
• generating a report utilizing said respective anchor point classifications assigned to said plurality of data elements, wherein said report summarizes said plurality of data elements from a lower level up to a higher level of said one or more levels of said business hierarchy.