{"id":2040,"date":"2015-02-17T21:57:28","date_gmt":"2015-02-17T19:57:28","guid":{"rendered":"http:\/\/koddit.com\/?p=2040"},"modified":"2015-02-18T08:37:30","modified_gmt":"2015-02-18T06:37:30","slug":"ibm-cognos-ozellikler","status":"publish","type":"post","link":"https:\/\/blog.koddit.com\/en\/is-zekasi\/ibm-cognos-ozellikler\/","title":{"rendered":"IBM Cognos Report Studio&#8217;nun \u00d6zellikleri"},"content":{"rendered":"<p>Herkese merhaba,\u00a0bu yaz\u0131m da\u00a0sizlere di\u011fer yaz\u0131lar\u0131m\u0131n devam\u0131 niteli\u011finde IBM Cognos Report Studio ile ilgili \u00f6zellikleri anlatmaya\u00a0devam edece\u011fim.<\/p>\n<p><em>Bu k\u0131sma ge\u00e7meden \u00f6nce di\u011fer yaz\u0131lar\u0131ma\u00a0g\u00f6z atman\u0131z\u0131 tavsiye ederim.<\/em><\/p>\n<h1>Report Studio Properties Penceresi&#8217;nde Neler Var?<\/h1>\n<h2>IBM Cognos Margin Nedir?<\/h2>\n<p>\u0130ki objenin aras\u0131n\u0131 a\u00e7ar.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/15.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2067\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/15-300x244.png\" alt=\"15\" width=\"300\" height=\"244\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2067\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/15-300x244.png\" alt=\"15\" width=\"300\" height=\"244\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/15-300x244.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/15-100x80.png 100w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/15.png 419w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<h2>IBM Cognos Size &amp; Overflow Nedir?<\/h2>\n<p>Barlar\u0131n aral\u0131klar\u0131n\u0131\u00a0belirler .<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/16.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-2068\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/16.png\" alt=\"16\" width=\"256\" height=\"206\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2068\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/16.png\" alt=\"16\" width=\"256\" height=\"206\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/16.png 256w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/16-100x80.png 100w\" sizes=\"(max-width: 256px) 100vw, 256px\" \/><\/noscript><\/a><\/p>\n<h2>IBM Cognos Table Properties Nedir?<\/h2>\n<p>Fixed size yap\u0131nca, Crostab kolonlar\u0131 e\u015fit boyutta olur.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/17.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-2069\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/17.png\" alt=\"17\" width=\"254\" height=\"183\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2069\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/17.png\" alt=\"17\" width=\"254\" height=\"183\" \/><\/noscript><\/a><\/p>\n<h2>IBM Cognos \u00a0Crostab Space Nedir?<\/h2>\n<p>Toolbox\u2019ta aradaki bo\u015fluklar\u0131 sa\u011flamak i\u00e7in Crosstab Space vard\u0131r.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/18.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-2071 size-large\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/18-1024x214.png\" alt=\"18\" width=\"798\" height=\"167\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2071 size-large\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/18-1024x214.png\" alt=\"18\" width=\"798\" height=\"167\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/18-1024x214.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/18-300x63.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/18-600x126.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/18.png 1686w\" sizes=\"(max-width: 798px) 100vw, 798px\" \/><\/noscript><\/a><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/19.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2072\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/19-300x20.png\" alt=\"19\" width=\"300\" height=\"20\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2072\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/19-300x20.png\" alt=\"19\" width=\"300\" height=\"20\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/19-300x20.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/19.png 398w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>Crostab\u2019in bir kolonu se\u00e7ilerek Toolbar\u2019da bulunan simgesi<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/211.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-2076 size-full\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/211.png\" alt=\"21\" width=\"834\" height=\"60\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2076 size-full\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/211.png\" alt=\"21\" width=\"834\" height=\"60\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/211.png 834w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/211-300x22.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/211-600x43.png 600w\" sizes=\"(max-width: 834px) 100vw, 834px\" \/><\/noscript><\/a><\/p>\n<p>se\u00e7ilir. Ayn\u0131 zamanda In the toolbar, Swap Columns and Rows button da bulunur. (Yani crosstab&#8217;te kolonlar sat\u0131r , sat\u0131rlar kolon yap\u0131labilir).<\/p>\n<p>&nbsp;<\/p>\n<h2>IBM Cognos Conditional Styles Nedir?<\/h2>\n<p>Bu \u00f6zellik Cognos&#8217;ta s\u0131k\u00e7a\u00a0kullan\u0131lan \u00f6nemli \u00f6zelliklerden biridir. Bu \u00f6zellik ile alanlar\u0131n ko\u015fuluna g\u00f6re rengini belirleyebiliriz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/2323.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-2240 size-full\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/2323.png\" alt=\"2323\" width=\"550\" height=\"144\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2240 size-full\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/2323.png\" alt=\"2323\" width=\"550\" height=\"144\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/2323.png 550w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/2323-300x79.png 300w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/noscript><\/a><\/p>\n<p>Buradan Conditional Styles &#8216;a t\u0131klan\u0131r , ard\u0131ndan\u00a0New Conditional Style\u2018a t\u0131klan\u0131r,<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/24.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2079\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/24-300x165.png\" alt=\"24\" width=\"300\" height=\"165\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2079\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/24-300x165.png\" alt=\"24\" width=\"300\" height=\"165\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/24-300x165.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/24-600x330.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/24.png 617w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0<img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2080\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/25-300x294.png\" alt=\"25\" width=\"300\" height=\"294\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2080\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/25-300x294.png\" alt=\"25\" width=\"300\" height=\"294\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/25-300x294.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/25.png 414w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u00d6rne\u011fin 20000 , 40000 , 60000 ve 80000 de\u011ferlerine g\u00f6re raporda renk belirtmek\u00a0istersek,<\/p>\n<p>a. 0-20000 : Poor<br \/>\nb. 20001-40000: Below Average<br \/>\nc. 40001-60000: Average<br \/>\nd. 60001-80000: Very Good<br \/>\ne. 80001 and above: Excellent<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/25.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2080\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/25-300x294.png\" alt=\"25\" width=\"300\" height=\"294\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2080\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/25-300x294.png\" alt=\"25\" width=\"300\" height=\"294\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/25-300x294.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/25.png 414w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2080\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/25-300x294.png\" alt=\"25\" width=\"300\" height=\"294\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2080\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/25-300x294.png\" alt=\"25\" width=\"300\" height=\"294\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/25-300x294.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/25.png 414w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u0130\u015fte Sonu\u00e7 :<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/28.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy  wp-image-2085 size-full aligncenter\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/28.png\" alt=\"28\" width=\"449\" height=\"150\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2085 size-full aligncenter\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/28.png\" alt=\"28\" width=\"449\" height=\"150\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/28.png 449w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/28-300x100.png 300w\" sizes=\"(max-width: 449px) 100vw, 449px\" \/><\/noscript><\/a><\/p>\n<h2>IBM Cognos Crosstab Default Measure Nedir?<\/h2>\n<p>\u00d6rne\u011fin, raporumuza bir Crosstab s\u00fcr\u00fckleyip\u00a0B\u00f6lge ve Kulvar baz\u0131nda k\u0131r\u0131p Default Measure&#8217;una da <em>Count<\/em>\u00a0Data item&#8217;\u0131n\u0131 se\u00e7ebiliriz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/29.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-2086\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/29.png\" alt=\"29\" width=\"210\" height=\"71\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2086\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/29.png\" alt=\"29\" width=\"210\" height=\"71\" \/><\/noscript>\u00a0 \u00a0 \u00a0 \u00a0\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2087\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/30-300x194.png\" alt=\"30\" width=\"300\" height=\"194\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2087\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/30-300x194.png\" alt=\"30\" width=\"300\" height=\"194\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/30-300x194.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/30.png 530w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2>IBM Cognos Chart \u00d6zellikleri Nelerdir?<\/h2>\n<p>\u00d6rne\u011fin Chart&#8217;\u0131m\u0131z\u0131n 3 boyutlu bir g\u00f6r\u00fcnt\u00fcs\u00fcn\u00fcn olmas\u0131n\u0131 istiyorsak, derinli\u011fine (45) ve Visual Angle (50) dersek 3 boyutlu bir g\u00f6r\u00fcnt\u00fc sa\u011flayabiliriz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/37.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2099\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/37-300x243.png\" alt=\"37\" width=\"300\" height=\"243\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2099\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/37-300x243.png\" alt=\"37\" width=\"300\" height=\"243\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/37-300x243.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/37-100x80.png 100w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/37.png 360w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Chart&#8217;\u0131m\u0131z\u0131n hangi g\u00f6r\u00fcnt\u00fcde olaca\u011f\u0131na <em><strong>Chart Type\u00a0<\/strong><\/em>k\u0131sm\u0131ndan karar verebiliriz. (Bar , Line , Area).<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/38.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2100\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/38-300x119.png\" alt=\"38\" width=\"300\" height=\"119\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2100\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/38-300x119.png\" alt=\"38\" width=\"300\" height=\"119\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/38-300x119.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/38.png 485w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/39.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2101\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/39-300x202.png\" alt=\"39\" width=\"300\" height=\"202\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2101\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/39-300x202.png\" alt=\"39\" width=\"300\" height=\"202\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/39-300x202.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/39.png 460w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/40.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2102\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/40-300x195.png\" alt=\"40\" width=\"300\" height=\"195\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2102\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/40-300x195.png\" alt=\"40\" width=\"300\" height=\"195\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/40-300x195.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/40.png 488w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Chart\u2019\u0131m\u0131z\u0131n ba\u015fl\u0131klar\u0131n\u0131 ve eksenlerini yine properties b\u00f6lmesinden ayarlayabiliriz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/41.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2103\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/41-300x62.png\" alt=\"41\" width=\"300\" height=\"62\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2103\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/41-300x62.png\" alt=\"41\" width=\"300\" height=\"62\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/41-300x62.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/41.png 354w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/42.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2104\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/42-300x72.png\" alt=\"42\" width=\"300\" height=\"72\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2104\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/42-300x72.png\" alt=\"42\" width=\"300\" height=\"72\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/42-300x72.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/42.png 404w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>E\u011fer de\u011ferlerin barlar\u0131n \u00fczerinde g\u00f6z\u00fckmesini istiyorsak :<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/45.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2108\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/45-300x34.png\" alt=\"45\" width=\"300\" height=\"34\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2108\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/45-300x34.png\" alt=\"45\" width=\"300\" height=\"34\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/45-300x34.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/45.png 481w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/461.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2110\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/461-300x201.png\" alt=\"46\" width=\"300\" height=\"201\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2110\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/461-300x201.png\" alt=\"46\" width=\"300\" height=\"201\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/461-300x201.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/461.png 465w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<h2>IBM Cognos\u00a0Section \u2013 Unsection Nedir?<\/h2>\n<p>\u00d6zelliklerimizi incelemeye devam etti\u011fimizde, \u00a0\u201cSection \u2013 Unsection\u201d \u00f6zelli\u011fini g\u00f6r\u00fcyoruz. Bu \u00f6zellik , raporda bir alana g\u00f6re (B\u00f6lge, Kanal) baz\u0131nda gruplamaya yarar.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/B.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-2115\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/B.png\" alt=\"B\" width=\"229\" height=\"162\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2115\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/B.png\" alt=\"B\" width=\"229\" height=\"162\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u00d6rne\u011fmizde Kanal baz\u0131nda bir gruplama yapt\u0131k .<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/3333.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2242\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/3333-300x119.png\" alt=\"3333\" width=\"300\" height=\"119\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2242\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/3333-300x119.png\" alt=\"3333\" width=\"300\" height=\"119\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2>IBM Cognos Grouping &amp; Sorting Nedir?<\/h2>\n<p>List se\u00e7ilerek properties k\u0131sm\u0131ndan Data-&gt; Grouping &amp; Sorting -&gt;<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/q.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2232\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/q-300x46.png\" alt=\"q\" width=\"300\" height=\"46\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2232\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/q-300x46.png\" alt=\"q\" width=\"300\" height=\"46\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/q-300x46.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/q.png 540w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<div id=\"attachment_2234\" style=\"width: 310px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/w.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2234\" class=\"lazy wp-image-2234 size-medium\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/w-300x101.png\" alt=\"w\" width=\"300\" height=\"101\" \/><p id=\"caption-attachment-2234\" class=\"wp-caption-text\"><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2234 size-medium\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/w-300x101.png\" alt=\"w\" width=\"300\" height=\"101\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/w-300x101.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/w.png 486w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a> B\u00f6lge baz\u0131nda s\u0131ralam\u0131\u015f oluyoruz.<\/p><\/div>\n<div id=\"attachment_2236\" style=\"width: 310px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/e4.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2236\" class=\"lazy wp-image-2236 size-medium\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/e4-300x195.png\" alt=\"e\" width=\"300\" height=\"195\" \/><p id=\"caption-attachment-2236\" class=\"wp-caption-text\"><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2236 size-medium\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/e4-300x195.png\" alt=\"e\" width=\"300\" height=\"195\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/e4-300x195.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/e4-600x391.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/e4.png 952w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a> Raporu B\u00f6lge Baz\u0131nda alfabetik olarak b\u00f6lm\u00fc\u015f oluyoruz.<\/p><\/div>\n<p>&nbsp;<\/p>\n<h2>IBM Cognos \u00a0Crostab Master Detail Relationship Nedir?<\/h2>\n<p>\u00d6rne\u011fin <em>kanal<\/em> baz\u0131nda ya da <em>b\u00f6lge <\/em> baz\u0131nda sayfaya bir filtre koyarsak sayfada bulunan Crosstab\u2019inde bu bazlarda sonu\u00e7lar \u00fcretmesi gerekece\u011finden Cognos otomatik olarak <em>Master Detail Relationship<\/em>\u00a0kurar.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/441.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2243\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/441-300x177.png\" alt=\"44\" width=\"300\" height=\"177\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2243\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/441-300x177.png\" alt=\"44\" width=\"300\" height=\"177\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/441-300x177.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/441.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/441-600x353.png 600w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<h2>IBM Cognos \u00a0Source Type&#8217;lar\u0131 Nelerdir?<\/h2>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/E.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2120\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/E-300x126.png\" alt=\"E\" width=\"300\" height=\"126\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2120\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/E-300x126.png\" alt=\"E\" width=\"300\" height=\"126\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/E-300x126.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/E-600x252.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/E.png 707w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>Ekledi\u011fimiz bir objenin a\u011fa\u00e7 yap\u0131s\u0131n\u0131 buradan g\u00f6r\u00fcnt\u00fcleyebiliriz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/F.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2121\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/F-300x152.png\" alt=\"F\" width=\"300\" height=\"152\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2121\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/F-300x152.png\" alt=\"F\" width=\"300\" height=\"152\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/F-300x152.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/F-450x230.png 450w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/F.png 596w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<h2>IBM Cognos For yap\u0131s\u0131 Nedir?<\/h2>\n<p>\u00d6rne\u011fin b\u00f6lge baz\u0131nda br\u00fctprimi k\u0131rabiliriz. Yani bu calculation ile her b\u00f6lge i\u00e7in ayr\u0131 ayr\u0131 o b\u00f6lgeye \u00f6zg\u00fc br\u00fctprimini hesaplayabiliriz.<\/p>\n<p>B\u00f6lge baz\u0131nda\u00a0Br\u00fctprim hesab\u0131;<\/p>\n<p>total([Br\u00fctprim] for [BOLGE])<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/G.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2122\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/G-300x206.png\" alt=\"G\" width=\"300\" height=\"206\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2122\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/G-300x206.png\" alt=\"G\" width=\"300\" height=\"206\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/G-300x206.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/G-600x412.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/G.png 696w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<h2>IBM Cognos Within Set Filter Nedir?<\/h2>\n<p>\u00d6rne\u011fin burada X\u00a0= null i\u00e7in toplam S\u00f6zle\u015fme Say\u0131s\u0131n\u0131 bulmak istiyoruz :<\/p>\n<p>total([S\u00f6zle\u015fme Say\u0131s\u0131] within set filter ([X]; [X]= null)) \/ [S\u00f6zle\u015fme Say\u0131s\u0131] \u015feklinde bulabiliriz.<\/p>\n<h2>IBM Cognos Optinal Prompt Ekran\u0131 Nas\u0131l Yap\u0131l\u0131r?<\/h2>\n<p>E\u011fer Prompt ekran\u0131nda optinal olmas\u0131n\u0131 istedi\u011finiz objeler varsa,<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/I.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-2124 size-thumbnail\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/I-150x150.png\" alt=\"I\" width=\"150\" height=\"150\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2124 size-thumbnail\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/I-150x150.png\" alt=\"I\" width=\"150\" height=\"150\" \/><\/noscript><\/a><\/p>\n<p>\u00d6rne\u011fin Sat\u0131\u015f kanal\u0131 se\u00e7ilse de olur se\u00e7ilmese de olur diyebilmemiz i\u00e7in\u00a0, Value Prompt -&gt; Properties&#8217;inden -&gt; General -&gt; Required NO \u00a0yap\u0131yoruz ve<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/x.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2133\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/x-234x300.png\" alt=\"x\" width=\"234\" height=\"300\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2133\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/x-234x300.png\" alt=\"x\" width=\"234\" height=\"300\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/x-234x300.png 234w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/x.png 338w\" sizes=\"(max-width: 234px) 100vw, 234px\" \/><\/noscript><\/a><\/p>\n<p>psat\u0131skanal\u0131n\u0131 aktif etti\u011fimiz Ana Querymizde onu yine<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/J1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2135\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/J1-300x100.png\" alt=\"J\" width=\"300\" height=\"100\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2135\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/J1-300x100.png\" alt=\"J\" width=\"300\" height=\"100\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/J1-300x100.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/J1.png 538w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Detail Filter&#8217;\u0131m\u0131zda Propertiesten-&gt; Usage -&gt; Optional yap\u0131yoruz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/ff.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2245\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/ff.png\" alt=\"ff\" width=\"270\" height=\"143\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2245\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/ff.png\" alt=\"ff\" width=\"270\" height=\"143\" \/><\/noscript><\/a><\/p>\n<h2>IBM Cognos White Space Nedir?<\/h2>\n<p>E\u011fer value prompt&#8217;a koydu\u011fun de\u011ferler a\u015fa\u011f\u0131ya do\u011fru \u00e7ok fazla inerse , g\u00f6r\u00fcnt\u00fc d\u00fczenin bozulmamas\u0131 ad\u0131na ilgili texti se\u00e7ip properties ekran\u0131nda White Space -&gt; NO WRAP yapabiliriz.<\/p>\n<h2>IBM Cognos ile Tab Nas\u0131l Eklenir?<\/h2>\n<p>Security -&gt; Setproperties -&gt;Search -&gt;P\u0131nar Elmas -&gt; Preferences -&gt; Set Portal Tools -&gt; Yeni bir <em>Tab<\/em> ekleyebilirsin. (Admin olmak \u015fart\u0131yla.)<\/p>\n<p><em><strong>1)<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/L.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-2137 size-large\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/L-1024x173.png\" alt=\"L\" width=\"798\" height=\"135\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2137 size-large\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/L-1024x173.png\" alt=\"L\" width=\"798\" height=\"135\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/L-1024x173.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/L-300x51.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/L-600x102.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/L.png 1700w\" sizes=\"(max-width: 798px) 100vw, 798px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><em><strong>2)<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/M.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2139\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/M-300x221.png\" alt=\"M\" width=\"300\" height=\"221\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2139\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/M-300x221.png\" alt=\"M\" width=\"300\" height=\"221\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/M-300x221.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/M.png 416w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><em><strong>3)<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/N.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-2140 size-large\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/N-1024x270.png\" alt=\"N\" width=\"798\" height=\"210\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2140 size-large\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/N-1024x270.png\" alt=\"N\" width=\"798\" height=\"210\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/N-1024x270.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/N-300x79.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/N-600x158.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/N.png 1715w\" sizes=\"(max-width: 798px) 100vw, 798px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><em><strong>4)<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/P.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2141\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/P-300x58.png\" alt=\"P\" width=\"300\" height=\"58\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2141\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/P-300x58.png\" alt=\"P\" width=\"300\" height=\"58\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/P-300x58.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/P-1024x198.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/P-600x116.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/P.png 1915w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p><strong>Dip not:\u00a0<\/strong>Cognos\u2019ta her i\u015flem Application Server \u00fczerinde y\u00fckl\u00fc olan Cognos BI Server\u2019\u0131n IBM Websphere (WAS ) App Server \u00fczerine deployement ve \u00e7al\u0131\u015ft\u0131r\u0131lmas\u0131 ile ger\u00e7ekle\u015fir.<\/p>\n<h2>IBM Cognos&#8217;ta Rapor No Data\u00a0nas\u0131l \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r?<\/h2>\n<p>Query Studio da olu\u015fturdu\u011fumuz raporumuzu h\u0131zl\u0131 bir \u015fekilde \u00e7al\u0131\u015ft\u0131rmak istersek (i\u00e7indeki data ile de\u011filde g\u00f6r\u00fcn\u00fcmle ilgili de\u011fi\u015fikleri h\u0131zl\u0131ca yapmak i\u00e7in).<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/191.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2183\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/191-300x123.png\" alt=\"19\" width=\"300\" height=\"123\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2183\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/191-300x123.png\" alt=\"19\" width=\"300\" height=\"123\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/191-300x123.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/191.png 460w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/20.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2184\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/20-176x300.png\" alt=\"20\" width=\"176\" height=\"300\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2184\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/20-176x300.png\" alt=\"20\" width=\"176\" height=\"300\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/20-176x300.png 176w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/20.png 274w\" sizes=\"(max-width: 176px) 100vw, 176px\" \/><\/noscript><\/a> deyip \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131zda datas\u0131z bir \u015fekilde h\u0131zl\u0131ca \u00e7al\u0131\u015facakt\u0131r.<\/p>\n<h2>IBM Cognos&#8217;ta XML PARSE nas\u0131l yap\u0131l\u0131r?<\/h2>\n<p>Cognas&#8217;ta analiz yapmak i\u00e7in rapolarda kullan\u0131lan alanlar\u0131n (kolon isimlerinin) al\u0131nmas\u0131 gerekirse,<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/211.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-2076 size-full\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/211.png\" alt=\"21\" width=\"834\" height=\"60\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2076 size-full\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/211.png\" alt=\"21\" width=\"834\" height=\"60\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/211.png 834w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/211-300x22.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/211-600x43.png 600w\" sizes=\"(max-width: 834px) 100vw, 834px\" \/><\/noscript><\/a><\/p>\n<p>Raporumuzu XML olarak \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131zda a\u015fa\u011f\u0131daki formata uygun bir \u015fekile \u00e7evirmeliyiz.<\/p>\n<p>A\u015fa\u011f\u0131da SQL\u2019den beslenen (<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/221.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-2186\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/221.png\" alt=\"22\" width=\"155\" height=\"83\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2186\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/221.png\" alt=\"22\" width=\"155\" height=\"83\" \/><\/noscript><\/a> ) bir raporun xmlini parse ederek kolon ismine ula\u015fmaya cal\u0131\u015faca\u011f\u0131z.<\/p>\n<p>\u0130lk olarak\u00a0raporumuza Kat\u0131l\u0131mc\u0131AdSoyad diye bir dataitem ekliyoruz<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/231.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2187\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/231-300x200.png\" alt=\"23\" width=\"300\" height=\"200\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2187\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/231-300x200.png\" alt=\"23\" width=\"300\" height=\"200\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/231-300x200.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/231.png 502w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>Daha sonra Tools-&gt; Copy Report to Clipboard<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/241.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2188\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/241-300x209.png\" alt=\"24\" width=\"300\" height=\"209\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2188\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/241-300x209.png\" alt=\"24\" width=\"300\" height=\"209\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/241-300x209.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/241.png 523w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>Diyip pl-sql developer\u2019\u0131m\u0131za \u00e7\u0131kan XML kodumuzu yap\u0131\u015ft\u0131r\u0131yoruz.Bu alan\u0131 a\u015fa\u011f\u0131daki \u015fablona uygun olacak \u015fekilde dizayn ediyoruz.<\/p>\n<pre class=\"lang:default decode:true\">DECLARE\r\nx XMLType := XMLType(\r\n'\r\n\r\nSELECT\r\nTable__90.\" Kat\u0131l\u0131mc\u0131AdSoyad \"\r\nFROM\r\n(\r\nSELECT\r\nP1.SIRKET as \" Kat\u0131l\u0131mc\u0131AdSoyad \",\r\n\r\n[SQL1].[ Kat\u0131l\u0131mc\u0131AdSoyad]\r\n\r\n)\r\n\r\n');\r\nBEGIN\r\n\r\nFOR r IN (\r\nSELECT ExtractValue(Value(p),'\/dataItem\/expression\/text()') as name\r\nFROM TABLE(XMLSequence(Extract(x,'\/\/query\/selection\/dataItem'))) p\r\n) LOOP\r\n\r\ndbms_output.put_line (r.name);\r\n\r\nEND LOOP;\r\n\r\nEND;<\/pre>\n<p>\u015eekline d\u00f6n\u00fc\u015ft\u00fcrmeliyiz. Rapor sql\u2019den de beslense, i\u00e7erisinde bir calculation da kullan\u0131lsa, \u00a0yine raporda kullan\u0131lan alanlar\u0131\u00a0bize d\u00f6nd\u00fcrecektir.<\/p>\n<p>Sonu\u00e7 :<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/251.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2191\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/251-300x142.png\" alt=\"25\" width=\"300\" height=\"142\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2191\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/251-300x142.png\" alt=\"25\" width=\"300\" height=\"142\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/251-300x142.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/251.png 318w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<h2>IBM Cognos Token Prompt Nedir?<\/h2>\n<p>Cognos toolboxtan sayfaya bir value prompt ekliyoruz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/261.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2193\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/261-300x254.png\" alt=\"26\" width=\"300\" height=\"254\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2193\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/261-300x254.png\" alt=\"26\" width=\"300\" height=\"254\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/261-300x254.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/261.png 491w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/271.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2194\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/271-300x136.png\" alt=\"27\" width=\"300\" height=\"136\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2194\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/271-300x136.png\" alt=\"27\" width=\"300\" height=\"136\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/271-300x136.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/271-316x144.png 316w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/271.png 317w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>Value prompt\u2019un Static Choices\u2019\u0131na Token i\u00e7in kullanaca\u011f\u0131m\u0131z ve tetiklendi\u011finde de\u011fi\u015fmesini istedi\u011fimiz alanlar\u0131m\u0131z\u0131 koyuyoruz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/281.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2195\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/281-300x192.png\" alt=\"28\" width=\"300\" height=\"192\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2195\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/281-300x192.png\" alt=\"28\" width=\"300\" height=\"192\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/281-300x192.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/281-600x384.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/281.png 618w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>Burada queryde kulland\u0131\u011f\u0131m\u0131z item\u0131n source\u2019una kadar inmeyi unutmayal\u0131m.<br \/>\n<a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/291.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2196\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/291-300x239.png\" alt=\"29\" width=\"300\" height=\"239\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2196\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/291-300x239.png\" alt=\"29\" width=\"300\" height=\"239\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/291-300x239.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/291-100x80.png 100w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/291.png 488w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/301.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-2197\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/301.png\" alt=\"30\" width=\"246\" height=\"183\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2197\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/301.png\" alt=\"30\" width=\"246\" height=\"183\" \/><\/noscript><\/a> Query calculation\u0131m\u0131z\u0131n i\u00e7ine\u00a0Token\u2019\u0131m\u0131z\u0131 format\u0131na uygun \u015fekilde d\u00fczenliyoruz.<\/p>\n<pre class=\"lang:default decode:true\">#prompt (\u2018pparametreadi\u2019 , \u2018token\u2019 , \u2018default gelmesini istedi\u011fin \u2019 ) #<\/pre>\n<p>Biz Data item expression\u0131m\u0131zda query\u2019deki \u201cURUNADI\u201d alan\u0131m\u0131z\u0131n default olarak gelmesini istiyoruz<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/313.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2198\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/313-300x206.png\" alt=\"31\" width=\"300\" height=\"206\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2198\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/313-300x206.png\" alt=\"31\" width=\"300\" height=\"206\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/313-300x206.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/313-600x412.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/313.png 697w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/321.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-2199\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/321.png\" alt=\"32\" width=\"247\" height=\"86\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2199\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/321.png\" alt=\"32\" width=\"247\" height=\"86\" \/><\/noscript><\/a><\/p>\n<p>Burada value prompttaki se\u00e7imimize g\u00f6re \u00fcr\u00fcnad\u0131 ya da sat\u0131\u015f kanal\u0131n\u0131 getirebiliyoruz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/331.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-2200\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/331.png\" alt=\"33\" width=\"279\" height=\"100\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2200\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/331.png\" alt=\"33\" width=\"279\" height=\"100\" \/><\/noscript><\/a><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/341.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-2201\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/341.png\" alt=\"34\" width=\"268\" height=\"95\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2201\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/341.png\" alt=\"34\" width=\"268\" height=\"95\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2>IBM Cognos Burst Nedir?<\/h2>\n<p>\u00d6rne\u011fimizde Acente\u2019leri Email Adresleri baz\u0131nda k\u0131rd\u0131k. Yani A acentesi ile ilgili bilgiler A acentesinin mailinde bulunan ki\u015filere B acentesi ile ilgili bilgiler B acentesinin mailinde bulunan ki\u015filere gidecektir.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/A1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2204\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/A1-300x207.png\" alt=\"A\" width=\"300\" height=\"207\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2204\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/A1-300x207.png\" alt=\"A\" width=\"300\" height=\"207\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/A1-300x207.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/A1.png 521w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/B1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2205\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/B1-300x194.png\" alt=\"B\" width=\"300\" height=\"194\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2205\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/B1-300x194.png\" alt=\"B\" width=\"300\" height=\"194\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/B1-300x194.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/B1.png 519w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<h2>PL\/SQL &#8211; PIVOT \/ UNPIVOT TABLE<\/h2>\n<p>Bu konuyu bir \u00f6rnek \u00fczerinde incelemek i\u00e7in bir tablo yaratal\u0131m,<\/p>\n<pre class=\"lang:default decode:true\">create table Deneme_Pinar (ogrenci_id varchar2(10) , ogrenci_adi varchar2(100) , vize_notu number );\r\n\r\nINSERT INTO Deneme_Pinar VALUES ('1', 'P\u0131nar', 30);\r\nINSERT INTO Deneme_Pinar VALUES ('1', 'P\u0131nar', 40);\r\nINSERT INTO Deneme_Pinar VALUES ('2', 'Caner', 100);\r\nINSERT INTO Deneme_Pinar VALUES ('2', 'Caner', 90);\r\nINSERT INTO Deneme_Pinar VALUES ('3', 'Rahile', 50);\r\nINSERT INTO Deneme_Pinar VALUES ('3', 'Rahile', 65);\r\nINSERT INTO Deneme_Pinar VALUES ('4', 'Bahar', 60);\r\nINSERT INTO Deneme_Pinar VALUES ('4', 'Bahar', 70);<\/pre>\n<pre class=\"lang:default decode:true\">select * from (\r\nselect ogrenci_id , ogrenci_adi , vize_notu from deneme_pinar )\r\nPIVOT (sum (vize_notu) for (ogrenci_adi) IN ('P\u0131nar' as P\u0131nar , 'Caner' as Caner , 'Rahile' as Rahile , 'Bahar' as Bahar ) )\r\nOrder By 1 ;<\/pre>\n<p>Sonu\u00e7 :<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/E1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2207\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/E1-300x103.png\" alt=\"E\" width=\"300\" height=\"103\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2207\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/E1-300x103.png\" alt=\"E\" width=\"300\" height=\"103\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/E1-300x103.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/E1.png 380w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<h2>Unpivot<\/h2>\n<p>PIVOT yap\u0131lm\u0131\u015f tabloyu, sorguyu sat\u0131r baz\u0131na indirir.<\/p>\n<pre class=\"lang:default decode:true\">CREATE OR REPLACE VIEW deneme_pivot AS\r\nSELECT * FROM (select ogrenci_id , ogrenci_adi , vize_notu from deneme_pinar )\r\nPIVOT (sum (vize_notu) for (ogrenci_adi) IN ('P\u0131nar' as P\u0131nar , 'Caner' as Caner , 'Rahile' as Rahile , 'Bahar' as Bahar ) )\r\n<\/pre>\n<pre class=\"lang:default decode:true\">SELECT * FROM deneme_pivot\r\nUNPIVOT INCLUDE NULLS (vize_notu FOR ogrenci_adi IN (P\u0131nar AS 'P\u0131nar' , Caner as 'Caner' , Rahile as 'Rahile' , Bahar as 'Bahar' ) )\r\nORDER BY 1,2,3;<\/pre>\n<p>Sonu\u00e7 :<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/H1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2208\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/H1-287x300.png\" alt=\"H\" width=\"287\" height=\"300\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2208\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/H1-287x300.png\" alt=\"H\" width=\"287\" height=\"300\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/H1-287x300.png 287w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/H1.png 321w\" sizes=\"(max-width: 287px) 100vw, 287px\" \/><\/noscript><\/a><\/p>\n<h2>IBM Cognos Transformer Nedir?<\/h2>\n<p>Data&#8217;y\u0131 analiz etmek (Parent &#8211; Child ili\u015fkisini belirlemek) i\u00e7in bir K\u00fcp yap\u0131s\u0131 kullan\u0131l\u0131r. Freamwork gibi bir yap\u0131s\u0131 olan Transformer&#8217;da hem relational hem dimensional alanlar\u0131 i\u00e7inde bar\u0131nd\u0131r\u0131r.<\/p>\n<p>Datan\u0131n b\u00fcy\u00fckl\u00fc\u011f\u00fcne g\u00f6re h\u0131zl\u0131 cevap vermesi sebebiyle\u00a0Transformer (k\u00fcp yap\u0131s\u0131) kullan\u0131l\u0131r. FM\u2019den fark\u0131 ikisinde de kulland\u0131\u011f\u0131n\u00a0her bir obje i\u00e7in arkada bir <em>select<\/em> \u00e7eker ancak Transformer olu\u015fturdu\u011fu bu tabloyu cache\u2019de tutar ve h\u0131zl\u0131 response ve analizi sa\u011flar.<\/p>\n<p>(MDX : Bunu kulland\u0131\u011f\u0131 kendine \u00f6zg\u00fc MDX dili ile sa\u011flar) . Tabi ki k\u00fcb\u00fcn de bir limiti vard\u0131r. Bunun ilerisi Veri Madencili\u011fi konusuna girer.<\/p>\n<p><strong>QueryStudio<\/strong>: Relational ve Dimeansinol bir yap\u0131ya sahiptir.<br \/>\n<strong>Report Studio<\/strong>: Relational ve Dimeansinol<br \/>\n<strong>Analysis Studio<\/strong>: Sadece Dimensinol (Parent &#8211; Child ili\u015fkisinin olmas\u0131 gerekiyor).<\/p>\n<p><em><strong>Dip not:<\/strong><\/em><\/p>\n<p>Malum konu Big Data olunca kullan\u0131d\u0131\u011f\u0131m\u0131z data miktar\u0131 da artmaktad\u0131r. Data miktar\u0131 art\u0131nca sorunlarda art\u0131yor \ud83d\ude42<\/p>\n<p><em>\u015eimdi ise sizlere Cognos&#8217;ta kar\u015f\u0131la\u015ft\u0131\u011f\u0131m \u00a0bir sorun\u00a0ve bunun \u00e7\u00f6z\u00fcm\u00fc ile ilgili bir ayr\u0131nt\u0131y\u0131 payla\u015faca\u011f\u0131m.<\/em><\/p>\n<p>Excel&#8217;e gelen 1000 sat\u0131rdan fazla kolonlar\u0131 Cognos&#8217;ta\u00a0\u00a0<strong><em>Text Prompt\u00a0<\/em><\/strong>\u00a0kullanarak \u00a0almaya \u00e7al\u0131\u015ft\u0131\u011f\u0131m\u0131zda hata verir. \u00c7\u00fcnk\u00fc Cognos bu i\u015flemi yaparken <em><strong>in<\/strong><\/em> (a,b,c,d) \u015feklinde al\u0131r. Bu y\u00fczden de 1000 sat\u0131rdan fazla olan bir alan\u0131 Cognos&#8217;a bu \u015fekilde direkt alam\u0131yoruz. Bunun i\u00e7in, \u00a0biz de pl\/sql developer\u2019da bir kolonlu bir tablo yarat\u0131p i\u00e7erisine exceldeki alan\u0131m\u0131z\u0131 a\u015fa\u011f\u0131da ki \u015fekilde al\u0131p,\u00a0sql kodumuzu ise bu yeni olu\u015fturdu\u011fumuz tablo ile join\u2019ledik.<\/p>\n<pre class=\"lang:default decode:true\">select * from table_ad\u0131 for update<\/pre>\n<p>diyip kilidi a\u00e7t\u0131\u011f\u0131m\u0131zda \u00a0 (<a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/oracle.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-2214\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/oracle.png\" alt=\"oracle\" width=\"236\" height=\"28\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2214\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/oracle.png\" alt=\"oracle\" width=\"236\" height=\"28\" \/><\/noscript><\/a>)\u00a0i\u00e7ine excelden ald\u0131\u011f\u0131m\u0131z kolonu bir kolon bo\u015f b\u0131rakarak yap\u0131\u015ft\u0131r\u0131p <strong><em>Commit<\/em><\/strong> edersek\u00a0exceldeki kolonu direkt alabiliriz.<\/p>\n<h2>Excelde Vlookup ve Pivot alma \u00f6zellikleri<\/h2>\n<p>\u0130\u015fimiz big datalarla olunca o datalar\u0131 bir \u015fekilde d\u00fczenlememiz gerekiyor. Datalar\u0131n i\u00e7inde kaybolmamak i\u00e7in size excelin iki \u00f6nemli \u00f6zelli\u011finden\u00a0bahsedece\u011fim.<\/p>\n<p>Birincisi <strong>VLookUp<\/strong> : Di\u011fer ad\u0131 ile d\u00fc\u015feyara fonksiyonudur.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy  size-full wp-image-2042 alignleft\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/1.png\" alt=\"1\" width=\"131\" height=\"102\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2042 alignleft\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/1.png\" alt=\"1\" width=\"131\" height=\"102\" \/><\/noscript>\u00a0\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"lazy  wp-image-2046 alignleft\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/2.png\" alt=\"2\" width=\"130\" height=\"101\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2046 alignleft\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/2.png\" alt=\"2\" width=\"130\" height=\"101\" \/><\/noscript><\/a>Burada soru i\u015fareti olan yere excel fonksiyonumuzu yaz\u0131yoruz.<\/p>\n<p>=VLOOKUP (Kar\u015f\u0131l\u0131l\u0131\u011f\u0131 bulunacak kolon (C); Aranacak Tablo (A-B) ; Aranacak Tablo Indexi (2.kolon) , Default De\u011fer (true\/false) )<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy  size-medium wp-image-2047 aligncenter\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/3-300x201.png\" alt=\"3\" width=\"300\" height=\"201\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-2047 aligncenter\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/3-300x201.png\" alt=\"3\" width=\"300\" height=\"201\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/3-300x201.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/3.png 538w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>Pivot tablo raporu, verileri form\u00fcl girmek zorunda kalmadan farkl\u0131 \u015fekillerde yorumlaman\u0131za olanak tan\u0131yan dinamik bir tablodur. Pivot veri noktalar\u0131 aras\u0131ndaki ili\u015fkileri analiz etmek istedi\u011finizde i\u015fe yarar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"lazy  wp-image-2050 alignleft\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/4-300x83.png\" alt=\"4\" width=\"300\" height=\"155\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2050 alignleft\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/4-300x83.png\" alt=\"4\" width=\"300\" height=\"155\" \/><\/noscript><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"lazy  size-medium wp-image-2053 alignleft\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/6-300x155.png\" alt=\"6\" width=\"300\" height=\"155\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-2053 alignleft\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/6-300x155.png\" alt=\"6\" width=\"300\" height=\"155\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/6-300x155.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/6-600x310.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/6.png 664w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"lazy  size-medium wp-image-2055 alignleft\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/8-198x300.png\" alt=\"8\" width=\"198\" height=\"300\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-2055 alignleft\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/8-198x300.png\" alt=\"8\" width=\"198\" height=\"300\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/8-198x300.png 198w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/8.png 239w\" sizes=\"(max-width: 198px) 100vw, 198px\" \/><\/noscript><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/rere.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/rere.png\" alt=\"rere\" width=\"178\" height=\"101\" class=\"lazy alignnone size-full wp-image-2252\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/rere.png\" alt=\"rere\" width=\"178\" height=\"101\" class=\"alignnone size-full wp-image-2252\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u0130simler i\u00e7in Report Filter :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-2058\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/9-236x300.png\" alt=\"9\" width=\"236\" height=\"300\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2058\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/9-236x300.png\" alt=\"9\" width=\"236\" height=\"300\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/9-236x300.png 236w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/9.png 242w\" sizes=\"(max-width: 236px) 100vw, 236px\" \/><\/noscript><\/p>\n<p>Meslekler i\u00e7in<em> Row Labels <\/em>yaparsak<em> :<\/em><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-2060\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/10.png\" alt=\"10\" width=\"135\" height=\"83\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2060\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/02\/10.png\" alt=\"10\" width=\"135\" height=\"83\" \/><\/noscript><\/a> \u015feklinde gelir.<\/p>\n<p>&nbsp;<\/p>\n<p><em>Umar\u0131m herkes i\u00e7in yararl\u0131 olmu\u015ftur, herkese Big Data&#8217;l\u0131 g\u00fcnler \ud83d\ude42<\/em><\/p>","protected":false},"excerpt":{"rendered":"<p>Herkese merhaba,\u00a0bu yaz\u0131m da\u00a0sizlere di\u011fer yaz\u0131lar\u0131m\u0131n devam\u0131 niteli\u011finde IBM Cognos Report Studio ile ilgili \u00f6zellikleri anlatmaya\u00a0devam edece\u011fim. Bu k\u0131sma ge\u00e7meden \u00f6nce di\u011fer yaz\u0131lar\u0131ma\u00a0g\u00f6z atman\u0131z\u0131 tavsiye ederim. Report Studio Properties Penceresi&#8217;nde Neler Var? IBM Cognos Margin Nedir? \u0130ki objenin aras\u0131n\u0131 a\u00e7ar. IBM Cognos Size &amp; Overflow Nedir? Barlar\u0131n aral\u0131klar\u0131n\u0131\u00a0belirler . IBM Cognos Table Properties Nedir? Fixed [&hellip;]<\/p>","protected":false},"author":12,"featured_media":1778,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[203],"tags":[191,192,199,200,201,202],"class_list":["post-2040","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-is-zekasi","tag-cognos","tag-ibm","tag-ibm-cognos","tag-is-zekasi","tag-report","tag-studio"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>IBM Cognos Report Studio&#039;nun \u00d6zellikleri - Koddit<\/title>\n<meta name=\"description\" content=\"IBM Cognos Report Studio&#039;nun \u00f6zelliklerini bu yaz\u0131m\u0131zda resimli anlat\u0131mla a\u00e7\u0131kl\u0131yoruz.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.koddit.com\/en\/is-zekasi\/ibm-cognos-ozellikler\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"IBM Cognos Report Studio&#039;nun \u00d6zellikleri - Koddit\" \/>\n<meta property=\"og:description\" content=\"IBM Cognos Report Studio&#039;nun \u00f6zelliklerini bu yaz\u0131m\u0131zda resimli anlat\u0131mla a\u00e7\u0131kl\u0131yoruz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.koddit.com\/en\/is-zekasi\/ibm-cognos-ozellikler\/\" \/>\n<meta property=\"og:site_name\" content=\"Koddit\" \/>\n<meta property=\"article:published_time\" content=\"2015-02-17T19:57:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-02-18T06:37:30+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/IBMCognosLogo4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"813\" \/>\n\t<meta property=\"og:image:height\" content=\"248\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Koddit\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Koddit\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/\"},\"author\":{\"name\":\"Koddit\",\"@id\":\"https:\/\/blog.koddit.com\/#\/schema\/person\/518a908da35b6c3549d25a0bda7a1035\"},\"headline\":\"IBM Cognos Report Studio&#8217;nun \u00d6zellikleri\",\"datePublished\":\"2015-02-17T19:57:28+00:00\",\"dateModified\":\"2015-02-18T06:37:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/\"},\"wordCount\":1576,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/blog.koddit.com\/#organization\"},\"keywords\":[\"cognos\",\"ibm\",\"ibm cognos\",\"i\u015f zekas\u0131\",\"report\",\"studio\"],\"articleSection\":[\"\u0130\u015f Zekas\u0131\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/\",\"url\":\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/\",\"name\":\"IBM Cognos Report Studio'nun \u00d6zellikleri - Koddit\",\"isPartOf\":{\"@id\":\"https:\/\/blog.koddit.com\/#website\"},\"datePublished\":\"2015-02-17T19:57:28+00:00\",\"dateModified\":\"2015-02-18T06:37:30+00:00\",\"description\":\"IBM Cognos Report Studio'nun \u00f6zelliklerini bu yaz\u0131m\u0131zda resimli anlat\u0131mla a\u00e7\u0131kl\u0131yoruz.\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/blog.koddit.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IBM Cognos Report Studio&#8217;nun \u00d6zellikleri\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.koddit.com\/#website\",\"url\":\"https:\/\/blog.koddit.com\/\",\"name\":\"Koddit\",\"description\":\"Blog\",\"publisher\":{\"@id\":\"https:\/\/blog.koddit.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.koddit.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.koddit.com\/#organization\",\"name\":\"Koddit\",\"url\":\"https:\/\/blog.koddit.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blog.koddit.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2023\/04\/koddit-logo.png\",\"contentUrl\":\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2023\/04\/koddit-logo.png\",\"width\":\"176\",\"height\":\"65\",\"caption\":\"Koddit\"},\"image\":{\"@id\":\"https:\/\/blog.koddit.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.koddit.com\/#\/schema\/person\/518a908da35b6c3549d25a0bda7a1035\",\"name\":\"Koddit\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blog.koddit.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b61761f4f382d0c7491378564c2c447a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b61761f4f382d0c7491378564c2c447a?s=96&d=mm&r=g\",\"caption\":\"Koddit\"},\"description\":\"Koddit Yaz\u0131l\u0131m ve Dan\u0131\u015fmanl\u0131k info@koddit.com\",\"sameAs\":[\"https:\/\/blog.koddit.com\"],\"url\":\"https:\/\/blog.koddit.com\/en\/author\/koddit\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"IBM Cognos Report Studio'nun \u00d6zellikleri - Koddit","description":"IBM Cognos Report Studio'nun \u00f6zelliklerini bu yaz\u0131m\u0131zda resimli anlat\u0131mla a\u00e7\u0131kl\u0131yoruz.","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:\/\/blog.koddit.com\/en\/is-zekasi\/ibm-cognos-ozellikler\/","og_locale":"en_US","og_type":"article","og_title":"IBM Cognos Report Studio'nun \u00d6zellikleri - Koddit","og_description":"IBM Cognos Report Studio'nun \u00f6zelliklerini bu yaz\u0131m\u0131zda resimli anlat\u0131mla a\u00e7\u0131kl\u0131yoruz.","og_url":"https:\/\/blog.koddit.com\/en\/is-zekasi\/ibm-cognos-ozellikler\/","og_site_name":"Koddit","article_published_time":"2015-02-17T19:57:28+00:00","article_modified_time":"2015-02-18T06:37:30+00:00","og_image":[{"width":813,"height":248,"url":"http:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/IBMCognosLogo4.png","type":"image\/png"}],"author":"Koddit","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Koddit","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/#article","isPartOf":{"@id":"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/"},"author":{"name":"Koddit","@id":"https:\/\/blog.koddit.com\/#\/schema\/person\/518a908da35b6c3549d25a0bda7a1035"},"headline":"IBM Cognos Report Studio&#8217;nun \u00d6zellikleri","datePublished":"2015-02-17T19:57:28+00:00","dateModified":"2015-02-18T06:37:30+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/"},"wordCount":1576,"commentCount":1,"publisher":{"@id":"https:\/\/blog.koddit.com\/#organization"},"keywords":["cognos","ibm","ibm cognos","i\u015f zekas\u0131","report","studio"],"articleSection":["\u0130\u015f Zekas\u0131"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/","url":"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/","name":"IBM Cognos Report Studio'nun \u00d6zellikleri - Koddit","isPartOf":{"@id":"https:\/\/blog.koddit.com\/#website"},"datePublished":"2015-02-17T19:57:28+00:00","dateModified":"2015-02-18T06:37:30+00:00","description":"IBM Cognos Report Studio'nun \u00f6zelliklerini bu yaz\u0131m\u0131zda resimli anlat\u0131mla a\u00e7\u0131kl\u0131yoruz.","breadcrumb":{"@id":"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-ozellikler\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/blog.koddit.com\/"},{"@type":"ListItem","position":2,"name":"IBM Cognos Report Studio&#8217;nun \u00d6zellikleri"}]},{"@type":"WebSite","@id":"https:\/\/blog.koddit.com\/#website","url":"https:\/\/blog.koddit.com\/","name":"Koddit","description":"Blog","publisher":{"@id":"https:\/\/blog.koddit.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.koddit.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/blog.koddit.com\/#organization","name":"Koddit","url":"https:\/\/blog.koddit.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog.koddit.com\/#\/schema\/logo\/image\/","url":"https:\/\/blog.koddit.com\/wp-content\/uploads\/2023\/04\/koddit-logo.png","contentUrl":"https:\/\/blog.koddit.com\/wp-content\/uploads\/2023\/04\/koddit-logo.png","width":"176","height":"65","caption":"Koddit"},"image":{"@id":"https:\/\/blog.koddit.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/blog.koddit.com\/#\/schema\/person\/518a908da35b6c3549d25a0bda7a1035","name":"Koddit","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog.koddit.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b61761f4f382d0c7491378564c2c447a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b61761f4f382d0c7491378564c2c447a?s=96&d=mm&r=g","caption":"Koddit"},"description":"Koddit Yaz\u0131l\u0131m ve Dan\u0131\u015fmanl\u0131k info@koddit.com","sameAs":["https:\/\/blog.koddit.com"],"url":"https:\/\/blog.koddit.com\/en\/author\/koddit\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/posts\/2040"}],"collection":[{"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/comments?post=2040"}],"version-history":[{"count":0,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/posts\/2040\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/media\/1778"}],"wp:attachment":[{"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/media?parent=2040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/categories?post=2040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/tags?post=2040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}