Patent ID: 8832601

Claim:
A computer-implemented method comprising: identifying, by a computer system, a plurality of dimensions associated with one or more databases; creating a plurality of dimension trees based on the plurality of dimensions; creating an ETL (Extract, Transform and Load) pyramid having a number of levels; providing a user interface facilitating user input specifying dimensions and dimension trees for individual levels within the number of levels of the ETL pyramid; linking the plurality of dimensions and the plurality of dimension trees to the number of levels of the ETL pyramid based on the user input, wherein the levels of the ETL pyramid include components comprising one or more of the plurality of dimension trees, one or more dimensions from the plurality of dimension trees and one or more dimensions that are not part of any of the plurality of dimension trees; and creating a table for each level of the ETL pyramid to store a subset of the plurality of dimension trees that is linked to a corresponding level of the ETL pyramid.