Drill Through - footer conditions in query
For now its possible to define 'Where' conditions only.
It would be helpful to define footer conditions too. Examples:
GROUP BY
ORDER BY
LIMIT
FETCH FIRST X rows only
...
Applicationexample:
Our users can do a drill through on P&L Lines and can get all booking details --> its a large table in datawarehouse.
In some cases the server is getting down, because of heavy requisitions. To prevent this, i want to add a LIMIT in the drill through settings in board, so I do not have to change anything in the datawarehouse tables / views.
6
Comments
-
I would also find this extremely helpful, running into issues applying order by in a drillthrough. Was this ever implemented / is there any known workaround?
0