{"id":33791,"date":"2026-05-01T06:29:26","date_gmt":"2026-05-01T06:29:26","guid":{"rendered":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/?p=33791"},"modified":"2026-05-01T11:19:35","modified_gmt":"2026-05-01T11:19:35","slug":"mastering-drill-down-reports-oracle-hcm","status":"publish","type":"post","link":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/blog\/mastering-drill-down-reports-oracle-hcm\/","title":{"rendered":"Mastering Drill-Down Reports in Oracle HCM"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong>Overview<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Enterprise HR analytics rarely stop at summary numbers. Decision makers often start with a high-level metric &#8211; such as employee counts by Business Unit or Department, and then need to investigate the underlying employee data driving those numbers. Without drill-down capability, this investigation requires switching reports, applying filters manually, and repeating the same analysis steps.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle HCM reporting tools allow this navigation to be automated. By configuring drill-down interactions, a summary report can dynamically open a detailed report already filtered for the selected dimension.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This article demonstrates how to implement drill-down reporting using two commonly used Oracle HCM reporting tools:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>OTBI (Oracle Transactional Business Intelligence)<\/li>\n\n\n\n<li>BI Publisher<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The examples below illustrate a practical reporting scenario where users navigate from summary workforce metrics to employee-level data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><u>Part 1 &#8211; OTBI Drill-Down Implementation<\/u><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Reporting Scenario<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The objective is to enable navigation from a Business Unit workforce summary report to an employee detail report filtered automatically for the selected Business Unit.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Workflow:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Business Unit Summary&nbsp; \u2192&nbsp; Click Business Unit&nbsp; \u2192&nbsp; Employee Detail Report<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Prerequisites<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Before configuring drill-down interaction, two OTBI reports must already exist.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Parent Report &#8211; Business Unit Workforce Summary<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The parent analysis should contain:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Business Unit Name<\/li>\n\n\n\n<li>Distinct count of Person Number<\/li>\n\n\n\n<li>Filter for Active Employees<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Output example:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Business Unit<\/strong><\/td><td><strong>Active Employees<\/strong><\/td><\/tr><tr><td><strong>Finance BU<\/strong><\/td><td>42<\/td><\/tr><tr><td><strong>Operations BU<\/strong><\/td><td>67<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">No interaction or drill-down configuration should be applied at this stage.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Child Report &#8211; <u>Employee Detail Report<\/u><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The child analysis provides the detailed workforce data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Typical columns include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Business Unit<\/li>\n\n\n\n<li>Person Number<\/li>\n\n\n\n<li>Display Name<\/li>\n\n\n\n<li>Gender<\/li>\n\n\n\n<li>Date of Birth<\/li>\n\n\n\n<li>Primary Email<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The Business Unit column must exist, because it will be used to dynamically filter the report when navigation occurs.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1 &#8211; Configure a Presentation Variable in the Child Report<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The child report must be capable of receiving the Business Unit value passed from the parent report.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Procedure<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open the child OTBI analysis in Edit mode.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"604\" height=\"335\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture1-11.png\" alt=\"\" class=\"wp-image-33794\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture1-11.png 604w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture1-11-300x166.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">2. Add a filter on Business Unit Name.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"459\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture2-14.png\" alt=\"\" class=\"wp-image-33795\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture2-14.png 907w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture2-14-300x152.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture2-14-768x389.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">3. Click Add More Options.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"544\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture3-14.png\" alt=\"\" class=\"wp-image-33796\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture3-14.png 907w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture3-14-300x180.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture3-14-768x461.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">4. Select Presentation Variable.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"533\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture4-13.png\" alt=\"\" class=\"wp-image-33797\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture4-13.png 907w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture4-13-300x176.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture4-13-768x451.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">5. Assign a variable name.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"557\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture5-11.png\" alt=\"\" class=\"wp-image-33798\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture5-11.png 907w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture5-11-300x184.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture5-11-768x472.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Example used in this guide:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2018X\u2019<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"557\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture5-13.png\" alt=\"\" class=\"wp-image-33799\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture5-13.png 907w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture5-13-300x184.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture5-13-768x472.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">6. Save the filter.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Result<\/u><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The child report can now receive the Business Unit value dynamically during drill-down navigation.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Step 2 &#8211; Configure Drill-Down Interaction in the Parent Report<\/u><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The drill-down interaction will be configured on the Business Unit column of the parent report.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Step 2.1 &#8211; Configure Column Interaction<\/u><\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open the parent OTBI report in Edit mode.<\/li>\n\n\n\n<li>Open Column Properties for the Business Unit Name column.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"537\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture6-9.png\" alt=\"\" class=\"wp-image-33800\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture6-9.png 907w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture6-9-300x178.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture6-9-768x455.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">3. Navigate to the Interaction tab.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"542\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture7-7.png\" alt=\"\" class=\"wp-image-33801\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture7-7.png 907w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture7-7-300x179.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture7-7-768x459.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">4. Under Column Heading<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Set:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Primary Interaction = None<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5. Under Value<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Select: \u2018Action Links\u2019<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"532\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture8-9.png\" alt=\"\" class=\"wp-image-33802\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture8-9.png 907w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture8-9-300x176.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture8-9-768x450.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">6. Click Add (+) to create a new action.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"516\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture9-10.png\" alt=\"\" class=\"wp-image-33803\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture9-10.png 907w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture9-10-300x171.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture9-10-768x437.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">7. Select Create New Action.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"467\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture10-6.png\" alt=\"\" class=\"wp-image-33804\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture10-6.png 907w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture10-6-300x154.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture10-6-768x395.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">8. Choose Navigate to BI Content.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"526\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture11-4.png\" alt=\"\" class=\"wp-image-33805\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture11-4.png 907w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture11-4-300x174.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture11-4-768x445.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">9.Browse and select the child OTBI report created earlier.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"604\" height=\"354\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture12-5.png\" alt=\"\" class=\"wp-image-33806\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture12-5.png 604w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture12-5-300x176.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">10.Enable: \u2018Open in New Window\u2019<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"526\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture13-3.png\" alt=\"\" class=\"wp-image-33807\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture13-3.png 907w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture13-3-300x174.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture13-3-768x445.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">11. Save the configuration.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Step 2.2 &#8211; Optional Prompt Configuration<\/u><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To make the report reusable in dashboards or prompted reports, the Business Unit column can also be configured with a prompt.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Steps:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open the Business Unit column settings.<\/li>\n\n\n\n<li>Add a filter on Business Unit.<\/li>\n\n\n\n<li>Set condition:<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Is Prompted<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"604\" height=\"301\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture14-3.png\" alt=\"\" class=\"wp-image-33808\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture14-3.png 604w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture14-3-300x150.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This step is optional but useful when integrating the report with dashboards.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>OTBI Drill-Down Result<\/u><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Once configured, the report behaves as follows:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>The parent report displays Business Unit workforce counts.<\/li>\n\n\n\n<li>Clicking a Business Unit triggers navigation.<\/li>\n\n\n\n<li>The employee detail report opens automatically filtered for that Business Unit.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Parent Report<\/u><\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"821\" height=\"580\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture15-5.png\" alt=\"\" class=\"wp-image-33809\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture15-5.png 821w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture15-5-300x212.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture15-5-768x543.png 768w\" sizes=\"auto, (max-width: 821px) 100vw, 821px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Example:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2018Civaro International Limited BU &#8211; 8 Employees\u2019<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"796\" height=\"581\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture16-3.png\" alt=\"\" class=\"wp-image-33810\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture16-3.png 796w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture16-3-300x219.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture16-3-768x561.png 768w\" sizes=\"auto, (max-width: 796px) 100vw, 796px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Child Report<\/u><\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"604\" height=\"420\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture17-2.png\" alt=\"\" class=\"wp-image-33811\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture17-2.png 604w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture17-2-300x209.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The report opens showing only employees belonging to the selected Business Unit.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><u>Part 2 &#8211; BI Publisher Drill-Down Implementation<\/u><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">While OTBI drill-down is configured using action links, BI Publisher drill-down uses URL navigation between reports.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><br>Reporting Scenario<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Navigate from a Department-wise employee summary report to a detailed employee report filtered by Department.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Workflow:<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Department Summary \u2192 Click Department \u2192 Employee Detail Report<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Prerequisites<\/u><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Two BI Publisher reports must exist.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Parent BI Publisher Report<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Contains:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Department Name<\/li>\n\n\n\n<li>Distinct employee count<\/li>\n\n\n\n<li>Active assignment and effective-date SQL filters<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Example output:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Department<\/strong><\/td><td><strong>Employees<\/strong><\/td><\/tr><tr><td><strong>Sales<\/strong><\/td><td>18<\/td><\/tr><tr><td><strong>HR<\/strong><\/td><td>11<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Child BI Publisher Report<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The detailed report must include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Employee-level columns<\/li>\n\n\n\n<li>A parameter used to receive the department value<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Required parameter:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">p_dep<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The SQL must filter using:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">:p_dep<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The parameter should be configured as Hidden.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Step 1 &#8211; Enable Interactive Output<\/u><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Drill-down navigation works only when the report output format is interactive.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Procedure<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open the parent report.<\/li>\n\n\n\n<li>Navigate to:<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Edit Report \u2192 View as List<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Set:<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Default Output Format = Interactive<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Save the report.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"200\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture18-2.png\" alt=\"\" class=\"wp-image-33812\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture18-2.png 907w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture18-2-300x66.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture18-2-768x169.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Step 2 &#8211; Construct the Child Report URL<\/u><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The parent report must call the child report using a dynamic URL that passes the department value.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">URL format:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">http:\/\/&lt;your_server&gt;&lt;port&gt;\/xmlpserver\/&lt;report_path&gt;\/report_name.xdo?&lt;parameter_name&gt;={\/Data_set\/Group\/Column_name_in_parent_report}<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Example implementation (In this Case):<\/p>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/emdm-test.fa.ap1.oraclecloud.com\/xmlpserver\/%7Eyash.ingle%40kovaion.com\/Yash\/emp_details_rep.xdo?p_dep={\/DATA_DS\/G_1\/DEPARTMENT_NAME}\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This configuration dynamically passes the Department Name from the parent report to the child report parameter.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Step 3 &#8211; Configure Drill-Down in Parent Layout<\/u><\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open the parent BI Publisher report.<\/li>\n\n\n\n<li>Click Edit Layout.<\/li>\n\n\n\n<li>Select the Department Name value cell (not the column header).<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"581\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture19-1.png\" alt=\"\" class=\"wp-image-33813\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture19-1.png 907w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture19-1-300x192.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture19-1-768x492.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open Properties.<\/li>\n\n\n\n<li>Paste the constructed URL into the URL field.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"799\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture20.png\" alt=\"\" class=\"wp-image-33814\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture20.png 907w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture20-300x264.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture20-768x677.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Save the layout and the report.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>BI Publisher Drill-Down Result<\/u><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Once configured:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>The parent report displays department-level employee counts.<\/li>\n\n\n\n<li>Clicking a department launches the detailed employee report.<\/li>\n\n\n\n<li>The child report opens automatically filtered for that department.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Parent Report<\/u><\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"604\" height=\"272\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture21.png\" alt=\"\" class=\"wp-image-33815\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture21.png 604w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture21-300x135.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Example:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Adv_Freight_Sales and Marketing Department &#8211; 8 Employees<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"863\" height=\"748\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture22.png\" alt=\"\" class=\"wp-image-33816\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture22.png 863w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture22-300x260.png 300w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture22-768x666.png 768w\" sizes=\"auto, (max-width: 863px) 100vw, 863px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u><br>Child Report<\/u><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The report shows employee records only for the selected department.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"604\" height=\"118\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture23.png\" alt=\"\" class=\"wp-image-33817\" srcset=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture23.png 604w, https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/05\/Picture23-300x59.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u><br>Implementation Best Practices<\/u><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Several implementation details significantly impact drill-down reliability.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Parameter Consistency<\/u><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Parameter names must match exactly between:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>URL configuration<\/li>\n\n\n\n<li>Child report parameter<\/li>\n\n\n\n<li>SQL filter<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Even minor mismatches prevent filtering from working.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Interactive Output for BI Publisher<\/u><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Clickable drill-down links only function when the report output format is Interactive.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Static outputs such as PDF or Excel will not support navigation.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Effective-Date Accuracy<\/u><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Employee reports must use proper effective-date joins.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Incorrect joins can produce inconsistent results where the summary count does not match the detail report.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Why Drill-Down Reporting Matters<\/u><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Well-designed drill-down reports transform static workforce reporting into interactive analysis.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Instead of generating multiple reports or applying filters repeatedly, users can move seamlessly between:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Executive-level metrics<\/li>\n\n\n\n<li>Operational employee data<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">This approach improves investigation speed, reduces reporting friction, and enables HR teams to identify workforce insights faster.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><u>Key Takeaways<\/u><\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>OTBI drill-down is implemented using Action Links and Presentation Variables.<\/li>\n\n\n\n<li>BI Publisher drill-down uses URL-based parameter navigation.<\/li>\n\n\n\n<li>Child reports must be designed to accept dynamic filtering parameters.<\/li>\n\n\n\n<li>Interactive output is mandatory for BI Publisher navigation.<\/li>\n\n\n\n<li>Correct effective-date logic ensures summary and detail reports remain consistent.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Overview Enterprise HR analytics rarely stop at summary numbers. Decision makers often start with a high-level metric &#8211; such as employee counts by Business Unit or Department, and then need to investigate the underlying employee data driving those numbers. Without drill-down capability, this investigation requires switching reports, applying filters manually, and repeating the same analysis [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":33818,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[18],"tags":[],"class_list":["post-33791","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-hcm"],"acf":[],"_links":{"self":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/33791","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/comments?post=33791"}],"version-history":[{"count":1,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/33791\/revisions"}],"predecessor-version":[{"id":33819,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/33791\/revisions\/33819"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media\/33818"}],"wp:attachment":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media?parent=33791"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/categories?post=33791"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/tags?post=33791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}