1. A computer-implemented method for processing at least one subset of data in a dataset, comprising: automatically determining whether a portion of aggregate data is to be re-categorized from detail data to aggregate data based on both a data usage context that indicates how the data is currently being used, processed or requested and the current scope of at lease one associated aggregation query; based on the determination, re-categorizing at least one subset of data in the dataset from an aggregate data designation to a detail data designation stored on a computer readable storage medium by explicitly reclassifying the subset's data designation from aggregate data to detail data, the detail data comprising base level database data, the aggregate data comprising a combination of one or more portions of detail data, the aggregate data designation being mutually exclusive to the detail data designation, the re-categorizing including automatically re-categorizing the at least one subset of data from the aggregate data designation to the detail data designation based on an analysis of the usage of the at least one subset of data in an operation performed on the dataset, the usage including a user's usage of the at least one subset of data, wherein the analysis analyzes the user's usage of the data subset to determine how the user used the data subset; performing an aggregation query across the detail data, the query being configured to return only detail data, wherein the aggregate data that would have otherwise been excluded from the results of the aggregation query is included in the result of the aggregation query because the aggregate data's classification was changed from aggregate to detail ; and applying one or more aggregate calculation functions on top of at least a portion of pre-aggregated data, such that the pre-aggregated data is treated in the same way as detail data in the aggregate calculation functions.