HIERARCHICAL DIMENSION ANALYSIS IN MULTI-DIMENSIONAL PIVOT GRIDS

摘要

A system and method facilitating transforming or updating displayed data using data hierarchy information. An example method includes storing hierarchy information characterizing a dataset via one or more tree tables; selectively accessing a database to update data characterized by metadata of the one or more tree tables; employing one or more pivot grids to replicate one or more hierarchical properties of the one or more tree tables; and displaying information based on the one or more pivot grids. The displaying step may further include using the pivot grid(s) to generate and display analytic(s), wherein data for the pivot grid(s) and analytics(s) is obtained from flattened tree tables. Dynamically executed Structured Query Language (SQL) construct(s) may retrieve un-cached fresh multi-dimensional data used for the pivot grid(s) or analytic(s) in a manner consistent with hierarchy information retrieved (via SQL) from the tree tables as tree metadata.

主权项

1. A method for facilitating transforming or updating displayed data in an enterprise computing environment, the enterprise computing environment including one or more client devices in communication with a server system, wherein the server system executes webpage software, wherein the webpage software provides webpage information accessible to one or more client devices, the server system executing steps of the method, the method comprising:
storing hierarchy information characterizing a dataset via one or more tree tables; selectively accessing a database to update data characterized by metadata of the one or more tree tables; using one or more pivot grids to replicate one or more hierarchical properties of the one or more tree tables; and providing information based on the one or more pivot grids, the information adapted to be displayed via one or more client devices.