Drill Through - footer conditions in query

Idea created by pyurpaul on Feb 21, 2018
    Open for voting
    Score10

    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.