1. A method for querying a distributed dwarf cube, the method comprising: receiving a query for retrieving data from a distributed dwarf cube, wherein the distributed dwarf cube is built of the data, wherein the data comprises cube values, wherein the distributed dwarf cube is built by: processing the data to generate indexes for the data; sorting the cube values in one or more dimensions based on a cardinality of the cube values, wherein the cube values are sorted in an order of highest cardinality to lowest cardinality, wherein the cardinality indicates distinctiveness of the cube values in the one or more dimensions; partitioning the data into data blocks to build distributed dwarf cube from each data block based upon the cardinality of the cube values, wherein the distributed dwarf cube comprise one or more ranges defined for the cube values; checking the one or more ranges of the cube values based upon the query, wherein the one or more ranges comprise complete cube values and non-complete cube values, wherein the non-complete cube values indicate the cube values present at a start or an end of a range of the one or more ranges; creating a list of the cube values comprising the complete cube values and/or the non-complete cube values; and transmitting the list of the cube values from the distributed dwarf cube corresponding to the query.