1. A method comprising: receiving, by a database server from a remote application server, a query associated with a calculation scenario that defines a data flow model that includes one or more calculation nodes and that includes at least one hierarchy filter, each hierarchy filter being a filter of at least one hierarchy table, each calculation node defining one or more operations to execute on the database server; instantiating, by the database server, the calculation scenario, the instantiating optimizing the calculation scenario, the instantiating comprising: transforming at least one hierarchy filter to an inlist filter, the inlist filter restricting values of a first join attribute to values of a second join attribute after executing one join partner; and pushing down the inlist filter to a lower calculation node; executing, by the database server, the operations defined by the calculation nodes of the optimized calculation scenario to result in a responsive data set; and providing, by the database server to the application server, the data set.