NF10 DrillAssistant

From iDempiere en

Feature: Drill Assistant Enhancements

Goal: UX/Functional

Developer: cloudempiere, review by @hengsin

Feature Ticket: IDEMPIERE-5302


This enhancement allow define Drill Rules for admins, then users allow run new reports with predefined parameters by Drill Assistant from previously rendered report.

Example user open Storage Per Report Report, he identify a specific product which has Idle storage qty and want to analyse sales history. So click on column Product and start Drill Assistant.


- New window: Process Drill Rule

- Refactored: Capture parameters from Scheduler - generalised/extended functionality for Drill Rules Parameter generation

- Table has new field: isShowInDrillOptions - if set to N - default - then automatic DrillDown enabled/disabled (too many unusable drill was generated.)

- New Popup Window => Drill Assistant - Has 2 modes: A. Drill Rules (list all drill rules and their print format) B. Table - legacy mode. (must be enabled in App Dict with isShowInDrillOptions)


STEP 1 - Configure Drill Rule


Drill Rules configuration steps/explanation:

  1. Enter name Drill Rule and description - to be displayed, tip: can be specific eg. Last year order details.
  2. Actions Group => Process - meaning report to be start - with parameters defined on parameter tab.
  3. Actions Group => Show Help - 2 options A. silent mode - no parameters asking B. With opening parameter panel.
  4. Source Group => Table loaded from process report view read only
  5. Source Group => Select a Report view (you can make multiple report view for the same application table eg. group by bpartner should reduce rv_orderdetail to bpartner - > means result return report per bpartner)
  6. Print format if defined then only 1 drill rule print format explored - otherwise each print format created based on table or Report View will be rendered. (eg. 10 print formats)
  7. Select an existing Process parameter - this specify drill rule starting parameter - where user allowed select drill option and start drill assistant with print format column focus
  8. Run capture - in step 2. same as scheduler. Parameters not used can be deleted otherwise must be specified based on your requirement

STEP 2 - Drill Rule - run capture - to generate parameters


time saver, propose parameters to be defined.

STEP 3 - Drill Rule - capture - enter parameters


select any parameters, will be saved in Parameter Tab.


STEP 4 - Click to a selected column over Drill Rule will start


STEP 5 - Drill Assistant in Action

Drilling supported from report and windows

Step 5b Drill from Report

Drill Rule allow run report with without help option - running silent, with predefined parameter.

Drill Assistant has 2 modes: A. Rules B. Tables (legacy)

Drill Rule allow run report with help - means asking for parameters for further modification on-the-fly.


Drill from Window

Drill Rule allow also run report from window table, table direct and search references.

allow drilling from window

STEP 6 - Drill Assistant Run, and the new report rendered


Potential Improvements

  1. Run not only reports but also processes.
  2. Run Drill Assistant from regular window eg. Product field or Business Partner field.
  3. Implement favorites same in the menu, so user will able set print format as favorites - then filter by tab/dropdown
  4. Sorting drill rules by popularity not name (another ticket, implement statistics, how often the reports are started - then filter by tab/dropdown
  5. Parameter inheritance from actual to drilled report
Cookies help us deliver our services. By using our services, you agree to our use of cookies.