{"id":3344,"date":"2023-04-12T15:32:43","date_gmt":"2023-04-12T15:32:43","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/how-to-create-drill-through-reports-in-cognos-analytics-11\/"},"modified":"2026-01-16T15:07:43","modified_gmt":"2026-01-16T15:07:43","slug":"how-to-create-drill-through-reports-in-cognos-analytics-11","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/how-to-create-drill-through-reports-in-cognos-analytics-11\/","title":{"rendered":"How Do I Create Drill-Through Reports in Cognos Analytics 11 to Navigate Between Related Reports?"},"content":{"rendered":"

\u201cHow can I make sense of this information?\u00a0 It\u2019s too much detail!\u201d<\/em><\/strong><\/h3>\n

\"\"<\/p>\n

The example above shows sales information by Branch and City.\u00a0 However, this type of list report does not clearly tell us the story or answer the questions we may have. (i.e. What is the highest revenue earning city, what is the gross profit by city etc.).<\/p>\n

Now look at the reports below.\u00a0 This is a lot easier to read, don\u2019t you think?\u00a0 It has been summarized by City and ordered by Revenue. \u00a0Therefore, it clearly tells us Gen\u00e8ve was the top revenue generator.<\/p>\n

\"\"<\/p>\n

However, what if we still need to see the detail?\u00a0 We don\u2019t want to have to go through the trouble of closing the summary report to go to the detail report, right?\u00a0 This is where Drill Through Reports and Drill Through Definitions <\/em>come into play.<\/p>\n

You can create a drill-through definition to link two reports containing related information (the source report and the target report).\u00a0 Drill-through definitions appear in the source report as blue underlined links. Users click the hyperlink to select the value they want passed and to drill through to the target report. \u00a0\u00a0Below is a step-by-step procedure to create a drill through definition between the source report (Sales Summary) and the target report (Sales Data Detail).<\/p>\n

    \n
  1. Check the drill-through target report:\n
      \n
    • Confirm that the drill-through users have access to the target report.<\/li>\n
    • Confirm the required parameters exist in the target report. In our example above, we need to confirm YEAR and BRANCH are parameters in the Sales Data Detail.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n

      \"\"<\/p>\n

        \n
      1. Open the source report, Sales Summary<\/li>\n
      2. Select a data item that your report users will choose to drill on for more detailed information. In our example, we are using CITY.\u00a0\u00a0 Left click the element in the report that will serve as the starting point for the drill-through link.\u00a0 From the tool bar, choose ellipsis (…) and Drill-Through Definition.<\/li>\n<\/ol>\n

        \"\"<\/p>\n

          \n
        1. Define the Drill Through Definition by identifying the target report, the action, format and parameters.<\/li>\n<\/ol>\n
            \n
          • \n
              \n
            • Target Report:<\/strong> Identifies the drill-through target report. For this example, we are using the Sales Data Detail Report.<\/li>\n
            • Action:<\/strong> Specified what happens when you click the hyperlink.\u00a0 In our example, we want to run the target report<\/li>\n
            • Format:<\/strong> Define what you want the output to be.\u00a0 In this example, we want the report to run to HTML.<\/li>\n
            • Parameters:<\/strong> Define the values to be passed.\u00a0 In this example, we identified the YEAR and BRANCH fields.<\/li>\n
            • Note:<\/strong> QueBIT does not recommend the use of \u201cOpen in new Window\u201d.\u00a0 Do not check.<\/li>\n
            • Click OK.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

              \"\"<\/p>\n

                \n
              1. Run the report to confirm results (Note: I took the liberty of grouping and sectioning the target report for ease of use)<\/li>\n<\/ol>\n

                Source Report showing the hyperlink:<\/p>\n

                \"\"<\/p>\n

                By pressing the hyperlink for \u201cGen\u00e8ve\u201d, you now see the Target report showing detail information:<\/p>\n

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

                \u201cHow can I make sense of this information?\u00a0 It\u2019s too much detail!\u201d The example above shows sales information by Branch and City.\u00a0 However, this type of list report does not clearly tell us the story or answer the questions we may have. (i.e. What is the highest revenue earning city, what is the gross profit…<\/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-3344","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 Create Drill-Through Reports in Cognos Analytics 11 to Navigate Between Related Reports? - 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\/how-to-create-drill-through-reports-in-cognos-analytics-11\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Create Drill-Through Reports in Cognos Analytics 11 to Navigate Between Related Reports? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"\u201cHow can I make sense of this information?\u00a0 It\u2019s too much detail!\u201d The example above shows sales information by Branch and City.\u00a0 However, this type of list report does not clearly tell us the story or answer the questions we may have. (i.e. What is the highest revenue earning city, what is the gross profit…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/how-to-create-drill-through-reports-in-cognos-analytics-11\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:32:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-16T15:07:43+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\\\/how-to-create-drill-through-reports-in-cognos-analytics-11\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-to-create-drill-through-reports-in-cognos-analytics-11\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Create Drill-Through Reports in Cognos Analytics 11 to Navigate Between Related Reports?\",\"datePublished\":\"2023-04-12T15:32:43+00:00\",\"dateModified\":\"2026-01-16T15:07:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-to-create-drill-through-reports-in-cognos-analytics-11\\\/\"},\"wordCount\":482,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-to-create-drill-through-reports-in-cognos-analytics-11\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/CA-Drill7-1024x625.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\\\/how-to-create-drill-through-reports-in-cognos-analytics-11\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-to-create-drill-through-reports-in-cognos-analytics-11\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-to-create-drill-through-reports-in-cognos-analytics-11\\\/\",\"name\":\"How Do I Create Drill-Through Reports in Cognos Analytics 11 to Navigate Between Related Reports? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-to-create-drill-through-reports-in-cognos-analytics-11\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-to-create-drill-through-reports-in-cognos-analytics-11\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/CA-Drill7-1024x625.jpg\",\"datePublished\":\"2023-04-12T15:32:43+00:00\",\"dateModified\":\"2026-01-16T15:07:43+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-to-create-drill-through-reports-in-cognos-analytics-11\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-to-create-drill-through-reports-in-cognos-analytics-11\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-to-create-drill-through-reports-in-cognos-analytics-11\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/CA-Drill7-1024x625.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/CA-Drill7-1024x625.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-to-create-drill-through-reports-in-cognos-analytics-11\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Create Drill-Through Reports in Cognos Analytics 11 to Navigate Between Related Reports?\"}]},{\"@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 Create Drill-Through Reports in Cognos Analytics 11 to Navigate Between Related Reports? - 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\/how-to-create-drill-through-reports-in-cognos-analytics-11\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Create Drill-Through Reports in Cognos Analytics 11 to Navigate Between Related Reports? - QueBIT","og_description":"\u201cHow can I make sense of this information?\u00a0 It\u2019s too much detail!\u201d The example above shows sales information by Branch and City.\u00a0 However, this type of list report does not clearly tell us the story or answer the questions we may have. (i.e. What is the highest revenue earning city, what is the gross profit…","og_url":"https:\/\/quebit.com\/askquebit\/how-to-create-drill-through-reports-in-cognos-analytics-11\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:32:43+00:00","article_modified_time":"2026-01-16T15:07:43+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\/how-to-create-drill-through-reports-in-cognos-analytics-11\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/how-to-create-drill-through-reports-in-cognos-analytics-11\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Create Drill-Through Reports in Cognos Analytics 11 to Navigate Between Related Reports?","datePublished":"2023-04-12T15:32:43+00:00","dateModified":"2026-01-16T15:07:43+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/how-to-create-drill-through-reports-in-cognos-analytics-11\/"},"wordCount":482,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/how-to-create-drill-through-reports-in-cognos-analytics-11\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/05\/CA-Drill7-1024x625.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\/how-to-create-drill-through-reports-in-cognos-analytics-11\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/how-to-create-drill-through-reports-in-cognos-analytics-11\/","url":"https:\/\/quebit.com\/askquebit\/how-to-create-drill-through-reports-in-cognos-analytics-11\/","name":"How Do I Create Drill-Through Reports in Cognos Analytics 11 to Navigate Between Related Reports? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/how-to-create-drill-through-reports-in-cognos-analytics-11\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/how-to-create-drill-through-reports-in-cognos-analytics-11\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/05\/CA-Drill7-1024x625.jpg","datePublished":"2023-04-12T15:32:43+00:00","dateModified":"2026-01-16T15:07:43+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/how-to-create-drill-through-reports-in-cognos-analytics-11\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/how-to-create-drill-through-reports-in-cognos-analytics-11\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/how-to-create-drill-through-reports-in-cognos-analytics-11\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/05\/CA-Drill7-1024x625.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/05\/CA-Drill7-1024x625.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/how-to-create-drill-through-reports-in-cognos-analytics-11\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Create Drill-Through Reports in Cognos Analytics 11 to Navigate Between Related Reports?"}]},{"@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\/3344","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=3344"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3344\/revisions"}],"predecessor-version":[{"id":4942,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3344\/revisions\/4942"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}