Abstract: A selection of a dimension tree from multiple dimension trees may be received. In response to the selection of the selected dimension tree, additional dimension trees associated with the selected dimension tree may be provided. Components of a report may be allowed to be individually chosen from an additional dimension tree of the additional dimension trees by a placement of dimensions of the additional dimension tree on areas of the report.

Abstract: A selection of a dimension tree from multiple dimension trees may be received. In response to the selection of the selected dimension tree, additional dimension trees associated with the selected dimension tree may be provided. Components of a report may be allowed to be individually chosen from an additional dimension tree of the additional dimension trees by a placement of dimensions of the additional dimension tree on areas of the report.

Abstract: A method and apparatus for creating reports using dimension trees. The method may include presenting trees of dimensions associated with one or more source databases, receiving a user selection of one of the dimension trees, and presenting a view of the selected dimension tree. The method may further include allowing a user to choose components of a report from the view of the selected dimension tree, and populating the report with data from the source databases.

Abstract: A method and apparatus for managing forests of dimension trees. The method may include receiving user input identifying a dimension tree, and presenting the dimension tree to the user. The dimension tree includes a core dimension and a set of non-core dimensions. The method may further include receiving a user request to link a selected one of the non-core dimensions to non-core dimensions from other dimensions trees, displaying a list of available dimensions from existing dimension trees, and receiving a user selection of non-core dimensions from the list. Based on the user selection of non-core dimensions, a list of linked non-core dimensions from various dimension trees is created, and corresponding linkage information is stored in a database.

Abstract: A method and apparatus for real time datamining. In one embodiment, the method includes receiving a user request for datamining with respect to a value from a report associated with a specific pyramid level, identifying a datamining function to be performed for statistical analysis of lower level data pertaining to the value from the report, identifying dimensions to be used as variables for the statistical analysis, and determining criteria for selecting the lower level data associated with the value from the report. The method may further include submitting a request to one or more source databases, the request reflecting the identified dimensions and the determined criteria, performing the datamining function on a data set received from the source databases, and creating a datamining report based on a result of the performed datamining function.

Abstract: A method and apparatus for an ETL tool utilizing dimension trees. The method may include identifying various dimensions associated with one or more databases, and creating dimension trees based on these dimensions. The method may further include creating an ETL pyramid having multiple levels, linking the dimension trees to corresponding levels of the ETL pyramid, and creating a table for each level of the ETL pyramid to store a subset of the dimension trees that is linked to a corresponding level of the ETL pyramid.

Abstract: A method and apparatus for creating custom dimension trees. The method may include receiving a user request to create a custom dimension tree, displaying a list of available dimensions, and receiving user selection of available dimensions from the list. The method may further include allowing the user to create virtual dimensions, mapping elements of the available dimensions to the virtual dimensions, and creating the custom dimension tree using the mapping. The custom dimension tree represents relationships between the virtual dimensions.

Abstract: A method and apparatus for a dimensional pyramid reporting tool. In one embodiment, the method includes identifying dimensions associated with one or more databases, and receiving user input specifying the number of reporting levels. The method further includes receiving user input linking the dimensions with corresponding reporting levels, and creating a table for each of the reporting levels to store dimensions linked to a corresponding reporting level.

Abstract: A method and apparatus for managing forests of dimension trees. The method may include receiving user input identifying a dimension tree, and presenting the dimension tree to the user. The dimension tree includes a core dimension and a set of non-core dimensions. The method may further include receiving a user request to link a selected one of the non-core dimensions to non-core dimensions from other dimensions trees, displaying a list of available dimensions from existing dimension trees, and receiving a user selection of non-core dimensions from the list. Based on the user selection of non-core dimensions, a list of linked non-core dimensions from various dimension trees is created, and corresponding linkage information is stored in a database.

Abstract: A method and apparatus for creating reports using dimension trees The method may include presenting trees of dimensions associated with one or more source databases, receiving a user selection of one of the dimension trees, and presenting a view of the selected dimension tree. The method may further include allowing a user to choose components of a report from the view of the selected dimension tree, and populating the report with data from the source databases.

Abstract: A method and apparatus for creating custom dimension trees. The method may include receiving a user request to create a custom dimension tree, displaying a list of available dimensions, and receiving user selection of available dimensions from the list. The method may further include allowing the user to create virtual dimensions, mapping elements of the available dimensions to the virtual dimensions, and creating the custom dimension tree using the mapping. The custom dimension tree represents relationships between the virtual dimensions.

Abstract: A method and apparatus for real time datamining. In one embodiment, the method includes receiving a user request for datamining with respect to a value from a report associated with a specific pyramid level, identifying a datamining function to be performed for statistical analysis of lower level data pertaining to the value from the report, identifying dimensions to be used as variables for the statistical analysis, and determining criteria for selecting the lower level data associated with the value from the report. The method may further include submitting a request to one or more source databases, the request reflecting the identified dimensions and the determined criteria, performing the datamining function on a data set received from the source databases, and creating a datamining report based on a result of the performed datamining function.

Abstract: A method and apparatus for an ETL tool utilizing dimension trees. The method may include identifying various dimensions associated with one or more databases, and creating dimension trees based on these dimensions. The method may further include creating an ETL pyramid having multiple levels, linking the dimension trees to corresponding levels of the ETL pyramid, and creating a table for each level of the ETL pyramid to store a subset of the dimension trees that is linked to a corresponding level of the ETL pyramid.

Abstract: A method and apparatus for a dimensional pyramid reporting tool. In one embodiment, the method includes identifying dimensions associated with one or more databases, and receiving user input specifying the number of reporting levels. The method further includes receiving user input linking the dimensions with corresponding reporting levels, and creating a table for each of the reporting levels to store dimensions linked to a corresponding reporting level.