{"id":1566,"date":"2014-11-23T23:32:27","date_gmt":"2014-11-23T21:32:27","guid":{"rendered":"http:\/\/koddit.com\/?p=1566"},"modified":"2015-02-17T22:02:42","modified_gmt":"2015-02-17T20:02:42","slug":"ibm-cognos-raporlama","status":"publish","type":"post","link":"https:\/\/blog.koddit.com\/en\/is-zekasi\/ibm-cognos-raporlama\/","title":{"rendered":"IBM Cognos ile Raporlama Nas\u0131l Yap\u0131l\u0131r?"},"content":{"rendered":"<p>Herkese merhaba sizlere bu yaz\u0131mda BI sekt\u00f6r\u00fcn\u00fcn tool&#8217;lar\u0131 aras\u0131nda kendini farkettiren bir tool olan\u00a0<em><strong>IBM COGNOS<\/strong> <\/em>&#8216;tan bahsede\u011fim. Bilindi\u011fi gibi her sekt\u00f6r\u00fcn kendine has dinamikleri vard\u0131r, bu nedenle de b\u00fcy\u00fck datan\u0131n kullan\u0131m\u0131 sekt\u00f6rden sekt\u00f6re farkl\u0131l\u0131k g\u00f6sterebilir.<\/p>\n<p>Veri miktarlar\u0131 art\u0131k sadece sosyal medya ve internet \u00fczerinde b\u00fcy\u00fcm\u00fcyor, ayn\u0131 zamanda kurumlar\u0131n sahip olduklar\u0131 veri miktarlar\u0131 da giderek art\u0131yor. Yap\u0131lan ara\u015ft\u0131rmalara g\u00f6re, b\u00fcy\u00fck verilerden en \u00e7ok etkilenecek sekt\u00f6r\u00fcn finans ve sigortac\u0131l\u0131k sekt\u00f6r\u00fc olaca\u011f\u0131 belirtiliyor. Sigortac\u0131l\u0131k\/Emeklilik sekt\u00f6r\u00fcnde Raporlama ve Analiz a\u00e7\u0131s\u0131ndan de\u011ferlendirilirken di\u011fer sekt\u00f6rlerden ayr\u0131 ve \u00f6zel ele al\u0131nmas\u0131 gerekti\u011fini d\u00fc\u015f\u00fcn\u00fcyorum.<\/p>\n<p>Ben de bir sigortac\u0131l\u0131k \u015firketinde\u00a0\u00e7al\u0131\u015ft\u0131\u011f\u0131m i\u00e7in <em><strong>IBM Cogno<\/strong><strong>s<\/strong><\/em>&#8216;u anlat\u0131rken ald\u0131\u011f\u0131m ekran g\u00f6r\u00fcnt\u00fclerinde s\u0131k\u00e7a<em>\u00a0poli\u00e7e, zeyl, poltantar, polbastar, tantar, polid<\/em> gibi ifadelere rastlayabilirsiniz; fakat\u00a0bunlar\u0131n anlam\u0131n\u0131 bilmeniz tabi ki de gerekmiyor \ud83d\ude42<\/p>\n<p>\u015eimdi IBM in Cognos&#8217;u sat\u0131n almas\u0131 ile girmi\u015f oldu\u011fu \u0130\u015f Zekas\u0131 alan\u0131na neler getirdi\u011fini bu yaz\u0131mda hep birlikte inceleyelim.<\/p>\n<p>&nbsp;<\/p>\n<h1>IBM\u00a0Cognos Report Studio<\/h1>\n<div id=\"attachment_1854\" style=\"width: 661px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/qq.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1854\" class=\"lazy wp-image-1854\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/qq.png\" alt=\"qq\" width=\"651\" height=\"402\" \/><p id=\"caption-attachment-1854\" class=\"wp-caption-text\"><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1854\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/qq.png\" alt=\"qq\" width=\"651\" height=\"402\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/qq.png 904w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/qq-300x185.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/qq-600x370.png 600w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/noscript><\/a> Report Studio Genel G\u00f6r\u00fcn\u00fcm\u00fc<\/p><\/div>\n<p style=\"text-align: center\"><strong>\u00a0<\/strong><\/p>\n<h3>Content Pane<\/h3>\n<p><strong>Source \u00a0\u00a0<a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-1582\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/13.png\" alt=\"1\" width=\"72\" height=\"56\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1582\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/13.png\" alt=\"1\" width=\"72\" height=\"56\" \/><\/noscript><\/a><\/strong>\u00a0 \u00a0Raporda kullan\u0131lacak veya hesaplanacak olan, i\u00e7inde data item&#8217;lar\u0131 i\u00e7eren paketlerden olu\u015fan k\u0131s\u0131m diyebiliriz.<\/p>\n<p><strong> Data Items <a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/21.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-1583\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/21.png\" alt=\"2\" width=\"65\" height=\"60\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1583\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/21.png\" alt=\"2\" width=\"65\" height=\"60\" \/><\/noscript><\/a><\/strong>Raporda calculationlar\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. (If\/Else &#8211; Case\/When)<\/p>\n<p><strong>Toolbox <a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-1584\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/3.png\" alt=\"3\" width=\"77\" height=\"61\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1584\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/3.png\" alt=\"3\" width=\"77\" height=\"61\" \/><\/noscript><\/a><\/strong>Rapora ekleyebilece\u011fimiz text, block, char, crosstab gibi nesneleri i\u00e7erir.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<h3>Properties Pane<\/h3>\n<p><em><strong>Explorer Bar<\/strong><\/em><\/p>\n<ul>\n<li><strong>Page explorer<\/strong> \u00a0<a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-1585\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/5.png\" alt=\"5\" width=\"72\" height=\"64\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1585\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/5.png\" alt=\"5\" width=\"72\" height=\"64\" \/><\/noscript><\/a>Olu\u015fturaca\u011f\u0131m\u0131z raporun ka\u00e7 sayfadan olu\u015fmas\u0131n\u0131 istiyorsak\u00a0o kadar page ekleyebiliriz.<\/li>\n<li><strong>Query explorer<\/strong> \u00a0<a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-1586\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/6.png\" alt=\"6\" width=\"65\" height=\"57\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1586\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/6.png\" alt=\"6\" width=\"65\" height=\"57\" \/><\/noscript><\/a>Query&#8217;lerimizi olu\u015fturup, raporun hangi Query&#8217;den beslenece\u011fine karar veririz.<\/li>\n<li><strong>Condition explorer<\/strong>\u00a0<a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-1587\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/7.png\" alt=\"7\" width=\"62\" height=\"58\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1587\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/7.png\" alt=\"7\" width=\"62\" height=\"58\" \/><\/noscript><\/a>Bu k\u0131sm\u0131 a\u015fa\u011f\u0131da anlataca\u011f\u0131m &#8220;<strong>no found ReportOutput&#8221; <\/strong>\u00f6rne\u011fi ile a\u00e7\u0131klayaca\u011f\u0131m.<strong>\u00a0<\/strong><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3>Data Source \u0130konlar\u0131<\/h3>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/aa.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignleft wp-image-1869\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/aa-1024x349.png\" alt=\"aa\" width=\"1197\" height=\"409\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-1869\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/aa-1024x349.png\" alt=\"aa\" width=\"1197\" height=\"409\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/aa-1024x349.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/aa-300x102.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/aa-600x204.png 600w\" sizes=\"(max-width: 1197px) 100vw, 1197px\" \/><\/noscript><\/a><br \/>\nRaporumuzu \u00e7al\u0131\u015ft\u0131rmadan \u00f6nce syntax hatas\u0131 olup olmad\u0131\u011f\u0131na bakmak i\u00e7in rapor VALIDATE <a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/111.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1588\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/111.png\" alt=\"11\" width=\"74\" height=\"58\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1588\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/111.png\" alt=\"11\" width=\"74\" height=\"58\" \/><\/noscript><\/a>\u00a0edilir.\u00a0Raporu \u00e7al\u0131\u015ft\u0131rmak i\u00e7in \u00e7al\u0131\u015ft\u0131raca\u011f\u0131m\u0131z sayfay\u0131 se\u00e7ip RUN diyoruz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/a11.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy size-medium wp-image-1919 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\/2014\/11\/a11-300x119.png\" alt=\"a1\" width=\"300\" height=\"119\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1919 aligncenter\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/a11-300x119.png\" alt=\"a1\" width=\"300\" height=\"119\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/a11-300x119.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/a11-600x238.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/a11.png 718w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3>Chart<\/h3>\n<p><em><strong>IBM COGNOS<\/strong><\/em> report studio da kullanabilece\u011finiz birden fazla chart tipi vard\u0131r: \u00a0column, bar, area, line charts vs..<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/121.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignleft wp-image-1589 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\/2014\/11\/121-300x222.png\" alt=\"12\" width=\"300\" height=\"222\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-1589 size-medium\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/121-300x222.png\" alt=\"12\" width=\"300\" height=\"222\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/121-300x222.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/121-1024x759.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/121-600x444.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/121.png 1214w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a> <a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/131.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignleft wp-image-1590\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/131-300x220.png\" alt=\"13\" width=\"185\" height=\"136\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-1590\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/131-300x220.png\" alt=\"13\" width=\"185\" height=\"136\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/131-300x220.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/131.png 516w\" sizes=\"(max-width: 185px) 100vw, 185px\" \/><\/noscript><\/a> <a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/14.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignleft wp-image-1591\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/14-300x225.png\" alt=\"14\" width=\"183\" height=\"137\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-1591\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/14-300x225.png\" alt=\"14\" width=\"183\" height=\"137\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/14-300x225.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/14.png 444w\" sizes=\"(max-width: 183px) 100vw, 183px\" \/><\/noscript><\/a><\/p>\n<p style=\"text-align: center\"><em><strong>\u00a0<\/strong><\/em><\/p>\n<h2 style=\"text-align: left\"><\/h2>\n<h2 style=\"text-align: left\"><\/h2>\n<h2 style=\"text-align: left\"><\/h2>\n<h2 style=\"text-align: left\"><\/h2>\n<h2 style=\"text-align: left\"><\/h2>\n<h2 style=\"text-align: left\"><\/h2>\n<h2 style=\"text-align: left\"><\/h2>\n<h2 style=\"text-align: left\">Rapora ba\u015flarken<\/h2>\n<p>\u00d6ncelikle Launch -&gt; Report Studio se\u00e7iyoruz . Daha sonra \u00e7\u0131kan ekranda e\u011fer bo\u015f bir sayfa olu\u015fturmak istiyorsak Blank ya da raporumuzun list \u015feklinde g\u00f6r\u00fcnmesini istiyorsak list se\u00e7ene\u011fini se\u00e7iyoruz.<\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/72.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignleft wp-image-1614\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/72.png\" alt=\"7\" width=\"435\" height=\"237\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-1614\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/72.png\" alt=\"7\" width=\"435\" height=\"237\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/72.png 537w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/72-300x163.png 300w\" sizes=\"(max-width: 435px) 100vw, 435px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>E\u011fer ad-hoc raporlama (s\u00fcr\u00fckle b\u0131rak)\u00a0yapacaksak\u00a0, \u00a0kullanaca\u011f\u0131m\u0131z paketi belirleyip se\u00e7ti\u011fimiz objeleri raporumuza s\u00fcr\u00fckl\u00fcyoruz. Daha sonra bu raporumuzu kaydetmek istedi\u011fimizde IBM Cognos&#8217;un bizim i\u00e7in belirledi\u011fi iki tab ile\u00a0kar\u015f\u0131la\u015f\u0131r\u0131z. Birincisi Public Folder ikincisi My Folder&#8217;d\u0131r. E\u011fer geli\u015ftirdi\u011fimiz raporun herkes taraf\u0131ndan g\u00f6r\u00fcnmesini istiyorsak Public&#8217;e , sadece kendi \u00e7al\u0131\u015fmalar\u0131m\u0131z aras\u0131nda kalmas\u0131n\u0131 istiyorsak My Folder&#8217;a raporumuzu kaydedebiliriz.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong><em>Ad-Hoc Rapor \u00d6rne\u011fi :<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/81.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignleft wp-image-1616\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/81-1024x628.png\" alt=\"8\" width=\"608\" height=\"373\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-1616\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/81-1024x628.png\" alt=\"8\" width=\"608\" height=\"373\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/81-1024x628.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/81-300x184.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/81-600x368.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/81.png 1212w\" sizes=\"(max-width: 608px) 100vw, 608px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Daha sonra raporumuzu direkt \u00e7al\u0131\u015ft\u0131raca\u011f\u0131m\u0131z gibi a\u015fag\u0131daki formatlarla da \u00e7al\u0131\u015ft\u0131rabiliriz. (Html,Pdf,Csv&#8230; )<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignright wp-image-1618 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\/2014\/11\/101.png\" alt=\"10\" width=\"96\" height=\"96\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-1618 size-full\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/101.png\" alt=\"10\" width=\"96\" height=\"96\" \/><\/noscript><\/p>\n<p>S\u00fcr\u00fckleyip b\u0131rakt\u0131\u011f\u0131m\u0131z alanlar arka tarafta bir Query objesi i\u00e7inde tutulur. \u00a0Yani biz raporu list \u015feklinde olu\u015ftur dersek arka tarafta kendisi bu query&#8217;i otomatik olarak olu\u015fturur;\u00a0 ancak raporumuzu blank \u015feklinde olu\u015fturursak bizim bu query objesini s\u00fcr\u00fckleyip i\u00e7erisine raporda kullanaca\u011f\u0131m\u0131z item&#8217;larla doldurmam\u0131z gerekir. \u00c7\u00fcnk\u00fc raporlar bu query&#8217;lerden beslenir. Bu query&#8217;ler \u00fczerinden join \/ union gibi tablo birle\u015ftirme i\u015flemleri de\u00a0yap\u0131labilmektedir.<\/p>\n<p><em>Rapor olu\u015ftururken izleyece\u011fimiz ad\u0131mlar:<\/em><\/p>\n<ol>\n<li>Query Explorer&#8217;dan bir query objesi se\u00e7ip rapora aktar\u0131l\u0131r.<\/li>\n<li>Source k\u0131sm\u0131ndan raporda kullan\u0131lacak objeler\u00a0belirlenip query&#8217;nin i\u00e7ine al\u0131n\u0131r.<\/li>\n<li>Page Explorer&#8217;dan raporda kullan\u0131lacak sayfaya gelip,\u00a0 data items sekmesinde bulunan Querymizin i\u00e7inde ki data item&#8217;lar\u0131 raporumuza s\u00fcr\u00fckleyip b\u0131rak\u0131yoruz.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/91.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1617 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\/2014\/11\/91-1024x583.png\" alt=\"9\" width=\"798\" height=\"454\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1617 size-large\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/91-1024x583.png\" alt=\"9\" width=\"798\" height=\"454\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/91-1024x583.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/91-300x170.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/91-600x341.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/91.png 1268w\" sizes=\"(max-width: 798px) 100vw, 798px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><em>\u015eimdi yukar\u0131da anlatt\u0131\u011f\u0131m\u0131z chart ve ad-hoc mant\u0131\u011f\u0131n\u0131 birle\u015ftiren \u00f6rnek \u00a0bir rapor haz\u0131rlayal\u0131m :<\/em><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/132.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignleft wp-image-1621\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/132.png\" alt=\"13\" width=\"634\" height=\"399\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-1621\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/132.png\" alt=\"13\" width=\"634\" height=\"399\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/132.png 1023w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/132-300x188.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/132-600x377.png 600w\" sizes=\"(max-width: 634px) 100vw, 634px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center\"><strong>\u00a0<\/strong><\/p>\n<h3>Prompt Page Yap\u0131s\u0131<\/h3>\n<div id=\"attachment_1632\" style=\"width: 284px\" class=\"wp-caption alignleft\"><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/221.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1632\" class=\"lazy wp-image-1632 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\/2014\/11\/221-274x300.png\" alt=\"22\" width=\"274\" height=\"300\" \/><p id=\"caption-attachment-1632\" class=\"wp-caption-text\"><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1632 size-medium\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/221-274x300.png\" alt=\"22\" width=\"274\" height=\"300\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/221-274x300.png 274w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/221.png 559w\" sizes=\"(max-width: 274px) 100vw, 274px\" \/><\/noscript><\/a> Date Prompt ve Value Prompt<\/p><\/div>\n<p>&nbsp;<\/p>\n<p>Rapora bir Prompt page eklenerek iki tarih aras\u0131nda bir se\u00e7im yap\u0131lmas\u0131 istenmi\u015ftir. Ve Value Prompt ile de Zeyl Tipinin se\u00e7ilmesi istenmi\u015ftir. Bunun i\u00e7in DATE PROMPT\u00a0, VALUE PROMPT ve\u00a0 bir \u00a0PROMPT BUTTON eklenmi\u015ftir.<\/p>\n<p>Promptlardan <strong>Date Prompt<\/strong>&#8216;un iki tarih aras\u0131ndaki de\u011ferleri getirece\u011fi i\u00e7in iki parametreye ihtiyac\u0131 vard\u0131r. Bunlara ?Tantar? ve ?Tantar1? \u015feklinde parametreler atarsak, Details Filters k\u0131sm\u0131nda tarih aral\u0131\u011f\u0131n\u0131n se\u00e7ti\u011fimiz de\u011fi\u015fkenler aras\u0131nda olmas\u0131 i\u00e7in query\u2019nin Expression Defination k\u0131sm\u0131na \u00a0\u201c[TANTAR] between ?Tantar? and ?Tantar1?\u201d ifadesi yaz\u0131l\u0131r.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/53.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1790 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\/2014\/11\/53-1024x403.png\" alt=\"5\" width=\"798\" height=\"314\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1790 size-large\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/53-1024x403.png\" alt=\"5\" width=\"798\" height=\"314\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/53-1024x403.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/53-300x118.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/53-600x236.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/53.png 1509w\" sizes=\"(max-width: 798px) 100vw, 798px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignleft wp-image-1636\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/25.png\" alt=\"25\" width=\"271\" height=\"268\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-1636\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/25.png\" alt=\"25\" width=\"271\" height=\"268\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/25.png 471w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/25-300x296.png 300w\" sizes=\"(max-width: 271px) 100vw, 271px\" \/><\/noscript>Prompt page\u2019deki bir di\u011fer prompt <strong>Value Prompt<\/strong> olan ZEYLTIP :<\/p>\n<p>Zeyltiplerini \u00e7ekip, kullan\u0131c\u0131lar\u0131n bunlar\u0131n aras\u0131nda bir i\u015flem yapmas\u0131n\u0131 istedi\u011fimiz i\u00e7in bunu Query\u2019den beslemek durumunday\u0131z. Zeyl tipin properties \u00f6zelliklerinden kulland\u0131\u011f\u0131 Query\u2019nin Zeyl1 oldu\u011fu, kulland\u0131\u011f\u0131 de\u011ferin ZEYLTIP oldu\u011fu, parametre olarak atad\u0131\u011f\u0131m\u0131z de\u011ferin ?pzeyltip? oldu\u011funu, birden fazla se\u00e7me i\u015fleminin ger\u00e7ek olmas\u0131 i\u00e7in Multi-Select \u00f6zelli\u011finin YES olmas\u0131 gibi \u00f6zelliklere dikkat edilmelidir.<\/p>\n<p>Ve burada birden fazla Zeyltip se\u00e7mek i\u00e7in [T_ZEYL].[ZEYLTIP] in (?pzeyltip?) \u201cin\u201d komutunu kulland\u0131k, sadece tek bir de\u011fer se\u00e7mesini isteseydik \u201c=\u201d ifadesini kullanacakt\u0131k.<\/p>\n<p>&nbsp;<\/p>\n<p>Raporumuzu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131zda ilk \u00e7al\u0131\u015facak sayfa her zaman varsa Prompt Page\u2019dir.<\/p>\n<div id=\"attachment_1637\" style=\"width: 333px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1637\" class=\"lazy wp-image-1637\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/26.png\" alt=\"26\" width=\"323\" height=\"225\" \/><p id=\"caption-attachment-1637\" class=\"wp-caption-text\"><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1637\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/26.png\" alt=\"26\" width=\"323\" height=\"225\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/26.png 730w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/26-300x208.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/26-600x417.png 600w\" sizes=\"(max-width: 323px) 100vw, 323px\" \/><\/noscript> Haz\u0131rlam\u0131\u015f oldu\u011fumuz prompt ekranlar\u0131n\u0131n g\u00f6r\u00fcn\u00fcm\u00fc<\/p><\/div>\n<p>&nbsp;<\/p>\n<p><strong><em>Genel Notlar :<\/em><\/strong><\/p>\n<p>\u015eimdi sizlere rapor geli\u015ftirirken kulland\u0131\u011f\u0131m birka\u00e7 filtre ve calculationdan bahsedece\u011fim . A\u015fa\u011f\u0131da anlataca\u011f\u0131m\u0131z filtrelerimiz ile ilgili \u00f6zellikleri\u00a0Detail Filters k\u0131sm\u0131na ekliyoruz.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1772\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/www.png\" alt=\"www\" width=\"867\" height=\"94\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1772\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/www.png\" alt=\"www\" width=\"867\" height=\"94\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/www.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/www-300x32.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/www-600x65.png 600w\" sizes=\"(max-width: 867px) 100vw, 867px\" \/><\/noscript><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: left\">\u00d6rnek Kod Par\u00e7ac\u0131klar\u0131<\/h2>\n<ol>\n<li>\u00d6rne\u011fin y\u0131lbaz\u0131nda bir chart olu\u015fturacaksak query&#8217;imize bir Dataitem ekleyip Expression Defination k\u0131sm\u0131na to_char ([Tarih] , &#8216;YYYY&#8217;) ay baz\u0131nda olu\u015fturmak istersek de to_char ([Tarih] , &#8216;MM&#8217;) yazabiliriz.<\/li>\n<li>Ocak ay\u0131n\u0131n ilk g\u00fcn\u00fc ile bulundu\u011fum ay\u0131n son g\u00fcn\u00fcn 2 ay \u00f6ncesi gibi bir filtre\u00a0\u00a0 [POLTANTAR] Between to_date(&#8216;01.01.2014&#8242;;&#8217;DD.MM.YYYY&#8217;) And to_date(_add_months (_last_of_month ({sysdate});-2);&#8217;DD.MM.YYYY&#8217;)<\/li>\n<li>Bu ay\u0131n ba\u015flang\u0131c\u0131 ve bulundu\u011fum g\u00fcn\u00fc [POLTANTAR] Between to_date(&#8216;01.01.2014&#8242;;&#8217;DD.MM.YYYY&#8217;) And to_date ({sysdate}; \u2018DD.MM.YYYY\u2019) \u015feklinde ifade edebiliriz. (Raporda Prompt kullanmadan da belirledi\u011fimiz iki tarihi raporumuza g\u00f6m\u00fcp filtre olarak kullanabiliriz).<\/li>\n<li>\u00a0Row Number Kullan\u0131m\u0131 : count ( distinct [OrderDetailQuantity]\u00a0)<\/li>\n<li>\u00a0[TARIHI] between &#8216;01.01.2014&#8217; and &#8216;30.06.2014&#8217; \u015feklinde filtre olarak belirledi\u011fimizi iki tarih aral\u0131\u011f\u0131n\u0131 raporumuza g\u00f6mebiliriz.<\/li>\n<li>[POLTANTAR] = to_date( &#8216;01.01.2012&#8217;;&#8217;DD.MM.YYYY&#8217;) Direkt bir tarihe e\u015fitleyebiliriz.<\/li>\n<li>[S\u00f6zleme Adedi]&gt;=5\u00a0 filtrelerimizde mant\u0131ksal operat\u00f6rler kullanabiliriz.<\/li>\n<li>[POLBITTAR]=({ sysdate }) sysdate in i\u00e7inde saati de ald\u0131\u011f\u0131 i\u00e7in, bunu trunc komutu ile kesmemiz gerekir . [POLBITTAR]= to_date(trunc({ sysdate }) )<\/li>\n<li>[POLID] like &#8216;14%&#8217; pol\u0131d 14 ile baslayanlar\u0131 bize getir diyebiliriz.<\/li>\n<li>Cognosta&#8217;da if\/else case\/when \u015feklinde de sql komutlar\u0131 vard\u0131r. Bunlar\u0131 yeni bir Dataitem ekleyip i\u00e7erisinde istedi\u011fimiz komutlar\u0131 \u00e7al\u0131\u015ft\u0131rabiliriz. Case when trunc([CRTTAR])=trunc([UPDTAR]) then &#8216;Yeni&#8217; else &#8216;Update&#8217; end<\/li>\n<li>Yeni bir item olu\u015ftur : [ADI]+&#8217; &#8216;+[SOYADI] isim ve soyad bu \u015fekilde birle\u015ftirilebilir.<\/li>\n<li>Sat\u0131r Say\u0131s\u0131 : count([POLICENO])<\/li>\n<li>Kay\u0131t Say\u0131s\u0131 : count(rows)<\/li>\n<li>\u00a0\u00a0If ([Police]=&#8217;GB&#8217;) Then (&#8216;AA&#8217;)Else If ([Police]=&#8217;IG&#8217;) Then (&#8216;BB&#8217;) Else(&#8216;Individual&#8217;)<\/li>\n<li>Ay ve y\u0131l baz\u0131nda y\u00fczde hesab\u0131 i\u00e7in \u00a0&#8220;percentage([count] for [Y\u0131l]) \u00a0ve \u00a0percentage([count] for [Ay])<\/li>\n<li>Bir \u00f6nceki y\u0131l : {sysdate}- 365<\/li>\n<li>If ([Y\u0131l]=&#8217;2013&#8242;) Then (&#8216; &#8216;) Else ([Ay])\u00a0\u00a0 &#8211; 2013&#8217;ten farkl\u0131 olan aylar<\/li>\n<li>Crostab ile olu\u015fturulan raporun SQL\u2019i al\u0131nmamaktad\u0131r.<\/li>\n<li>Yine data itemlar\u0131m\u0131z i\u00e7ine PL\/SQL developerda olu\u015fturdu\u011fumuz fonksiyonlar\u0131da g\u00f6rebiliriz ve bu fonksiyonlar\u0131 item olarak kullanabiliriz.\u00a0\u00a0\u00a0\u00a0fonksiyon_adi (p.polid , trunc ({sysdate}) ) burada fonksiyonumuzun bizden 2 parametre bekledi\u011fini g\u00f6rebiliyoruz birincisi bir id di\u011feri ise bir tarih. Bunlara uygun 2 parametremezi \u00a0querylerimiz i\u00e7inde ki itemlardan ekleyebiliyoruz.<\/li>\n<li>Raporlarda g\u00f6rselli\u011fin bazen raporun i\u00e7eri\u011finden daha \u00f6nemli olabilece\u011fini l\u00fctfen unutmayal\u0131m. Genel g\u00f6rsellik i\u00e7in izledi\u011fim yol : <em>\u00d6ncelikle kendiniz i\u00e7in raporda kullanaca\u011f\u0131n\u0131z bir template haz\u0131rlayabilirsiniz<\/em> .<\/li>\n<\/ol>\n<div id=\"attachment_1606\" style=\"width: 759px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/22.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1606\" class=\"lazy wp-image-1606\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/22.png\" alt=\"2\" width=\"749\" height=\"194\" \/><p id=\"caption-attachment-1606\" class=\"wp-caption-text\"><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1606\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/22.png\" alt=\"2\" width=\"749\" height=\"194\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/22.png 1244w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/22-300x77.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/22-1024x265.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/22-600x155.png 600w\" sizes=\"(max-width: 749px) 100vw, 749px\" \/><\/noscript><\/a> Create Header<\/p><\/div>\n<div id=\"attachment_1610\" style=\"width: 331px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/4.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1610\" class=\"lazy wp-image-1610\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/4-300x169.png\" alt=\"4\" width=\"321\" height=\"181\" \/><p id=\"caption-attachment-1610\" class=\"wp-caption-text\"><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1610\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/4-300x169.png\" alt=\"4\" width=\"321\" height=\"181\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/4-300x169.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/4-1024x580.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/4-600x339.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/4.png 1195w\" sizes=\"(max-width: 321px) 100vw, 321px\" \/><\/noscript><\/a> Renk Ayarlar\u0131<\/p><\/div>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/65.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy aligncenter wp-image-1791 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\/2014\/11\/65-300x168.png\" alt=\"6\" width=\"300\" height=\"168\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1791 size-medium\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/65-300x168.png\" alt=\"6\" width=\"300\" height=\"168\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/65-300x168.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/65-600x336.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/65.png 1024w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<div id=\"attachment_1793\" style=\"width: 310px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/86.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1793\" class=\"lazy wp-image-1793 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\/2014\/11\/86-300x107.png\" alt=\"8\" width=\"300\" height=\"107\" \/><p id=\"caption-attachment-1793\" class=\"wp-caption-text\"><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1793 size-medium\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/86-300x107.png\" alt=\"8\" width=\"300\" height=\"107\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/86-300x107.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/86.png 387w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a> \u0130\u015fte Sonu\u00e7<\/p><\/div>\n<p>&nbsp;<\/p>\n<p>21. \u00a0\u00d6rne\u011fin Prompt ekran\u0131ndan se\u00e7ti\u011finiz de\u011ferlerin Page&#8217;de de g\u00f6r\u00fcnmesini istiyorsan\u0131z :<br \/>\nTable -&gt; Se\u00e7ilen de\u011fer :\u00a0 Text -&gt; Properties b\u00f6lmesinden Text Source &#8216;dan Source Type : Report Expression\u00a0 ve Report Expression\u00a0\u00a0&#8221; <em><strong>ParamDisplayValue<\/strong><\/em>(&#8216;ppolid&#8217;)&#8221;\u00a0 se\u00e7erek isted\u011fimiz poli\u00e7eleri ekranda g\u00f6r\u00fcnt\u00fcleyebiliriz.<\/p>\n<div id=\"attachment_1612\" style=\"width: 452px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/61.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1612\" class=\"lazy wp-image-1612 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\/2014\/11\/61.png\" alt=\"6\" width=\"442\" height=\"297\" \/><p id=\"caption-attachment-1612\" class=\"wp-caption-text\"><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1612 size-full\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/61.png\" alt=\"6\" width=\"442\" height=\"297\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/61.png 442w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/61-300x201.png 300w\" sizes=\"(max-width: 442px) 100vw, 442px\" \/><\/noscript><\/a> Properties<\/p><\/div>\n<div id=\"attachment_1613\" style=\"width: 497px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/71.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1613\" class=\"lazy wp-image-1613\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/71.png\" alt=\"7\" width=\"487\" height=\"151\" \/><p id=\"caption-attachment-1613\" class=\"wp-caption-text\"><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1613\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/71.png\" alt=\"7\" width=\"487\" height=\"151\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/71.png 636w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/71-300x92.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/71-600x185.png 600w\" sizes=\"(max-width: 487px) 100vw, 487px\" \/><\/noscript><\/a> Page G\u00f6r\u00fcn\u00fcm\u00fc<\/p><\/div>\n<p>&nbsp;<\/p>\n<p>22. Querylerle ilgili olan bir di\u011fer \u00f6zellik de<strong> ,\u00a0<\/strong><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/27.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy wp-image-1638\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/27.png\" alt=\"27\" width=\"386\" height=\"217\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1638\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/27.png\" alt=\"27\" width=\"386\" height=\"217\" \/><\/noscript><\/a><\/p>\n<p>Report studio\u2019da rapor haz\u0131rlarken Query Explorer penceresindeki t\u00fcm Query\u2019lerin <em><strong>Use Local Cache<\/strong><\/em>\u2019lerinin \u201cNO\u201d olmas\u0131na dikkat edilmelidir.\u00a0\u00c7\u00fcnk\u00fc bir raporun \u00e7al\u0131\u015fmas\u0131 tam olarak bitmeden onu kapat\u0131rsak, Cache o kayd\u0131n sonucunu tutar ve rapor \u00fczerinde bir de\u011fi\u015fiklik yap\u0131p tekrar \u00e7al\u0131\u015ft\u0131rmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131m\u0131zda bize cahce\u2019de tuttu\u011fu eski\u00a0sonucu getirir ve rapor \u00fczerinde yapt\u0131\u011f\u0131m\u0131z de\u011fi\u015fiklikleri g\u00f6remeyiz.<\/p>\n<p><em><strong>\u00a0<\/strong><\/em><\/p>\n<h3>JOIN<\/h3>\n<p>Querylerimiz aras\u0131nda Union , Join\u00a0gibi\u00a0 tablo birle\u015ftirme i\u015flemleri yapabiliriz demi\u015ftik . A\u015fa\u011f\u0131da yap\u0131lan \u00f6rnekte bir iki query aras\u0131nda yap\u0131lm\u0131\u015f bir \u00a0join i\u015flemi g\u00f6rebiliyoruz.<\/p>\n<div id=\"attachment_1624\" style=\"width: 920px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/161.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1624\" class=\"lazy wp-image-1624\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/161-1024x412.png\" alt=\"16\" width=\"910\" height=\"366\" \/><p id=\"caption-attachment-1624\" class=\"wp-caption-text\"><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1624\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/161-1024x412.png\" alt=\"16\" width=\"910\" height=\"366\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/161-1024x412.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/161-300x120.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/161-600x241.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/161.png 1320w\" sizes=\"(max-width: 910px) 100vw, 910px\" \/><\/noscript><\/a> Join \u00d6rne\u011fi<\/p><\/div>\n<p>Burada join i\u015fleminin \u00fczerine\u00a0t\u0131klad\u0131\u011f\u0131m\u0131zda hangi alanlar \u00fczerinden tablolar\u0131n joinlendi\u011fini g\u00f6rebiliriz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/171.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy wp-image-1625 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\/2014\/11\/171.png\" alt=\"17\" width=\"524\" height=\"394\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1625 aligncenter\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/171.png\" alt=\"17\" width=\"524\" height=\"394\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/171.png 832w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/171-300x225.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/171-600x451.png 600w\" sizes=\"(max-width: 524px) 100vw, 524px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3>UNION<\/h3>\n<p>Ayn\u0131 page\u2019de farkl\u0131 iki rapor istenip bunlar\u0131n\u00a0objeleri ayn\u0131 ama sadece kulland\u0131klar\u0131 filtreler farkl\u0131 oldu\u011fu zaman UNION ile raporumuzdaki query\u2019lerimizi birle\u015ftirebiliriz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/114.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1782\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/114-1024x498.png\" alt=\"1\" width=\"843\" height=\"410\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1782\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/114-1024x498.png\" alt=\"1\" width=\"843\" height=\"410\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/114-1024x498.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/114-300x145.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/114-600x291.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/114-249x120.png 249w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/114.png 1556w\" sizes=\"(max-width: 843px) 100vw, 843px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/ad.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1835\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/ad.png\" alt=\"ad\" width=\"853\" height=\"468\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1835\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/ad.png\" alt=\"ad\" width=\"853\" height=\"468\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/ad.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/ad-300x164.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/ad-600x329.png 600w\" sizes=\"(max-width: 853px) 100vw, 853px\" \/><\/noscript><\/a><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/29.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1783\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/29-1024x444.png\" alt=\"2\" width=\"860\" height=\"373\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1783\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/29-1024x444.png\" alt=\"2\" width=\"860\" height=\"373\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/29-1024x444.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/29-300x130.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/29-600x260.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/29.png 1784w\" sizes=\"(max-width: 860px) 100vw, 860px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3>SINGLETON nedir?<\/h3>\n<p>Rapordaki sat\u0131r say\u0131s\u0131n\u0131 hesaplamak i\u00e7in ROWNUMBER kullan\u0131laca\u011f\u0131 gibi SINGLETON\u2019da kullan\u0131labilir. Rapor Query\u2019sine bir dataitem at\u0131p , name k\u0131sm\u0131ndan ad\u0131n\u0131 Sat\u0131r Say\u0131s\u0131 olarak de\u011fi\u015ftirip, Expression k\u0131sm\u0131na count([POLID]) i\u015flemini yaz\u0131yoruz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1683\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q2-1024x276.png\" alt=\"q2\" width=\"898\" height=\"242\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1683\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q2-1024x276.png\" alt=\"q2\" width=\"898\" height=\"242\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q2-1024x276.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q2-300x81.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q2-600x162.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q2.png 1066w\" sizes=\"(max-width: 898px) 100vw, 898px\" \/><\/noscript><\/a><\/p>\n<p>Daha sonra Toolbox\u2019tan Page Explorer\u2019a\u00a0 SINGLETON ekleriz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1684\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q3.png\" alt=\"q3\" width=\"361\" height=\"327\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1684\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q3.png\" alt=\"q3\" width=\"361\" height=\"327\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q3.png 534w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q3-300x272.png 300w\" sizes=\"(max-width: 361px) 100vw, 361px\" \/><\/noscript><\/a>\u00a0\u00a0<a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q4.png\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/a><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/94.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1794\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/94.png\" alt=\"9\" width=\"519\" height=\"322\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1794\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/94.png\" alt=\"9\" width=\"519\" height=\"322\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/94.png 884w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/94-300x185.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/94-600x371.png 600w\" sizes=\"(max-width: 519px) 100vw, 519px\" \/><\/noscript><\/a><\/p>\n<p>Report Studiyo\u2019da att\u0131\u011f\u0131n her obje i\u00e7in arka planda bir Query olu\u015fturulur. Rapora singleton ad\u0131nda bir obje att\u0131\u011f\u0131m i\u00e7in arkada kendi, rapordan ba\u011f\u0131ms\u0131z bir Query olu\u015fturdu, bunu de\u011fi\u015ftirerek raporda kullan\u0131lacak olan Query\u2019i se\u00e7memiz gerekmektedir.<\/p>\n<p>Singleton ile hesaplanacak de\u011ferin NULL ifadeler i\u00e7ermeyen Uniqe de\u011ferler olmas\u0131na dikkat edilmelidir.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q4.png\">\u00a0<\/a>\u00a0\u00a0 <a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy aligncenter wp-image-1686 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\/2014\/11\/q5.png\" alt=\"q5\" width=\"498\" height=\"170\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1686 size-full\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q5.png\" alt=\"q5\" width=\"498\" height=\"170\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q5.png 498w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q5-300x102.png 300w\" sizes=\"(max-width: 498px) 100vw, 498px\" \/><\/noscript><\/a><\/p>\n<p style=\"text-align: center\"><em><strong>\u00a0<\/strong><\/em><\/p>\n<h2>IBM COGNOS Framework Manager<\/h2>\n<ol>\n<li>Rapor \u00fcretimi yapabilece\u011fimiz k\u00fcplerin olu\u015fturulmas\u0131<\/li>\n<li>Daha \u00f6nceden haz\u0131rlanm\u0131\u015f rapor bilgisinin yeni olu\u015fturabilecek rapora dahil edilmesi<\/li>\n<li>Dahili veya harici veri kaynaklar\u0131n y\u00f6netimi<\/li>\n<li>Kullan\u0131lacak veri yap\u0131s\u0131n\u0131n se\u00e7imi (ili\u015fkisel veya warehouse (ambar) veri kayna\u011f\u0131n\u0131n kaynak olarak g\u00f6sterilmesi) gibi i\u015flemler yapar.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/bbb.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1846\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/bbb.png\" alt=\"bbb\" width=\"571\" height=\"257\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1846\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/bbb.png\" alt=\"bbb\" width=\"571\" height=\"257\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/bbb.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/bbb-300x135.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/bbb-600x270.png 600w\" sizes=\"(max-width: 571px) 100vw, 571px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/92.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone  wp-image-1662\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/92.png\" alt=\"9\" width=\"223\" height=\"283\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-1662\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/92.png\" alt=\"9\" width=\"223\" height=\"283\" \/><\/noscript><\/a><\/p>\n<p>Presentation Layer \u2018da Tablo \u00fczerine sa\u011f t\u0131klay\u0131p Ba\u011flam Gezgini\u2019ni Ba\u015flat dedi\u011fimizde ba\u011fl\u0131 bulundu\u011fu Tablolar\u0131 ili\u015fkileri ile birlikte g\u00f6rebiliriz. G\u00f6r\u00fcnt\u00fclemek istedi\u011finiz ili\u015fki \u00fczerine sa\u011f t\u0131klay\u0131p kurulan join i\u015flemini inceleyebilirsiniz.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-1841\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/cc-300x164.png\" alt=\"cc\" width=\"300\" height=\"164\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1841\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/cc-300x164.png\" alt=\"cc\" width=\"300\" height=\"164\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/cc-300x164.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/cc-600x329.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/cc.png 1024w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/p>\n<p>Yeni bir FM olu\u015fturmak i\u00e7in<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/c.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1666\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/c.png\" alt=\"c\" width=\"475\" height=\"432\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1666\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/c.png\" alt=\"c\" width=\"475\" height=\"432\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/c.png 596w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/c-300x272.png 300w\" sizes=\"(max-width: 475px) 100vw, 475px\" \/><\/noscript><\/a><\/p>\n<p>Veri kaynaklar\u0131n\u0131 se\u00e7ip \u00e7\u0131kan ekranda beslenecek Veri Kayna\u011f\u0131n\u0131 se\u00e7erek i\u00e7e aktarmak istedi\u011fimiz nesneleri se\u00e7ebiliriz\u00a0.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/gg.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-1847\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/gg-300x139.png\" alt=\"gg\" width=\"300\" height=\"139\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1847\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/gg-300x139.png\" alt=\"gg\" width=\"300\" height=\"139\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/gg-300x139.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/gg-316x145.png 316w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/gg.png 592w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Yinelenen bir ad saptand\u0131\u011f\u0131nda : Bu nesneyi i\u00e7e aktarma \u00e7\u00fcnk\u00fc di\u011fer FM taraf\u0131ndan kullan\u0131labilir \u00f6zelli\u011fine dikkat edilmelidir.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/e.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-1668\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/e.png\" alt=\"e\" width=\"255\" height=\"73\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1668\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/e.png\" alt=\"e\" width=\"255\" height=\"73\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/e.png 255w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/e-250x73.png 250w\" sizes=\"(max-width: 255px) 100vw, 255px\" \/><\/noscript><\/a><\/p>\n<p>\u0130leri diyerek ili\u015fkinin \u00f6zelliklerini\u00a0\u00a0ayarlayabilirsiniz. \u0130\u00e7e aktar diyerek verilerimizi i\u00e7eriye aktarm\u0131\u015f oluyoruz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/f.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1669\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/f.png\" alt=\"f\" width=\"439\" height=\"402\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1669\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/f.png\" alt=\"f\" width=\"439\" height=\"402\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/f.png 590w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/f-300x275.png 300w\" sizes=\"(max-width: 439px) 100vw, 439px\" \/><\/noscript><\/a><\/p>\n<p>Yeni bir paket olu\u015fturulabilir , olu\u015fturaca\u011f\u0131m\u0131z pakete eklemek istedi\u011fimiz nesneleri se\u00e7ebiliriz:<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/g.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1670 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\/2014\/11\/g.png\" alt=\"g\" width=\"379\" height=\"224\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1670 size-full\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/g.png\" alt=\"g\" width=\"379\" height=\"224\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/g.png 379w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/g-300x177.png 300w\" sizes=\"(max-width: 379px) 100vw, 379px\" \/><\/noscript><\/a><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/h.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1671\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/h.png\" alt=\"h\" width=\"388\" height=\"333\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1671\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/h.png\" alt=\"h\" width=\"388\" height=\"333\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/h.png 587w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/h-300x257.png 300w\" sizes=\"(max-width: 388px) 100vw, 388px\" \/><\/noscript><\/a>\u00a0\u00a0\u00a0 <a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/x.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone  wp-image-1676\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/x.png\" alt=\"x\" width=\"235\" height=\"134\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-1676\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/x.png\" alt=\"x\" width=\"235\" height=\"134\" \/><\/noscript><\/a><\/p>\n<p>\u0130leri deyip, sonland\u0131rd\u0131\u011f\u0131m\u0131zda yeni olu\u015fturdu\u011fun bir paketi veya \u00fczerinde de\u011fi\u015fiklik yapt\u0131\u011f\u0131n bir paketi yeniden yay\u0131nlayarak Report Studio\u2019ya export edip kullanabiliriz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/i.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1672 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\/2014\/11\/i.png\" alt=\"i\" width=\"450\" height=\"210\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1672 size-full\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/i.png\" alt=\"i\" width=\"450\" height=\"210\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/i.png 450w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/i-300x140.png 300w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/noscript><\/a><\/p>\n<p>Yay\u0131nlama konumunu se\u00e7erek yay\u0131nl\u0131yoruz .<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/115.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-1784\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/115-300x216.png\" alt=\"1\" width=\"300\" height=\"216\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1784\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/115-300x216.png\" alt=\"1\" width=\"300\" height=\"216\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/115-300x216.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/115-600x432.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/115.png 686w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Report Studio\u2019ya gelerek Change Report Package deyip FM \u2018de yapt\u0131\u011f\u0131m\u0131z de\u011fi\u015fiklerin rapora yans\u0131mas\u0131n\u0131 sa\u011fl\u0131yoruz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/l2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1678 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\/2014\/11\/l2.png\" alt=\"l2\" width=\"809\" height=\"137\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1678 size-full\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/l2.png\" alt=\"l2\" width=\"809\" height=\"137\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/l2.png 809w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/l2-300x50.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/l2-600x101.png 600w\" sizes=\"(max-width: 809px) 100vw, 809px\" \/><\/noscript><\/a><\/p>\n<p>FM de olu\u015fturdu\u011fumuz ve raporda kullanaca\u011f\u0131m\u0131z paketimizi se\u00e7iyoruz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/134.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-medium wp-image-1799\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/134-300x252.png\" alt=\"13\" width=\"300\" height=\"252\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1799\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/134-300x252.png\" alt=\"13\" width=\"300\" height=\"252\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/134-300x252.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/134.png 594w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p style=\"text-align: center\"><em><strong>\u00a0<\/strong><\/em><\/p>\n<h3>Report Studio da Auto Group &amp; Summarize \u00d6zelli\u011fi<\/h3>\n<p><strong>\u00a0<\/strong>Freamworkte nesnelere y\u00fckledi\u011fin \u00f6zellikleri rapora da aynen ta\u015f\u0131mak i\u00e7in (Distinct, Sum, Measure, identity, attribute)\u00a0\u00a0 \u201cAuto Group &amp; Summarize \u201c YES yap\u0131l\u0131r.<\/p>\n<p><strong>\u00a0<a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1682 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\/2014\/11\/q.png\" alt=\"q\" width=\"500\" height=\"162\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1682 size-full\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q.png\" alt=\"q\" width=\"500\" height=\"162\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q.png 500w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q-300x97.png 300w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/noscript><\/a><\/strong><\/p>\n<p>Auto Group and Summarize &#8216;y\u0131 <strong>YES<\/strong> . Amac\u0131 verileri ya distinct ile azaltmak ya da Group by ile azaltmak.<\/p>\n<p><em><strong>Not: FM de olu\u015fturdu\u011fun joinler report studio\u2019ya aynen gelir. Ancak raporda kullanaca\u011f\u0131n join i\u015flemi farkl\u0131 ise, bunu gidip FM de d\u00fczeltmek yerine, Report studio\u2019da FM\u2019yi ezen Query\u2019ler \u00fczerinden yeniden bir join i\u015flemi ger\u00e7ekle\u015ftirebilirsiniz.<\/strong><\/em><em><strong>\u00a0<\/strong><\/em><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: left\">Rapor Schedule Etmek<\/h2>\n<p>Report Studio\u2019da daha \u00f6nceden olu\u015fturdu\u011fumuz t\u00fcm raporlar\u0131n oldu\u011fu sayfaya geldi\u011fimizde (Public folder ya da my folder&#8217;daki)<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1688\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q6-1024x23.png\" alt=\"q6\" width=\"845\" height=\"18\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1688\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q6-1024x23.png\" alt=\"q6\" width=\"845\" height=\"18\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q6-1024x23.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q6-300x6.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q6-600x13.png 600w\" sizes=\"(max-width: 845px) 100vw, 845px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy aligncenter wp-image-1691\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q7-238x300.png\" alt=\"q7\" width=\"242\" height=\"305\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1691\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q7-238x300.png\" alt=\"q7\" width=\"242\" height=\"305\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q7-238x300.png 238w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q7.png 442w\" sizes=\"(max-width: 242px) 100vw, 242px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>More -&gt; new Schedule -&gt;<\/p>\n<p>Priority\u2019den \u00f6nem derecesini belirleriz, <em>Disable the schedule\u2019<\/em>\u0131 se\u00e7ersek yapt\u0131\u011f\u0131m\u0131z schedule arka planda olu\u015fur ancak bu \u00f6zellik sebebiyle aktif olmaz.<\/p>\n<p>Her g\u00fcn,her hafta,her ay, her y\u0131l \u015feklinde raporumuzun \u00e7al\u0131\u015fma zaman\u0131n\u0131\u00a0ayarlayabiliriz. Ayn\u0131 zamanda ba\u015flama ve biti\u015f saatini ayarlayabiliriz.<br \/>\n<a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1692 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\/2014\/11\/q8-1024x472.png\" alt=\"q8\" width=\"798\" height=\"367\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1692 size-large\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q8-1024x472.png\" alt=\"q8\" width=\"798\" height=\"367\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q8-1024x472.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q8-300x138.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q8-600x276.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q8-316x145.png 316w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q8.png 1069w\" sizes=\"(max-width: 798px) 100vw, 798px\" \/><\/noscript><\/a><\/p>\n<p>Options k\u0131sm\u0131nda raporumuzun \u00e7\u0131kt\u0131s\u0131na nas\u0131l olaca\u011f\u0131n\u0131 belirleyebiliriz. HTML,PDF,EXCEL vs..<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1693 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\/2014\/11\/q9-1024x341.png\" alt=\"q9\" width=\"798\" height=\"265\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1693 size-large\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q9-1024x341.png\" alt=\"q9\" width=\"798\" height=\"265\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q9-1024x341.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q9-300x99.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q9-600x199.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q9.png 1489w\" sizes=\"(max-width: 798px) 100vw, 798px\" \/><\/noscript><\/a><\/p>\n<p>E\u011fer raporunuzda de\u011fer bekleyen bir Prompt Page varsa, Cognos bu parametreye otomatik de\u011fer atamayaca\u011f\u0131 i\u00e7in Set \u00f6zelli\u011fini se\u00e7erek parametreler\u00a0de\u011fer atamam\u0131z gerekir.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/dd.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone size-full wp-image-1694\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/dd.png\" alt=\"dd\" width=\"285\" height=\"126\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1694\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/dd.png\" alt=\"dd\" width=\"285\" height=\"126\" \/><\/noscript><\/a><\/p>\n<p>Raporlara yapt\u0131\u011f\u0131m\u0131z Schedule\u2019lar\u0131n kontrollerini My Activities and Schedules \u2018dan g\u00f6rebiliriz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1695 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\/2014\/11\/q10.png\" alt=\"q10\" width=\"757\" height=\"144\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1695 size-full\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q10.png\" alt=\"q10\" width=\"757\" height=\"144\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q10.png 757w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q10-300x57.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q10-600x114.png 600w\" sizes=\"(max-width: 757px) 100vw, 757px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Status sekmesinden-&gt; Schedules sekmesinden, Current Activites,Past Activites,Upcoming Activites,Schedules g\u00f6rebiliriz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q11.png\"><img loading=\"lazy\" decoding=\"async\" class=\"lazy alignnone wp-image-1697 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\/2014\/11\/q11-1024x321.png\" alt=\"q11\" width=\"798\" height=\"250\" \/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1697 size-large\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q11-1024x321.png\" alt=\"q11\" width=\"798\" height=\"250\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q11-1024x321.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q11-300x94.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q11-600x188.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2014\/11\/q11.png 1511w\" sizes=\"(max-width: 798px) 100vw, 798px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Bir sonraki yaz\u0131mda da test ortamda\u00a0\u00fcretilen raporlar\u0131n canl\u0131 ortama nas\u0131l deploy edilece\u011finden bahsedece\u011fim, o zamana kadar g\u00f6r\u00fc\u015fmek \u00fczere!<\/p>","protected":false},"excerpt":{"rendered":"<p>Herkese merhaba sizlere bu yaz\u0131mda BI sekt\u00f6r\u00fcn\u00fcn tool&#8217;lar\u0131 aras\u0131nda kendini farkettiren bir tool olan\u00a0IBM COGNOS &#8216;tan bahsede\u011fim. Bilindi\u011fi gibi her sekt\u00f6r\u00fcn kendine has dinamikleri vard\u0131r, bu nedenle de b\u00fcy\u00fck datan\u0131n kullan\u0131m\u0131 sekt\u00f6rden sekt\u00f6re farkl\u0131l\u0131k g\u00f6sterebilir. Veri miktarlar\u0131 art\u0131k sadece sosyal medya ve internet \u00fczerinde b\u00fcy\u00fcm\u00fcyor, ayn\u0131 zamanda kurumlar\u0131n sahip olduklar\u0131 veri miktarlar\u0131 da giderek art\u0131yor. [&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,190,189],"class_list":["post-1566","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-is-zekasi","tag-cognos","tag-ibm","tag-rapor","tag-veri-madenciligi-2"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>IBM Cognos ile Raporlama Nas\u0131l Yap\u0131l\u0131r? - Koddit<\/title>\n<meta name=\"description\" content=\"IBM Cognos ile raporlama nas\u0131l yap\u0131l\u0131r? Bu yaz\u0131da ad\u0131m ad\u0131m, resimli \u00f6rneklerle inceliyoruz...\" \/>\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-raporlama\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"IBM Cognos ile Raporlama Nas\u0131l Yap\u0131l\u0131r? - Koddit\" \/>\n<meta property=\"og:description\" content=\"IBM Cognos ile raporlama nas\u0131l yap\u0131l\u0131r? Bu yaz\u0131da ad\u0131m ad\u0131m, resimli \u00f6rneklerle inceliyoruz...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.koddit.com\/en\/is-zekasi\/ibm-cognos-raporlama\/\" \/>\n<meta property=\"og:site_name\" content=\"Koddit\" \/>\n<meta property=\"article:published_time\" content=\"2014-11-23T21:32:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-02-17T20:02:42+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=\"12 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-raporlama\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/\"},\"author\":{\"name\":\"Koddit\",\"@id\":\"https:\/\/blog.koddit.com\/#\/schema\/person\/518a908da35b6c3549d25a0bda7a1035\"},\"headline\":\"IBM Cognos ile Raporlama Nas\u0131l Yap\u0131l\u0131r?\",\"datePublished\":\"2014-11-23T21:32:27+00:00\",\"dateModified\":\"2015-02-17T20:02:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/\"},\"wordCount\":2381,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.koddit.com\/#organization\"},\"keywords\":[\"cognos\",\"ibm\",\"rapor\",\"veri madencili\u011fi\"],\"articleSection\":[\"\u0130\u015f Zekas\u0131\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/\",\"url\":\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/\",\"name\":\"IBM Cognos ile Raporlama Nas\u0131l Yap\u0131l\u0131r? - Koddit\",\"isPartOf\":{\"@id\":\"https:\/\/blog.koddit.com\/#website\"},\"datePublished\":\"2014-11-23T21:32:27+00:00\",\"dateModified\":\"2015-02-17T20:02:42+00:00\",\"description\":\"IBM Cognos ile raporlama nas\u0131l yap\u0131l\u0131r? Bu yaz\u0131da ad\u0131m ad\u0131m, resimli \u00f6rneklerle inceliyoruz...\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/blog.koddit.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IBM Cognos ile Raporlama Nas\u0131l Yap\u0131l\u0131r?\"}]},{\"@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 ile Raporlama Nas\u0131l Yap\u0131l\u0131r? - Koddit","description":"IBM Cognos ile raporlama nas\u0131l yap\u0131l\u0131r? Bu yaz\u0131da ad\u0131m ad\u0131m, resimli \u00f6rneklerle inceliyoruz...","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-raporlama\/","og_locale":"en_US","og_type":"article","og_title":"IBM Cognos ile Raporlama Nas\u0131l Yap\u0131l\u0131r? - Koddit","og_description":"IBM Cognos ile raporlama nas\u0131l yap\u0131l\u0131r? Bu yaz\u0131da ad\u0131m ad\u0131m, resimli \u00f6rneklerle inceliyoruz...","og_url":"https:\/\/blog.koddit.com\/en\/is-zekasi\/ibm-cognos-raporlama\/","og_site_name":"Koddit","article_published_time":"2014-11-23T21:32:27+00:00","article_modified_time":"2015-02-17T20:02:42+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":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/#article","isPartOf":{"@id":"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/"},"author":{"name":"Koddit","@id":"https:\/\/blog.koddit.com\/#\/schema\/person\/518a908da35b6c3549d25a0bda7a1035"},"headline":"IBM Cognos ile Raporlama Nas\u0131l Yap\u0131l\u0131r?","datePublished":"2014-11-23T21:32:27+00:00","dateModified":"2015-02-17T20:02:42+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/"},"wordCount":2381,"commentCount":0,"publisher":{"@id":"https:\/\/blog.koddit.com\/#organization"},"keywords":["cognos","ibm","rapor","veri madencili\u011fi"],"articleSection":["\u0130\u015f Zekas\u0131"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/","url":"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/","name":"IBM Cognos ile Raporlama Nas\u0131l Yap\u0131l\u0131r? - Koddit","isPartOf":{"@id":"https:\/\/blog.koddit.com\/#website"},"datePublished":"2014-11-23T21:32:27+00:00","dateModified":"2015-02-17T20:02:42+00:00","description":"IBM Cognos ile raporlama nas\u0131l yap\u0131l\u0131r? Bu yaz\u0131da ad\u0131m ad\u0131m, resimli \u00f6rneklerle inceliyoruz...","breadcrumb":{"@id":"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.koddit.com\/is-zekasi\/ibm-cognos-raporlama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/blog.koddit.com\/"},{"@type":"ListItem","position":2,"name":"IBM Cognos ile Raporlama Nas\u0131l Yap\u0131l\u0131r?"}]},{"@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\/1566"}],"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=1566"}],"version-history":[{"count":0,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/posts\/1566\/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=1566"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/categories?post=1566"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/tags?post=1566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}