I have a query where in the rows I have a 36 month structure. In the columns I have 5 keyfigures and these are populated by cell formulas.
My query works fine when in the selection screen values are selected. Selection variables are many like cocode, plant, profit center, sales Org, division, customer. After the query result comes, i am able to use the drill down for all characteristics except for customer.
If I start the drill down for customer, the query stalls for more than 30 minutes and sometimes closes with time out?
How to make the drill down by customers work? Any suggestion on aggregates or any other tweaking of query?
The query worked fine in the Development system where the number of customers are not much.
Any suggestions welcomed.