{"id":3588,"date":"2013-02-27T16:41:47","date_gmt":"2013-02-27T21:41:47","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=3588"},"modified":"2025-01-09T16:40:17","modified_gmt":"2025-01-09T21:40:17","slug":"cosort-accelerates-cognos-business-intelligence","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/","title":{"rendered":"Faster Insights from Cognos"},"content":{"rendered":"<p>There are a number of <a title=\"Wikipedia definition of Business Intelligence\" href=\"http:\/\/en.wikipedia.org\/wiki\/Business_intelligence\" target=\"_blank\" rel=\"noopener\">business intelligence<\/a> tools available today than can transform raw data into meaningful information. Because this process can be complex and involve large volumes of data however, it makes sense to use the right technologies at each step in the process &#8230; tools and techniques that combine well to deliver the fastest, most accurate results for business decision making, and make the process of metadata management and report design simpler and more efficient.<\/p>\n<p>Founders of modern data warehousing like Ralph Kimball have long recommended the external preparation of big transaction data outside the database and ETL tool layer, in sequential (flat) files. This approach removes a regular, resource-draining overhead from systems designed for queries and integrations, and provides a central, platform-independent way to exchange and manage data.<\/p>\n<p>The same approach for <a title=\"Business Intelligence Solutions Page\" href=\"http:\/\/www.iri.com\/solutions\/business-intelligence\" target=\"_blank\" rel=\"noopener\">business intelligence<\/a> (BI) tools &#8212; called <a href=\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-franchising\/\">data franchising<\/a>, data preparation, data preprocessing, and data wrangling &#8212; has been espoused for years by experts like Richard Sherman for logically related reasons. In addition to better performance, Sherman points out that pre-staging data to be visualized avoids the inherent metadata complexity, redundancy and synchronization problems of performing transformations in the BI layer.<\/p>\n<p>One of the best examples of BI optimization through technology combination is the use of <a href=\"http:\/\/www.iri.com\/products\/cosort\" target=\"_blank\" rel=\"noopener\">IRI\u00a0CoSort<\/a> to franchise, or prepare, high volumes of transactional data for data visualization outside Cognos. IBM&#8217;s Cognos tool delivers visual information on cumulative financial performance, strategy management and business intelligence, typically for analytic purposes. The CoSort Sort Control Language (SortCL) data transformation program simultaneously filters, sorts, joins, aggregates, segments and reformats data into subset CSV and other popular &#8216;feed&#8217; files outside the BI layer.<\/p>\n<p>As you would expect, staging data in flat files with CoSort &#8212; especially within a modern, metadata-managing, data-federating GUI like the IRI Workbench built on Eclipse &#8212; avoids the data integrity and reconciliation issues Sherman describes. Moreover, when high volumes of data are prepared in advance with CoSort, Cognos users can get their information in at least half the time it would otherwise take (using Cognos alone).<\/p>\n<p>A simple laptop-based benchmark running Cognos under Windows XP SP3 on an Intel\u00ae Core\u2122 CPU M370 @2.4GHz with 3 GB of DDR3 memory bears this out. When the necessary data transformations of sorting, joining, and aggregation were performed in Cognos for creating a report based on source data in 345MB and 89.2MB flat files, the entire job took <strong>158 seconds<\/strong>:<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3703\" title=\"4.RELATIONSHIP\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1.jpg\" alt=\"Performing a sort, join, aggregation in Cognos\" width=\"656\" height=\"369\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1.jpg 1110w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1-300x168.jpg 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1-1024x575.jpg 1024w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/REPORT-1-EMPLOYEES-AND-DEPARTMENT6.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3721\" title=\"REPORT 1 -EMPLOYEES AND DEPARTMENT\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/REPORT-1-EMPLOYEES-AND-DEPARTMENT6.jpg\" alt=\"\" width=\"658\" height=\"432\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/REPORT-1-EMPLOYEES-AND-DEPARTMENT6.jpg 823w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/REPORT-1-EMPLOYEES-AND-DEPARTMENT6-300x196.jpg 300w\" sizes=\"(max-width: 658px) 100vw, 658px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">Accelerating Cognos with SortCL is straightforward, especially if you are familiar with Eclipse, or at least the structure of your source data. The IRI Workbench GUI for CoSort users is a convenient, graphical environment for discovering, defining, managing, and transforming data in flat files and\/or data in RDBMS tables with SortCL.<\/p>\n<p style=\"text-align: left;\">Whether you define your\u00a0 SortCL data definitions or job specifications in text files or in the GUI, the self-documenting nature of the 4GL makes it easy to create and maintain both forms of metadata. The GUI simply automates the creation of the data wrangling job scripts using wizards:<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.file_sort_join_agg_tgt_job_SCL1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3704\" title=\"4.file_sort_join_agg_tgt_job_SCL\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.file_sort_join_agg_tgt_job_SCL1.jpg\" alt=\"\" width=\"656\" height=\"369\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.file_sort_join_agg_tgt_job_SCL1.jpg 1110w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.file_sort_join_agg_tgt_job_SCL1-300x168.jpg 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.file_sort_join_agg_tgt_job_SCL1-1024x575.jpg 1024w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">Once the jobs are built, the same transforms run this single CoSort Sort Control Language (SortCL) program took 21 seconds on the same laptop, with the results available to multiple applications. In this case, the Cognos user who created the same report (above in 158 seconds) only needed another 58 seconds to run this report, meaning that the start-to-finish time using CoSort was only <strong>79 seconds<\/strong>.<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/2.SORTJOIN-AGG.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3665 aligncenter\" title=\"2.SORTJOIN-AGG\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/2.SORTJOIN-AGG.jpg\" alt=\"\" width=\"590\" height=\"332\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/2.SORTJOIN-AGG.jpg 1110w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/2.SORTJOIN-AGG-300x168.jpg 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/2.SORTJOIN-AGG-1024x575.jpg 1024w\" sizes=\"(max-width: 590px) 100vw, 590px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">For more information on using CoSort for standalone or accelerated business intelligence, please see the <a title=\"Business Intelligence Solutions Page on IRI.com\" href=\"http:\/\/www.iri.com\/solutions\/Business_Intelligence\" target=\"_blank\" rel=\"noopener\">Business Intelligence<\/a> Solutions page available on IRI.com found here\u00a0<a title=\"Business Intelligence Solutions Page\" href=\"http:\/\/www.iri.com\/solutions\/business-intelligence\" target=\"_blank\" rel=\"noopener\">http:\/\/www.iri.com\/solutions\/business-intelligence<\/a> and the other articles in the <a title=\"Business Intelligence Section of the IRI Blog\" href=\"http:\/\/www.iri.com\/blog\/category\/business-intelligence\/\" target=\"_blank\" rel=\"noopener\">BI<\/a> section of the <a title=\"Business Intelligence Section of IRI Blog\" href=\"http:\/\/www.iri.com\/blog\/category\/business-intelligence\/\" target=\"_blank\" rel=\"noopener\">IRI blog<\/a> site.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are a number of business intelligence tools available today than can transform raw data into meaningful information. Because this process can be complex and involve large volumes of data however, it makes sense to use the right technologies at each step in the process &#8230; tools and techniques that combine well to deliver the<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/\" title=\"Faster Insights from Cognos\">Read More<\/a><\/div>\n","protected":false},"author":5,"featured_media":3703,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[32,1],"tags":[184,183,52,181,44,57,71,182,850,68,295],"class_list":["post-3588","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","category-data-transformation2","tag-accelerated-business-intelligence","tag-accelerating-cognos","tag-business-intelligence-2","tag-cognos","tag-cosort","tag-data-franchising","tag-eclipse","tag-etl-tool-layer","tag-iri-workbench","tag-sortcl","tag-www-iri-comcosort-accelerates-cognos-business-intelligence"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Faster Insights from Cognos - IRI<\/title>\n<meta name=\"description\" content=\"You can improve Cognos analytics delivery speed by wrangling data externally. This article shows an example of this using IRI CoSort.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Faster Insights from Cognos\" \/>\n<meta property=\"og:description\" content=\"You can improve Cognos analytics delivery speed by wrangling data externally. This article shows an example of this using IRI CoSort.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-27T21:41:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-09T21:40:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1110\" \/>\n\t<meta property=\"og:image:height\" content=\"624\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jason Koivu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jason Koivu\" \/>\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:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/\"},\"author\":{\"name\":\"Jason Koivu\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/c60bc4ff5919427034376979fb2cc8df\"},\"headline\":\"Faster Insights from Cognos\",\"datePublished\":\"2013-02-27T21:41:47+00:00\",\"dateModified\":\"2025-01-09T21:40:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/\"},\"wordCount\":610,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1.jpg\",\"keywords\":[\"accelerated business intelligence\",\"accelerating Cognos\",\"business intelligence\",\"Cognos\",\"CoSort\",\"data franchising\",\"Eclipse\",\"ETL tool layer\",\"IRI Workbench\",\"SortCL\",\"www.iri.com+cosort-accelerates-cognos-business-intelligence\"],\"articleSection\":[\"Business Intelligence (BI&#041;\",\"Data Transformation\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/\",\"url\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/\",\"name\":\"Faster Insights from Cognos - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1.jpg\",\"datePublished\":\"2013-02-27T21:41:47+00:00\",\"dateModified\":\"2025-01-09T21:40:17+00:00\",\"description\":\"You can improve Cognos analytics delivery speed by wrangling data externally. This article shows an example of this using IRI CoSort.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1.jpg\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1.jpg\",\"width\":1110,\"height\":624},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Faster Insights from Cognos\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/c60bc4ff5919427034376979fb2cc8df\",\"name\":\"Jason Koivu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/01e97234ff964558ca620a43a0506ef0?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/01e97234ff964558ca620a43a0506ef0?s=96&d=blank&r=g\",\"caption\":\"Jason Koivu\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/jasonk\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Faster Insights from Cognos - IRI","description":"You can improve Cognos analytics delivery speed by wrangling data externally. This article shows an example of this using IRI CoSort.","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:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/","og_locale":"en_US","og_type":"article","og_title":"Faster Insights from Cognos","og_description":"You can improve Cognos analytics delivery speed by wrangling data externally. This article shows an example of this using IRI CoSort.","og_url":"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/","og_site_name":"IRI","article_published_time":"2013-02-27T21:41:47+00:00","article_modified_time":"2025-01-09T21:40:17+00:00","og_image":[{"width":1110,"height":624,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1.jpg","type":"image\/jpeg"}],"author":"Jason Koivu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jason Koivu","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/"},"author":{"name":"Jason Koivu","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/c60bc4ff5919427034376979fb2cc8df"},"headline":"Faster Insights from Cognos","datePublished":"2013-02-27T21:41:47+00:00","dateModified":"2025-01-09T21:40:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/"},"wordCount":610,"commentCount":2,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1.jpg","keywords":["accelerated business intelligence","accelerating Cognos","business intelligence","Cognos","CoSort","data franchising","Eclipse","ETL tool layer","IRI Workbench","SortCL","www.iri.com+cosort-accelerates-cognos-business-intelligence"],"articleSection":["Business Intelligence (BI&#041;","Data Transformation"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/","url":"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/","name":"Faster Insights from Cognos - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1.jpg","datePublished":"2013-02-27T21:41:47+00:00","dateModified":"2025-01-09T21:40:17+00:00","description":"You can improve Cognos analytics delivery speed by wrangling data externally. This article shows an example of this using IRI CoSort.","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1.jpg","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1.jpg","width":1110,"height":624},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/cosort-accelerates-cognos-business-intelligence\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Faster Insights from Cognos"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/c60bc4ff5919427034376979fb2cc8df","name":"Jason Koivu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/01e97234ff964558ca620a43a0506ef0?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/01e97234ff964558ca620a43a0506ef0?s=96&d=blank&r=g","caption":"Jason Koivu"},"url":"https:\/\/www.iri.com\/blog\/author\/jasonk\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2013\/02\/4.RELATIONSHIP1.jpg","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/3588"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=3588"}],"version-history":[{"count":43,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/3588\/revisions"}],"predecessor-version":[{"id":18217,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/3588\/revisions\/18217"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/3703"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=3588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=3588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=3588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}