Patent ID: 9235633
Filing Date: 2016-01-12
CPC Classification: G06F

Claim Text:
1. A computer-implemented method, comprising: processing, by a processing device, data of a database environment, the data of the database environment comprising hierarchy information and a matrix of values, said hierarchy information comprising at least two sets of identification codes and defining at least two groups of identification codes, each identification code of any respective one of said groups belonging to a respective one of said sets of identification codes, said matrix of values comprising at least two columns of identification values, each identification value of each respective one of said columns of identification values belonging to a respective one of said sets of identification codes; generating a plurality of simple filter objects based on a respective user input, each simple filter object defining a first ad hoc group of identification codes selected from a respective one of said sets of identification codes and each said first ad hoc group is different from said groups defined by said hierarchy information; generating a first compound filter object based on a respective user input, the first compound filter object defining a second ad hoc group of identification codes created by combining at least two of the plurality of simple filter objects; generating a second compound filter object based on a respective user input, the second compound filter object defining a third ad hoc group of identification codes created by combining the first compound filter object and at least one of the plurality of simple filter objects, wherein at least a subset of the third ad hoc group of identification codes are selected based on exactly one of said sets of identification codes and at least a subset of the third ad hoc group of identification codes are selected based on at least two of said sets of identification codes; and generating, based on a user input, a filtered operation object that specifies an operation and the second compound filter object, wherein the filtered operation object when executed causes the operation to be carried out on rows of the matrix corresponding to the third ad hoc group of identification codes, thereby providing multi-dimensional ad hoc analysis of subsets of data in the matrix that are not specified by the hierarchy information.