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; 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.