{"id":3360,"date":"2023-04-12T15:32:48","date_gmt":"2023-04-12T15:32:48","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/"},"modified":"2026-01-16T14:58:38","modified_gmt":"2026-01-16T14:58:38","slug":"drill-through-from-a-dashboard-cognos-analytics-11-0-10","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/","title":{"rendered":"How Do I Configure Drill-Through from a Cognos Analytics Dashboard to a Detailed Report?"},"content":{"rendered":"

You\u2019re kidding, I can now drill through to a report from a dashboard!<\/em><\/strong><\/p>\n

One of the most popular Cognos Analytics (CA) enhancement requests across all of IBM has been the ability to drill from a Dashboard to a Report.\u00a0 Well, it can now be done.\u00a0 It is an easy task to author a drill-through that passes the context of a dashboard visualization to an authored report.\u00a0 Here\u2019s an example.<\/p>\n

Business Case:\u00a0 <\/strong><\/p>\n

The City of Boston currently utilizes a \u201c311 System\u201d, which enables city residents or city workers to easily report non-emergency issues.\u00a0 In an earlier article, \u201cInteractive Dashboards in Cognos Analytics 11.0.0+\u201d,<\/em> we created a dashboard for the department coordinator. It is an interactive dashboard which enables a user to monitor service requests for the city; as well as the requests by individual department, the source of the request and on time status.<\/p>\n

\"\"<\/p>\n

In this article, we want to enhance the dashboard by adding the ability to drill through to a detail report behind the On-Time Status visualization, specifically listing the calls which are open and show a status of \u201cOverdue\u201d.<\/p>\n

\"\"<\/p>\n

Procedure:<\/strong><\/p>\n

    \n
  1. Open the Dashboard created in the last Knowledge Base article, \u201cInteractive Dashboards in Cognos Analytics 11.0.0+\u201d.<\/em><\/li>\n<\/ol>\n

    \"\"<\/p>\n

      \n
    1. Single click on the \u201cOn Time Status\u201d visualization to access the tool bar. Click the \u201cDrill-Through\u201d icon<\/li>\n<\/ol>\n

      \"\"<\/p>\n

      The option to add a drill through appears.<\/p>\n

      \"\"<\/p>\n

        \n
      1. Select the target report. In this example, I have already created a simple report and saved it as \u201cDrill Through on Time Status\u201d.<\/li>\n<\/ol>\n

        \"\"<\/p>\n

        Note: Just as in a report-to-report drill through, you must ensure you have created optional prompts which correspond to the columns in the visualization which will have their values passed.\u00a0 If done correctly, you will be asked to assign the columns from your dashboard to the prompts in the target report as shown below.<\/p>\n

        \"\"<\/p>\n

        The final step is to apply and save the dashboard.<\/p>\n

          \n
        1. To access the report via the dashboard, execute the dashboard. Click on the visualization you originally added the drill through on and click on the drill through icon.<\/li>\n<\/ol>\n

          \"\"<\/p>\n

          Note:\u00a0 The default name of a drill-through can be changed and, as a convenience, a single drill-through created for a single visualization can be applied to all visualizations based on the same data source in a dashboard.<\/p>\n

           <\/p>\n","protected":false},"excerpt":{"rendered":"

          You\u2019re kidding, I can now drill through to a report from a dashboard! One of the most popular Cognos Analytics (CA) enhancement requests across all of IBM has been the ability to drill from a Dashboard to a Report.\u00a0 Well, it can now be done.\u00a0 It is an easy task to author a drill-through that…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[39,47,38],"class_list":["post-3360","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-cognos-analytics","tag-cognos-analytics-how-tos","tag-how-tos"],"acf":[],"yoast_head":"\nHow Do I Configure Drill-Through from a Cognos Analytics Dashboard to a Detailed Report? - QueBIT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Configure Drill-Through from a Cognos Analytics Dashboard to a Detailed Report? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"You\u2019re kidding, I can now drill through to a report from a dashboard! One of the most popular Cognos Analytics (CA) enhancement requests across all of IBM has been the ability to drill from a Dashboard to a Report.\u00a0 Well, it can now be done.\u00a0 It is an easy task to author a drill-through that…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:32:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-16T14:58:38+00:00\" \/>\n<meta name=\"author\" content=\"agoddard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"agoddard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Configure Drill-Through from a Cognos Analytics Dashboard to a Detailed Report?\",\"datePublished\":\"2023-04-12T15:32:48+00:00\",\"dateModified\":\"2026-01-16T14:58:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/\"},\"wordCount\":389,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/DD1-min-1024x497.jpg\",\"keywords\":[\"Cognos Analytics\",\"Cognos Analytics How To's\",\"How To\u2019s\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/\",\"url\":\"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/\",\"name\":\"How Do I Configure Drill-Through from a Cognos Analytics Dashboard to a Detailed Report? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/DD1-min-1024x497.jpg\",\"datePublished\":\"2023-04-12T15:32:48+00:00\",\"dateModified\":\"2026-01-16T14:58:38+00:00\",\"author\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#primaryimage\",\"url\":\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/DD1-min-1024x497.jpg\",\"contentUrl\":\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/DD1-min-1024x497.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/quebit.com\/askquebit\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Configure Drill-Through from a Cognos Analytics Dashboard to a Detailed Report?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/quebit.com\/askquebit\/#website\",\"url\":\"https:\/\/quebit.com\/askquebit\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/quebit.com\/askquebit\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084\",\"name\":\"agoddard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"caption\":\"agoddard\"},\"sameAs\":[\"https:\/\/quebit.com\/askquebit\"],\"url\":\"https:\/\/quebit.com\/askquebit\/author\/agoddard\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do I Configure Drill-Through from a Cognos Analytics Dashboard to a Detailed Report? - QueBIT","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Configure Drill-Through from a Cognos Analytics Dashboard to a Detailed Report? - QueBIT","og_description":"You\u2019re kidding, I can now drill through to a report from a dashboard! One of the most popular Cognos Analytics (CA) enhancement requests across all of IBM has been the ability to drill from a Dashboard to a Report.\u00a0 Well, it can now be done.\u00a0 It is an easy task to author a drill-through that…","og_url":"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:32:48+00:00","article_modified_time":"2026-01-16T14:58:38+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Configure Drill-Through from a Cognos Analytics Dashboard to a Detailed Report?","datePublished":"2023-04-12T15:32:48+00:00","dateModified":"2026-01-16T14:58:38+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/"},"wordCount":389,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/DD1-min-1024x497.jpg","keywords":["Cognos Analytics","Cognos Analytics How To's","How To\u2019s"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/","url":"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/","name":"How Do I Configure Drill-Through from a Cognos Analytics Dashboard to a Detailed Report? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/DD1-min-1024x497.jpg","datePublished":"2023-04-12T15:32:48+00:00","dateModified":"2026-01-16T14:58:38+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/DD1-min-1024x497.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/DD1-min-1024x497.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/drill-through-from-a-dashboard-cognos-analytics-11-0-10\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Configure Drill-Through from a Cognos Analytics Dashboard to a Detailed Report?"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084","name":"agoddard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","caption":"agoddard"},"sameAs":["https:\/\/quebit.com\/askquebit"],"url":"https:\/\/quebit.com\/askquebit\/author\/agoddard\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3360","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=3360"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3360\/revisions"}],"predecessor-version":[{"id":4933,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3360\/revisions\/4933"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}