1. A method comprising: executing, by one or more processors, a main query on data without any tuple filters; caching, by one or more processors, result data of the main query in a first data structure as intermediate data; generating, by one or more processors, one or more key figure data filters based on one or more conditions of the main query, at least one condition of the one or more conditions comprising a relative comparison between a key figure and a constant value; if the one or more conditions of the main query are on a hierarchical characteristic, post-filtering, by one or more processors, the intermediate data to generate a second data structure instance containing key figure data filter filtered data; and if the one or more conditions of the main query are not on a hierarchical characteristic: executing, by one or more processors, a prequery to generate a multidimensional tuple filter; and executing, by one or more processors, the main query using the multidimensional tuple filter to generate a third data structure instance containing key figure data filter filtered data, the third data structure instance being generated by subtracting the second data structure instance from the first data structure.