Drill Through - footer conditions in query

Previous Member
edited February 2018 in Idea Exchange

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
6 votes

Archived · Last Updated

Comments

  • Audrey Nobles
    Audrey Nobles Active Partner
    Fourth Anniversary Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board First Answer

    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?