Patent ID: 9268831
Filing Date: 2016-02-23
CPC Classification: G06F

Claim Text:
1. A system for receiving extracted data from a source database without a need for a data warehouse for subsequent analysis comprising: (a) an application server comprising at least one physical processor, the application server configured to: (b) a set of measures for interrogating the data tables, each measure of the set of measures having associated therewith one or more dimensions for filtering the transformed data, wherein each of the one or more dimensions can be referenced by each of the plurality of data tables using a node key associated with each of the one or more dimensions, and wherein a given data table can be filtered by joining the single hierarchy table to the given data table using the existing attribute associated with the node key and filtering the hierarchy table by a portion of the node key; and (c) a user controllable interface configured to receive a user selection of one or more dimensions to be used to filter a measure from the set of measures and provide an output representative of the filtered measure; wherein the notation for a child node comprises an identifier of a parent node and an identifier of the child node, wherein the identifier of the parent node and the identifier of the child node are separated by at least one separating character that is not an operator.