Patent ID: 8380748

Claim:
One or more computer-storage device having computer-executable instructions embodied thereon that, when executed, perform a method for building a multidimensional data cube having one or more high-cardinality attributes, the method comprising: extracting data from one or more databases; determining that one or more instances of the data are fact data, wherein each member of the fact data is one instance of a dimension; determining that one or more instances of the data are dimension data, wherein each instance of the dimension data includes an attribute for grouping the fact data; determining that one or more instances of the dimension data are high-cardinality attributes wherein cardinality is a measure of the number of unique values contained in an attribute; processing all of the one or more high-cardinality attributes as the fact data to create one or more high-cardinality attribute tables; storing the one or more high-cardinality attribute tables in one or more fact tables on a computer storage medium; building the multidimensional data cube without the one or more high-cardinality attributes; and presenting an information associated with the one or more high-cardinality attributes to a user when the user queries the multidimensional data cube beyond a predetermined threshold granularity.