Patent ID: 9081849
Filing Date: 2015-07-14
Classification: G06F

Abstract:
1. A system for processing a multidimensional (MD) data set produced from an execution of multidimensional query on a MD data source, the MD data set comprising data for a report described by a report specification based on an entity/relationship (ER) schema, the system comprising: a result set description generation module producing a result set description matching the semantics of the report specification based on the-ER schema from a MD data set description describing the semantics of the MD data set using result processing information; a tabular row generation module converting the MD data set into a collection of rows of data to generate a result set of the report output as a tabular result set when the ER report specification conforms to a tabular report, wherein the tabular row generation module generates each row of data by producing a respective full stack of members from the MD data set, wherein each full stack of members represents a row of data available for inclusion in the tabular result set, and wherein producing the full stack of members comprises: pushing a highest-level member of a dimension onto a stack, traversing parent/child relationships within a dimension along an edge to push each member at each level onto the stack, popping a top member off the stack, and pushing all siblings of the top member onto the stack; a cross-tabulated result generation module converting the MD data set into a cross tabulated result set when the report specification conforms to a cross-tabulated report a translation module converting the report specification based on the ER schema into the MD query; and an execution module for executing the MD query.