tag:blogger.com,1999:blog-2380859127978005622024-03-04T20:04:46.329-08:00Cognos Tutorials For Beginners - Easy StepsBest online resource for Cognos TutorialsUnknownnoreply@blogger.comBlogger27125tag:blogger.com,1999:blog-238085912797800562.post-38115688377167459952016-01-13T15:12:00.003-08:002016-01-23T18:41:39.104-08:00Cognos Quick Reference<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 468 Text -->
<ins class="adsbygoogle"
style="display:inline-block;width:468px;height:60px"
data-ad-client="ca-pub-8413193364348443"
data-ad-slot="2791823691"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<div dir="ltr" style="text-align: left;" trbidi="on">
When you view or create a report, you are viewing data stored in your organization's databases. The following diagram explains the steps involved in using IBM Cognos Business Intelligence.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieLq5mGVNQCauysD66PGXcjIv24ttj5IYVtPEGdDHJNVf2Zluss_x6ghktQnfVRIcuy8o2QEz1Pd20RdWX9qYvVi904l_S-9wrROQ6OJOKpYrscUDhLzX7XkSd9kHOQUlQJ9jlqJaXiSF5/s1600/Cognos+BI+Architecture.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieLq5mGVNQCauysD66PGXcjIv24ttj5IYVtPEGdDHJNVf2Zluss_x6ghktQnfVRIcuy8o2QEz1Pd20RdWX9qYvVi904l_S-9wrROQ6OJOKpYrscUDhLzX7XkSd9kHOQUlQJ9jlqJaXiSF5/s1600/Cognos+BI+Architecture.png" width="302" /></a></div>
<br />
<br />
1. In IBM Cognos Framework Manager, the modeler ensures that metadata is presented in a manner that business users can understand. Modelers import the metadata from one or more databases, and then add to the model to meet user requirements.<br />
<br />
2. In IBM Cognos Metric Designer, the modeler identifies the data items and calculations that form the targets and actual results for each metric.<br />
<br />
3. The modeler then publishes and updates packages to IBM Cognos Connection so that authors can use them to create reports, agents, and scorecards.<br />
<br />
4. Business users and report authors use the published packages to understand their business data.<br />
<br />
5. Users run, view, and manage their content in IBM Cognos Connection.Depending on their security permissions, they may be able to simply run and view reports or manage schedules, portal layout, and other users' permissions.<br />
<br />
6. In IBM Cognos Transformer, you can leverage queries in published packages, queries from IBM Cognos BI reports, and personal data sources, such as Microsoft Excel spreadsheet software, to create a unique, focused model of your business. Transformer is IBM Cognos's industry leading OLAP modeling tool,<br />
which is designed so that business users can be self-sufficient in modeling a view of the business that suits the needs of their department or specialty.<br />
<br />
<br />
<b>Report Specifications</b><br />
<br />
When authors create a report, they are actually creating a report specification. The report specification is an XML representation of the queries and prompts that are used to retrieve data, as well as the layouts and styles used to present the data. For simplicity, the report specification is called the report.<br />
<br />
<b>Models and Packages</b><br />
<br />
Because stored data is typically designed for storage and not for reporting, a data modeler uses Framework Manager to create metadata models. Models structure, add to, and manage data in ways that make sense to business users. Models define business rules, data descriptions, data relationships, and business dimensions and hierarchies.<br />
<br />
Models can be based on the compatible query mode or the dynamic query mode. The compatible query mode supports legacy reports and is required for some data sources. The dynamic query mode is recommended for new applications of IBM Cognos Business Intelligence.<br />
<br />
The dynamic query mode provides the following benefits:<br />
<br />
<ol>
<li>It is optimized for complex queries and larger data volumes.</li>
<li>It provides advanced query capabilities, such as in-memory caching, which can improve query planning, execution, and results.</li>
<li>It enables the use of IBM Cognos Dynamic Cubes as data sources, which allow low-latency, high-performance OLAP analytics over large relational data warehouses.</li>
</ol>
<div>
<br /></div>
<br />
<div>
Planning and creating a model is an important task that should be performed by a modeler or a modeling team familiar with both the database structure and the needs of the business users.</div>
<div>
<br /></div>
<div>
<div>
After the metadata model is defined, modelers create a package to make metadata available to report authors. Each package must contain all the information that a specific user or group of users needs to create reports. For example, one package can contain human resources data, and another sales data. When users open an authoring studio, they must select which package to use. Each report can contain data from only one package.</div>
<div>
<br /></div>
<div>
After a package is made available in IBM Cognos Connection, the Transformer modeler can begin to design a multidimensional IBM Cognos PowerCube for a more focused analysis of the business. The queries can be created directly in Transformer using metadata from any published package. Business specialists can</div>
<div>
also design their own model for a more focused analysis, combining metadata from different packages and even including personal data using flat files.</div>
<div>
<br /></div>
<div>
A more refined query intended for Transformer modeling can be authored by a business specialist by creating a report in IBM Cognos Query Studio or Report Studio. That report can then be used to create a data source in Transformer, allowing the business specialist full control over changes to the report, and</div>
<div>
therefore the query, rather than relying on the Framework Manager administrator for changes. Once the multi-dimensional design is complete, IBM Cognos BI security can be added with dimensional filtering and the PowerCube can be built. The PowerCube can then be published to IBM Cognos Connection just like any other package, making it available for multi-dimensional analysis and reporting.</div>
</div>
</div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-21298555123382486612014-02-13T21:35:00.001-08:002014-02-13T21:35:25.369-08:00Building Cognos BI Applications<div dir="ltr" style="text-align: left;" trbidi="on">
You use the IBM Cognos Business Intelligence components to build reporting and analysis applications.<br />
<br />
The lifetime of an IBM Cognos Business Intelligence application can be months, or even years. During that time, data may change and new requirements appear. As the underlying data changes, authors must modify existing content and develop new content. Administrators must also update models and data sources over time.<br />
<br />
<b>Before you begin</b><br />
In a working application, the technical and security infr<br />
astructure and the portal are in place, as well as processes for change management, data control, and so on.<br />
<br />
For additional information, see the IBM Cognos Solutions Implementation Methodology toolkit, which includes implementation roadmaps and supporting documents. Information about the toolkit is available on the Cognos Customer Center (http://www.ibm.com/software/data/cognos/customercenter/).<br />
<br />
The following graphic provides an overview for how to use IBM Cognos build applications across all of your IBM Cognos BI components.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCP5dKS9AXZeh8Zi6ie0h1wpzpSy05-xNuUfjoOPg6P0EgBOu8G8CW6sVmlNs8Hyp9YD0KMC_TeHwVzJP_a68ObMsUR7_LLFplRJ1ud4xuMmBoMmiPo844sxiniJBLOQstw9t8YgjIuvqq/s1600/Cognos+Applications.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCP5dKS9AXZeh8Zi6ie0h1wpzpSy05-xNuUfjoOPg6P0EgBOu8G8CW6sVmlNs8Hyp9YD0KMC_TeHwVzJP_a68ObMsUR7_LLFplRJ1ud4xuMmBoMmiPo844sxiniJBLOQstw9t8YgjIuvqq/s1600/Cognos+Applications.png" height="72" width="320" /></a></div>
<br />
<b>Procedure</b><br />
<u>1. Locate and prepare data sources and models.</u><br />
IBM Cognos BI can report from a wide variety of data sources, both relational and dimensional. Database connections are created in the Web administration interface, and are used for modeling, for authoring, and for running the application.<br />
To use data for authoring and viewing, the business intelligence studios need a subset of a model of the metadata (called a package). The metadata may need extensive modeling in Framework Manager.<br />
<br />
<u>2. Build and publish the content.</u><br />
Reports, scorecards, analysis, workspaces and more are created in the business intelligence studios of IBM Cognos BI. Which studio you use depends on the content, life span, and audience of the report, and whether the data is modeled dimensionally or relationally. For example, self-service reporting and analysis<br />
are done through IBM Cognos Workspace Advanced, IBM Cognos Query Studio, and IBM Cognos Analysis Studio, and scheduled reports are created in IBM Cognos Report Studio. Report Studio reports and scorecards are usually prepared for a wider audience, published to IBM Cognos Connection or another portal, and scheduled there for bursting, distribution, and so on. You can also use Report Studio to prepare templates for self-service reporting.<br />
<br />
<u>3. Deliver and view the information.</u><br />
You deliver content from the IBM Cognos portal or other supported portals, and view information that has been saved to portals, or delivered by other mechanisms. You can also run reports, analyses, scorecards, and more from within the business intelligence studio in which they were created.<br />
<br />
For information about tuning and performance, see the IBM Cognos Business Intelligence Administration and Security Guide and the Cognos Customer Center http://www.ibm.com/software/data/cognos/customercenter/).</div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-56112939699243404842014-02-13T21:31:00.001-08:002014-02-13T21:31:09.450-08:00Integrating with Other IBM Cognos Products<div dir="ltr" style="text-align: left;" trbidi="on">
IBM Cognos Business Intelligence is fully integrated with other IBM Cognos products so your business intelligence capabilities can grow with your needs.<br />
<br />
<b>Cognos Mobile</b><br />
With IBM Cognos Mobile, you can access reports authored with Analysis Studio, Report Studio, Query Studio, and workspaces created in IBM Cognos Workspace on a mobile device (such as a Blackberry) or a tablet computer.<br />
<br />
To download, view, and interact with reports, IBM Cognos Mobile devices are either web-based, require the download of a native client or require the installation of a rich client, in addition to the installation of IBM Cognos BI components on the server. Both IBM Cognos Mobile and IBM Cognos BI server must be at the same version.<br />
<br />
<b>Cognos Planning - Analyst</b><br />
You can access published plan data in IBM Cognos BI by using the Generate Framework Manager Model wizard, which requires IBM Cognos Planning - Analyst 7.3 MR1 or later.If you want to use this product with the IBM Cognos BI server, you must ensure that both products are the same version.<br />
<br />
<b>Cognos Planning - Contributor</b><br />
You can access unpublished (real-time) Contributor cubes in IBM Cognos BI by custom installing the IBM Cognos BI - Contributor Data Server component that is included with IBM Cognos Planning - Contributor 7.3 MR1 release or later. You can access published plan data in IBM Cognos BI by using the Generate<br />
Framework Manager Model administration extension in Contributor, which requires IBM Cognos Planning - Contributor 7.3 MR1 or later. If you want to use this product with the IBM Cognos BI server, you must ensure that both products are the same version. You cannot install IBM Cognos Planning in the same path as 64-bit IBM Cognos BI.<br />
<br />
You can access IBM Cognos Finance cubes that are secured against a Series 7namespace by using the IBM Cognos Finance Network API Service. You can also export data and metadata from IBM Cognos Finance for use in Framework Manager.<br />
<br />
<br />
<b>Cognos Controller</b><br />
You can access IBM Cognos BI to create IBM Cognos Controller Standard Reports by using a predefined Framework Manager model that is created when IBM Cognos Controller is installed. You can also access published Controller data and structures in Framework Manager for custom reporting and analysis.<br />
If you want to use this product with the IBM Cognos BI server, you must ensure that both products are the same version.<br />
<br />
<b>Cognos Transformer</b><br />
You can use IBM Cognos PowerCubes and Transformer models that were generated by Transformer 7.3 or later directly in IBM Cognos BI. The cubes and models are upwards compatible and require no migration or upgrade tools. You can run reports and analyses in IBM Cognos BI against the IBM Cognos PowerCubes.<br />
<br />
<b>Cognos TM1</b><br />
IBM Cognos TM1 integrates business planning, performance measurement and operational data to enable companies to optimize business effectiveness and customer interaction regardless of geography or structure. Cognos TM1 provides immediate visibility into data, accountability within a collaborative process, and a<br />
consistent view of information, allowing managers to quickly stabilize operational fluctuations and take advantage of new opportunities. </div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-20492613871736760892014-02-13T21:27:00.003-08:002014-02-13T21:27:50.660-08:00Cognos Software Development Kit<div dir="ltr" style="text-align: left;" trbidi="on">
The IBM Cognos Software Development Kit provides a platform-independent automation interface for working with IBM Cognos BI services and components.<br />
<br />
Developers in your organization can use the IBM Cognos Software Development Kit to create custom reports, manage deployment, and integrate security and portal functionality to suit your needs, locale, and existing software infrastructure. The Software Development Kit uses a collection of cross-platform Web services, libraries, and programming interfaces.<br />
<br />
You can choose to automate only a specific task, or you can program the entire process from modeling through to reporting, scheduling, and distribution.<br />
<br />
The Software Development Kit is available as a separate package.</div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-40416062289226694752014-02-13T21:26:00.003-08:002014-02-13T21:26:27.340-08:00Administration<div dir="ltr" style="text-align: left;" trbidi="on">
IBM Cognos Business Intelligence administrators ensure that IBM Cognos BI runs smoothly and at its optimum performance.<br />
<br />
They can<br />
<br />
<ol style="text-align: left;">
<li>Define connections to the organization's data sources</li>
<li>Define security permissions for users and groups in the organization</li>
<li>Specify distribution lists, contacts, and printers</li>
<li>Manage servers and dispatchers and fine-tune the performance of IBM CognosBI</li>
<li>Pre-define links for an entire package that authors can then easily add to theirreports</li>
<li>Customize the appearance and functionality of IBM Cognos BI</li>
</ol>
<div>
<br /></div>
<br />
<div>
<b>Security</b></div>
<div>
<div>
IBM Cognos BI is secured by setting permissions and enabling user authentication.</div>
<div>
When anonymous access is enabled, you can use IBM Cognos BI without authenticating as a specific user.</div>
<div>
In IBM Cognos BI, administrators define permissions so that users can access functionality. For example, to edit a report using IBM Cognos Report Studio, you must have the appropriate security and licensing permissions.</div>
<div>
<br /></div>
<div>
In addition, each entry in IBM Cognos Connection is secured to define who can read, edit, and run the entry. </div>
<div>
<br /></div>
<div>
<b>Scheduling Content</b></div>
<div>
You can schedule most content that appears in IBM Cognos Connection to run at a time that is convenient for you. </div>
</div>
<div>
<br /></div>
<div>
<div>
You can schedule</div>
<div>
<ol style="text-align: left;">
<li>Reports</li>
<li>Metrics</li>
<li>Metrics data refreshes</li>
<li>Agents</li>
<li>Deployments</li>
</ol>
</div>
<div>
You can also create jobs to schedule multiple entries together.</div>
</div>
</div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-16917424567475257582014-02-13T21:24:00.001-08:002014-02-13T21:24:08.628-08:00Cognos Viewing and Organizing Content<div dir="ltr" style="text-align: left;" trbidi="on">
When you view and run a report, scorecard, or agent, the information that you see comes from data sources, the package, calculations, other properties added by the author, and from IBM Cognos Business Intelligence itself.<br />
<br />
You use IBM Cognos Connection to organize your reports and other IBM Cognos content such as agents, metrics packages, URLs, and folders. You can access public content on the Public Folders tab or custom portal pages, and store and access your favorite content on the My Folders tab.<br />
<br />
<b>Report and Agent Views</b><br />
If you want to personalize an existing public report or agent, you can create a report or agent view and save the view on the My Folders tab. This allows you to save prompt values, modify the schedule, and change the output format of reports.<br />
<br />
<b>Report Outputs</b><br />
When a report is run, it contains the latest data from the data source. However, viewing the most recent data may not always meet your needs. When you want to view older data, you save and view the report output.<br />
Report outputs are created when you schedule a report, when a report has multiple formats or languages, when a report has a delivery method of save, print, or email, and when a report is burst.<br />
<br />
You can produce report outputs in the following formats:<br />
<br />
<ul style="text-align: left;">
<li>Hypertext markup language (.html)</li>
<li>Adobe portable document format (.pdf)</li>
<li>Microsoft Excel spreadsheet (.xls or .xlsx)</li>
<li>Delimited text (.csv)</li>
<li>Extensible markup language (.xml)</li>
</ul>
<br />
If you are the owner of a report or have the necessary permissions, you can specify the default format for each report. You can also specify how many report output versions to keep.<br />
<br />
<b>Drill-through Links</b><br />
A report can contain drill-through links, also known as Go To links, so that you can easily open related content. A value in the report is linked to more detailed information in another report. For example, a report includes sales information for each continent. When you click a continent name, a more detailed report about<br />
sales for that specific continent opens. When you view report data in IBM Cognos Connection, IBM Cognos Query Studio, and IBM Cognos Analysis Studio, you can also drill down and drill up.<br />
When you drill down, you follow a link from one layer of data to a more detailed layer within the same report. When you drill up, you access a less detailed layer.<br />
<br />
<b>Multilingual User Interface and Content</b><br />
IBM Cognos Business Intelligence is a multilingual suite that lets you author reports once and deploy them globally. When users open a report, it automatically opens in the proper language, based on their locale settings. You can select the language that you prefer for the user interface. If your data and reports are available in multiple languages, you can also select the language that you prefer for the content.<br />
There is also support for bidirectional languages such as Hebrew, Arabic, Urdu, and Farsi. Report authors can control the display of native digits and the direction of text, crosstabs, and charts.<br />
<br />
<b>Portal Pages</b><br />
In IBM Cognos Connection, you can create your own custom portal pages. You use these portal pages to view frequently-used content, to group related reports and folders, and to combine IBM Cognos BI and non-IBM Cognos content within a single page. Within your portal pages, you can add IBM Cognos BI portlets, which you use to view and interact with your IBM Cognos BI content. If you have the necessary permissions, you can create public pages that other users and groups can access and even use as their own. You can assign security permissions to allow only certain users to access the pages.</div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-89082427060445913512014-02-13T21:20:00.000-08:002014-02-13T21:20:57.201-08:00How Cognos Business Intelligence Works<div dir="ltr" style="text-align: left;" trbidi="on">
When you view or create a report, you are viewing data stored in your organization's databases. The following diagram explains the steps involved in using IBM Cognos Business Intelligence.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieLq5mGVNQCauysD66PGXcjIv24ttj5IYVtPEGdDHJNVf2Zluss_x6ghktQnfVRIcuy8o2QEz1Pd20RdWX9qYvVi904l_S-9wrROQ6OJOKpYrscUDhLzX7XkSd9kHOQUlQJ9jlqJaXiSF5/s1600/Cognos+BI+Architecture.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieLq5mGVNQCauysD66PGXcjIv24ttj5IYVtPEGdDHJNVf2Zluss_x6ghktQnfVRIcuy8o2QEz1Pd20RdWX9qYvVi904l_S-9wrROQ6OJOKpYrscUDhLzX7XkSd9kHOQUlQJ9jlqJaXiSF5/s1600/Cognos+BI+Architecture.png" height="320" width="302" /></a></div>
<br />
<br />
1. In IBM Cognos Framework Manager, the modeler ensures that metadata is presented in a manner that business users can understand. Modelers import the metadata from one or more databases, and then add to the model to meet user requirements.<br />
<br />
2. In IBM Cognos Metric Designer, the modeler identifies the data items and calculations that form the targets and actual results for each metric.<br />
<br />
3. The modeler then publishes and updates packages to IBM Cognos Connection so that authors can use them to create reports, agents, and scorecards.<br />
<br />
4. Business users and report authors use the published packages to understand their business data.<br />
<br />
5. Users run, view, and manage their content in IBM Cognos Connection.Depending on their security permissions, they may be able to simply run and view reports or manage schedules, portal layout, and other users' permissions.<br />
<br />
6. In IBM Cognos Transformer, you can leverage queries in published packages, queries from IBM Cognos BI reports, and personal data sources, such as Microsoft Excel spreadsheet software, to create a unique, focused model of your business. Transformer is IBM Cognos's industry leading OLAP modeling tool,<br />
which is designed so that business users can be self-sufficient in modeling a view of the business that suits the needs of their department or specialty.<br />
<br />
<br />
<b>Report Specifications</b><br />
<br />
When authors create a report, they are actually creating a report specification. The report specification is an XML representation of the queries and prompts that are used to retrieve data, as well as the layouts and styles used to present the data. For simplicity, the report specification is called the report.<br />
<br />
<b>Models and Packages</b><br />
<br />
Because stored data is typically designed for storage and not for reporting, a data modeler uses Framework Manager to create metadata models. Models structure, add to, and manage data in ways that make sense to business users. Models define business rules, data descriptions, data relationships, and business dimensions and hierarchies.<br />
<br />
Models can be based on the compatible query mode or the dynamic query mode. The compatible query mode supports legacy reports and is required for some data sources. The dynamic query mode is recommended for new applications of IBM Cognos Business Intelligence.<br />
<br />
The dynamic query mode provides the following benefits:<br />
<br />
<ol style="text-align: left;">
<li>It is optimized for complex queries and larger data volumes.</li>
<li>It provides advanced query capabilities, such as in-memory caching, which can improve query planning, execution, and results.</li>
<li>It enables the use of IBM Cognos Dynamic Cubes as data sources, which allow low-latency, high-performance OLAP analytics over large relational data warehouses.</li>
</ol>
<div>
<br /></div>
<br />
<div>
Planning and creating a model is an important task that should be performed by a modeler or a modeling team familiar with both the database structure and the needs of the business users.</div>
<div>
<br /></div>
<div>
<div>
After the metadata model is defined, modelers create a package to make metadata available to report authors. Each package must contain all the information that a specific user or group of users needs to create reports. For example, one package can contain human resources data, and another sales data. When users open an authoring studio, they must select which package to use. Each report can contain data from only one package.</div>
<div>
<br /></div>
<div>
After a package is made available in IBM Cognos Connection, the Transformer modeler can begin to design a multidimensional IBM Cognos PowerCube for a more focused analysis of the business. The queries can be created directly in Transformer using metadata from any published package. Business specialists can</div>
<div>
also design their own model for a more focused analysis, combining metadata from different packages and even including personal data using flat files.</div>
<div>
<br /></div>
<div>
A more refined query intended for Transformer modeling can be authored by a business specialist by creating a report in IBM Cognos Query Studio or Report Studio. That report can then be used to create a data source in Transformer, allowing the business specialist full control over changes to the report, and</div>
<div>
therefore the query, rather than relying on the Framework Manager administrator for changes. Once the multi-dimensional design is complete, IBM Cognos BI security can be added with dimensional filtering and the PowerCube can be built. The PowerCube can then be published to IBM Cognos Connection just like any other package, making it available for multi-dimensional analysis and reporting.</div>
</div>
</div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-47029296167482849212014-02-13T20:34:00.001-08:002014-02-13T20:34:21.320-08:00Cognos Transformer<div dir="ltr" style="text-align: left;" trbidi="on">
IBM Cognos Transformer is a multi-dimensional data modeling component designed for use with IBM Cognos Business Intelligence.<br />
<br />
You use this component to create a multi-dimensional model: a business presentation of the information in one or more different data sources that share common data. After you add the needed metadata from IBM Cognos Business Intellligence packages, reports, and other various data sources, model the<br />
dimensions, customize the measures, and apply IBM Cognos BI secured views with dimensional filtering, you can create IBM Cognos PowerCubes based on this model. You can deploy these cubes to support OLAP reporting and analysis around the globe.</div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-77499178377249962072014-02-13T20:32:00.006-08:002014-02-13T20:32:59.652-08:00Cognos Analysis Studio<div dir="ltr" style="text-align: left;" trbidi="on">
In Analysis Studio, users can explore, analyze, and compare dimensional data. Analysis Studio provides access to dimensional, OLAP (online analytical processing), and dimensionally modeled relational data sources. Analyses created in Analysis Studio can be opened in Report Studio and used to build professional<br />
reports.<br />
<br />
<u>Example- Create and Analysis</u><br />
<u><br /></u>
In IBM Cognos Analysis Studio, you can manipulate items in your data interactively so that you can identify and understand the problems and issues in your business.<br />
<br />
In this exercise, you will learn how to<br />
<br />
<ul style="text-align: left;">
<li> Drill down</li>
<li> Create a top filter</li>
<li> Create a summary calculation</li>
<li> Create a crosstab and a chart</li>
</ul>
<div>
<br /></div>
<br />
<div>
You are a business analyst for the Sample Outdoors Company. You want to further analyze the returns business items to find out where and why products are the most frequently returned, and that have the biggest impact on the profit of the company.</div>
<div>
<br /></div>
<div>
<div>
To perform this exercise, you must have the appropriate licensing and security permissions.</div>
<div>
<br /></div>
<div>
Things to notice:</div>
<div>
<ol style="text-align: left;">
<li>The items and measures that you can add to your analysis appear in the data tree in the left pane.</li>
<li>The overview area above the work area is a convenient place to quickly explore and change the contents of your analysis. You manipulate rows and columns, drill up or down, and provide context for the work area.</li>
<li>Cognos Analysis Studio uses sets, which are collections of similar items. Youmanipulate items by applying actions to sets. You can sort, filter, and nest sets. You can also save custom sets and view subtotals for your sets.</li>
</ol>
</div>
<div>
<br /></div>
<div>
<b>Procedure</b></div>
<div>
1. Open IBM Cognos Connection:</div>
<div>
a. Start your Web browser.</div>
<div>
b. In the address bar, type the URL supplied by your administrator, and then press Enter. The URL looks something like this: http://servername/cognos</div>
<div>
<br /></div>
<div>
2. In the IBM Cognos Welcome page, click Analyze my business.</div>
<div>
<br /></div>
<div>
3. Click Samples, Cubes, Sales and Marketing (cube).</div>
<div>
<br /></div>
<div>
4. Click Blank Analysis, and click OK.</div>
<div>
<br /></div>
<div>
5. Insert data in the crosstab:</div>
<div>
a. In the Insertable objects pane, expand Measures. Drag Returns to the Measure zone or to the upper-left corner of the work area.</div>
<div>
b. Drag Products to the Rows zone.</div>
<div>
c. Expand Time and Time. Select all four years (2010, 2011, 2012, 2013) and drag them to the Columns zone.</div>
<div>
You now see the returns for all the product brands over a four-year span. The total number of returns is visible in the Total column.</div>
<div>
<br /></div>
<div>
6. Filter the top 10 product brands based on their total returns over the last four years:</div>
<div>
a. In the overview area, right-click Products and click Down a Level.</div>
<div>
The overview area is located above the work area. You can use the overview area as a convenient place to quickly explore and change the contents of the work area. The overview area shows any applied filters</div>
<div>
and sorting.</div>
<div>
b. Repeat the previous step to see a list of all individual products.</div>
<div>
c. In the overview area, right-click Products (depth 3) and click Top or Bottom > Top > 10.</div>
<div>
You see that the top 10 products with the most returns are now the only products in the crosstab.</div>
</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmEMmMZAJ4oSBLEpJ3IWbHJgnQlFnVtUkTPuNnMxJ2QTHR8z1gMQ85Rb90MoQnsUO5nknkpCOXjb9kxXfoIp4I4bVefaEhRcLQbJ7FgB-LhJRhhhx8i8w5ChKzDt58Rzb5b5LXSeBvMi1F/s1600/Cognos+Analysis+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmEMmMZAJ4oSBLEpJ3IWbHJgnQlFnVtUkTPuNnMxJ2QTHR8z1gMQ85Rb90MoQnsUO5nknkpCOXjb9kxXfoIp4I4bVefaEhRcLQbJ7FgB-LhJRhhhx8i8w5ChKzDt58Rzb5b5LXSeBvMi1F/s1600/Cognos+Analysis+Studio.jpg" height="240" width="320" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<div>
Tip: To use a specific product name rather than having to drill down multiple layers, in the Insertable objects pane, navigate to the product that you want. Select the product you want, and in the Information pane, drag</div>
<div>
the level name into the crosstab.</div>
<div>
<br /></div>
<div>
7. Create a summary calculation to see what the average returns are per year for the top 10 products:</div>
<div>
a. In the overview area, right-click Time (list) and click Summarize > Average (Time (list)). The Average (Time (list)) summary is added to the crosstab. This summary shows the average number of returns over the fours years in the crosstab.</div>
<div>
<br /></div>
<div>
8. View your analysis as a chart to see whether there is a trend or spike in any of the top 10 returns:</div>
<div>
a. Click View > Select Chart Type > Line Chart > Standard.</div>
<div>
Take note of the top 10 products with the highest returns. There may be some products, like BugShield Lotion, that are anomalies. You may want to exclude them from your analysis, or you may decide that you need to be comparing returns to other metrics; such as quantity sold or gross profit.</div>
</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPeQRmQ_L8tub_wInCZTmdoL9TmCt7zaRgbKsEa7peXOJ09VuATJl8yZ7GmShrAzxnr1PoaWiKnSvx8zVwhRScI3wGYYT_Kk3GPJmlY3j_c0pDQBvwfQ2bePGCq8AFA6y6DC6bF88AMnR1/s1600/Cognos+Analysis+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPeQRmQ_L8tub_wInCZTmdoL9TmCt7zaRgbKsEa7peXOJ09VuATJl8yZ7GmShrAzxnr1PoaWiKnSvx8zVwhRScI3wGYYT_Kk3GPJmlY3j_c0pDQBvwfQ2bePGCq8AFA6y6DC6bF88AMnR1/s1600/Cognos+Analysis+Studio.jpg" height="320" width="289" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<div>
9. Change the top 10 definition to filter on year 2013 to give you the most recent data for product returns.</div>
<div>
a. In the overview area, right-click Products (depth 3) and click Top or Bottom > Top > Custom.</div>
<div>
b. In the Define top or bottom filter pane, from the For column list, select 2013.</div>
<div>
By specifying 2013 in the top definition, you change the filter context to focus on the highest 10 returns for the year 2013. In addition, you see the other years in the crosstab, to give you some additional historical</div>
<div>
information. </div>
<div>
Tip: In the definition, you can specify the number of items you want by number, percentage, or sum.</div>
<div>
c. Click OK.</div>
<div>
<br /></div>
<div>
Notice that EverGlow Lamp has the highest number of returns.</div>
<div>
<br /></div>
<div>
Tip: In the overview area, using the Time (list) column, you can also filter on 2013. The data returned when using this filter is different from the data returned when you set the 2013 context in the top definition. Only 2013 data appears in the crosstab, and historical data does not appear.</div>
</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjzytCKVLLMFhEeMIckYLktntxSwaa44NreQhKNS0hn3PmPZ1eTKQEUtTOQirwi10SL0-i3O5labb2x9mPYRS_bmtzeV8vCmBebjfgidpRtBAvJ_vDmEUfytNjDLrLV1uPsuftn8-4l1sL/s1600/Cognos+Analysis+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjzytCKVLLMFhEeMIckYLktntxSwaa44NreQhKNS0hn3PmPZ1eTKQEUtTOQirwi10SL0-i3O5labb2x9mPYRS_bmtzeV8vCmBebjfgidpRtBAvJ_vDmEUfytNjDLrLV1uPsuftn8-4l1sL/s1600/Cognos+Analysis+Studio.jpg" height="320" width="288" /></a></div>
<div>
<br /></div>
<div>
10. Save the analysis as Returns vs Gross Profit over Time.</div>
<div>
<br /></div>
</div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-83211864300519286072014-02-13T20:23:00.002-08:002014-02-13T20:23:29.855-08:00Cognos Query Studio<div dir="ltr" style="text-align: left;" trbidi="on">
Using Query Studio, users with little or no training can quickly design, create and save reports to meet reporting needs not covered by the standard, professional reports created in Report Studio.<br />
<br />
<u>Example- Create a Query</u><br />
<u><br /></u>
Use IBM Cognos Query Studio to retrieve information from a relational data source when you want to create reports that answer simple business questions. Also use Query Studio to publish reports for audiences who do not require complex layout or formatting.<br />
<br />
In this exercise, you will learn how to<br />
<br />
<ul style="text-align: left;">
<li> Add columns</li>
<li> Add calculations</li>
<li> Add conditional formatting</li>
<li> Apply a template to the report</li>
<li> Save the report</li>
</ul>
<br />
<br />
You are a business analyst for the Sample Outdoors Company. You want to create a report that shows which products have the highest return rate and how much revenue was lost from product returns.<br />
<br />
To perform this exercise, you must have the appropriate licensing and security permissions.<br />
<br />
Things to notice:<br />
<br />
<ol style="text-align: left;">
<li>Data that you can add to the report has a different icon depending on the data type.</li>
<li>The reports that you create in Query Studio can be viewed and edited in IBM Cognos Report Studio.</li>
</ol>
<br />
<br />
<b>Procedure</b><br />
1. Open IBM Cognos Connection:<br />
a. Start your Web browser.<br />
b. In the address bar, type the URL supplied by your administrator, and then press Enter. The URL looks something like this: http://servername/cognos<br />
<br />
2. In the IBM Cognos Welcome page, click Query my data, and select the GOData Warehouse (query) package. A blank report appears.<br />
<br />
3. Add columns to the report:<br />
a. From the Menu, click Insert Data.<br />
b. Expand Sales and Marketing (query), Sales (query), and Products. Drag Product type and Product to the work area. The work area is the area within a studio that contains the report, analysis, query, or agent that you are currently using.<br />
c. From Sales (query), expand Sales fact, and drag Quantity and Unit cost to the work area. The item Unit cost will not appear in the final report, but you need it to build a calculation.<br />
d. Expand Returned items (query), and Returned items fact, and drag Return quantity to the work area.<br />
<br />
4. Create a calculation to show the lost revenue (Return quantity * Unit cost = Lost revenue):<br />
a. Select the column headings that you want for the calculation. In the work area, click the heading for Return quantity and Ctrl+click the heading for the Unit cost column.<br />
b. Click Calculate.<br />
c. In the Operation box, select * (multiplication).<br />
d. In the New item name box, type Lost revenue.<br />
e. Click Insert.<br />
f. Delete the Unit cost column.<br />
<br />
5. Format the calculated column that you added:<br />
a. Right-click the heading for the Lost revenue column and click Format Data.<br />
b. In the Category list, click Currency.<br />
c. In the Thousands separator list, click Yes, and then click OK.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqI6lyGGFAbetlCnFnu-8DjZCZ6TkHxN3JCKSOi8CcX0uG9YnpGLY3OvfU_mk6N6kDjNE55UMEI9UOq5ygboZtFdHOUMt2wObp67R6D_dVa5srX7wjU0BrpF_ccEGBaGXiKrpGQhJIfkGu/s1600/Cognos+Query+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqI6lyGGFAbetlCnFnu-8DjZCZ6TkHxN3JCKSOi8CcX0uG9YnpGLY3OvfU_mk6N6kDjNE55UMEI9UOq5ygboZtFdHOUMt2wObp67R6D_dVa5srX7wjU0BrpF_ccEGBaGXiKrpGQhJIfkGu/s1600/Cognos+Query+Studio.jpg" height="93" width="320" /></a></div>
<br />
6. Create a calculation to show the percentage of returns (Return quantity /Quantity)*100):<br />
a. In the work area, click the heading for the Return quantity column, and Ctrl+click the heading for the Quantity column.<br />
b. Click Calculate.<br />
c. In the Operation type box, select Percentage.<br />
d. The content of the Operation box changes to percent (%).<br />
e. In the New item name box, type % Returned.<br />
f. Click Insert.<br />
<br />
7. Sort the % Returned column in descending order:<br />
a. Right-click the heading for the % Returned column, and click Sort.<br />
b. Under Sort order, click Descending (9 to 1), and then click OK.<br />
<br />
8. Apply conditional formatting to highlight products with a lost revenue greater than $200,000:<br />
a. Click the heading for the Lost revenue column.<br />
b. From the Menu, click Change Layout, and click Define Conditional Styles.<br />
c. In the New value: box, type 200000, and click Insert.<br />
d. For the first range, in the Style column, select Poor, and click OK.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifrU7j2TmyLTbcqSIWkEb257Jl9fdh1Lm36v-D46j2hWUlbTnl28G_OXKE9vWEy59AVfjpdKUosO0DFAQeux0gtnNZ_WYQW4IhehVCx0FogeMjhtvTL4MXa8PnGVQa1jgWbF4VyeJlOgBg/s1600/Cognos+Query+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifrU7j2TmyLTbcqSIWkEb257Jl9fdh1Lm36v-D46j2hWUlbTnl28G_OXKE9vWEy59AVfjpdKUosO0DFAQeux0gtnNZ_WYQW4IhehVCx0FogeMjhtvTL4MXa8PnGVQa1jgWbF4VyeJlOgBg/s1600/Cognos+Query+Studio.jpg" height="138" width="320" /></a></div>
<br />
The cells with a lost revenue greater than $200,000 appear with a red background.<br />
<br />
9. Apply a template to the report:<br />
a. From the Menu, click Change Layout, and click Apply Template.<br />
b. Select Apply a template, and click Select a template.<br />
c. In Public Folders, click Samples, Sample Template. Select Great Outdoors Template, and click OK twice.The report appears with the styles from the template.<br />
<br />
10. Add a title to the report:<br />
a. Above the report, click the report title.<br />
b. In the Title box, type Returns by Product Type. Clear the Subtitle box, and click OK.<br />
<br />
11. Save the report:<br />
a. From the toolbar, click Save.<br />
b. In the Name box, type Returns by Product Type.<br />
c. Accept the default save location, and click OK.<br />
<br />
The final report looks like this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgC_9aumqDwmalm1gIbda2YxdwxkAfO0aqVkjgHOtTeiyLrIc7I6bhCQ5-XZxfwoeaWa4mmC15KY8eRw-k2VIlfLlWJWCh-AfgbcFchJ0W4alu0NFRCb6H93CIR0YcMiVt1epxI28hHTWHS/s1600/Cognos+Query+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgC_9aumqDwmalm1gIbda2YxdwxkAfO0aqVkjgHOtTeiyLrIc7I6bhCQ5-XZxfwoeaWa4mmC15KY8eRw-k2VIlfLlWJWCh-AfgbcFchJ0W4alu0NFRCb6H93CIR0YcMiVt1epxI28hHTWHS/s1600/Cognos+Query+Studio.jpg" height="224" width="320" /></a></div>
<br /></div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-44983972980587226402014-02-13T20:17:00.003-08:002014-02-13T20:17:22.514-08:00Cognos for Microsoft Office<div dir="ltr" style="text-align: left;" trbidi="on">
When you use IBM Cognos for Microsoft Office, you can work with secure IBM Cognos Business Intelligence content in your familiar Microsoft Office environment. You can retrieve report content from a variety of IBM Cognos applications, including IBM Cognos BI and IBM Cognos PowerPlay. IBM Cognos for Microsoft<br />
<br />
Office provides access to all IBM Cognos report content, including data, metadata, headers, footers, and charts. You can use predefined reports, or create new content using IBM Cognos Query Studio, IBM Cognos Analysis Studio, or IBM Cognos Report Studio.<br />
<br />
By importing content into Microsoft Excel spreadsheet software, you can work with the data and leverage Microsoft Excel's formatting, calculation, and presentation capabilities. You can also use the formatting and charting features of Microsoft Excel.<br />
<br />
By importing content into Microsoft PowerPoint and Microsoft Word, you can include reports and charts to enhance your presentations and documents.<br />
<br />
<u>Example- Work with Cognos Content in Microsoft Excel</u><br />
<u><br /></u>
You use IBM Cognos for Microsoft Office to access IBM Cognos content in Microsoft Excel spreadsheet software. In Excel, you can work with and add value to existing IBM Cognos reports, apply calculations, and use your existing Microsoft Excel macros. When you reconnect to the IBM Cognos server, you can refresh the data to obtain the latest information. You can also import content into Microsoft PowerPoint and Microsoft Word.<br />
<br />
IBM Cognos security is maintained in your Microsoft Office environment. For example, if you share a Microsoft Excel workbook with coworkers, when they connect to the IBM Cognos server to retrieve or refresh data, their security permissions retrieve the appropriate data.<br />
<br />
This exercise shows how to<br />
<br />
<ul style="text-align: left;">
<li>Import IBM Cognos content into a Microsoft Excel workbook</li>
<li>Refresh data</li>
<li>Publish a workbook to IBM Cognos Connection</li>
</ul>
<br />
<br />
<br />
You want to import the information from the two IBM Cognos Query Studio sample reports named Return Quantity by Product Line and Return Quantity by Product Line Chart into Microsoft Excel.<br />
<br />
To perform this exercise, you must have the appropriate licensing and security permissions. IBM Cognos for Microsoft Office as well as the .NET framework must be installed and configured on your computer.<br />
<br />
Things to notice:<br />
<br />
<ol style="text-align: left;">
<li>You use IBM Cognos for Microsoft Office to import IBM Cognos report elements, such as headers, footers, images, lists, and charts in your Microsoft Excel workbook. You can import elements from different reports into the same workbook.</li>
<li>When you save your workbook, you can save it with or without data.</li>
<li>You can publish workbooks to IBM Cognos Connection so that other users can access them.</li>
</ol>
<br />
<br />
<b>Procedure</b><br />
1. Start Microsoft Excel. The IBM Cognos for Microsoft Office pane appears on the right side.<br />
<br />
2. To begin using IBM Cognos for Microsoft Office, on the toolbar, click the Logon icon, select the server that you want to connect to, type your user ID and password, and click OK.<br />
<br />
3. Import the sample reports Return Quantity by Product Line and Return Quantity by Product Line Chart in the workbook:<br />
a. In the IBM Cognos for Microsoft Office pane, click the Browse Content tab.<br />
b. Expand Public Folders, Samples, Models, GO Data Warehouse (analysis), Query Studio Report Samples, and click Returns Quantity by Product Line.<br />
c. Click Import content. In the Import Content window, you can select the specific report elements<br />
that you want to import. You want to keep the default selections.<br />
d. Click Finish.<br />
e. Repeat the steps for the Return Quantity by Product Line Chart report.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAXXdpBaxKvs5DmIAkXhu3AR8nuyCXuoXXCoyVNic0_7teUMU7hVXoOb5Hx_09EX9Et52Q0CfOScaH3sPSRI2FrRQL1sn4LItTD8trXYEJzLrhhQ8vOvJXgxrd75rtKVKUo3T2_wT0eH8S/s1600/Cognos+with+Microsoft+Office.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAXXdpBaxKvs5DmIAkXhu3AR8nuyCXuoXXCoyVNic0_7teUMU7hVXoOb5Hx_09EX9Et52Q0CfOScaH3sPSRI2FrRQL1sn4LItTD8trXYEJzLrhhQ8vOvJXgxrd75rtKVKUo3T2_wT0eH8S/s1600/Cognos+with+Microsoft+Office.jpg" height="285" width="320" /></a></div>
<br />
<br />
The reports appear in the workbook.<br />
4. Refresh the data in the report:<br />
a. In the IBM Cognos for Microsoft Office pane, click the Manage Data tab. In the Imported report elements box, you can see all the elements in your workbook and their properties.<br />
b. Right-click the report and click Refresh Data and Formatting.<br />
Because the sample database is static, the report contents do not actually change.<br />
<br />
5. Publish the workbook to My Folders in IBM Cognos Connection:<br />
a. Save the workbook on your computer.<br />
Tip: To save the workbook without data, right-click the report and clickRemove Data. You can refresh all data later.<br />
b. From the IBM Cognos for Microsoft Office toolbar, click the publish icon.<br />
c. In the Publish window, select the IBM Cognos Business Intelligence server where you want to save the report, and click Publish.<br />
<br />
The workbook now appears in IBM Cognos Connection. To open a workbook from IBM Cognos Connection, select it and save it locally to your computer.</div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-5730486181830104772014-02-13T20:08:00.004-08:002014-02-13T20:08:57.081-08:00Cognos Metric Studio<div dir="ltr" style="text-align: left;" trbidi="on">
In Metric Studio, you can create and deliver a customized scorecarding environment for monitoring and analyzing metrics throughout your organization. Users can monitor, analyze, and report on time-critical information by using scorecards based on cross-functional metrics.<br />
<br />
<u>Example- Monitor Performance</u><br />
<u><br /></u>
With IBM Cognos Metric Studio, you can track the performance of your organization against its objectives. At a quick glance, decision makers at every level of the organization can see the status of the organization, and then react or plan.<br />
A metric is an indicator of key measures that compares actual results to targets. A metric also records who is responsible for the results and the impact of the metric.<br />
<br />
A scorecard is a collection of performance metrics and projects that reflects the strategic goals of a unit in an organization.<br />
<br />
This exercise shows how to<br />
<br />
<ol style="text-align: left;">
<li>Review a strategy map for a visual representation of the strategy and the objectives of that strategy for an organization</li>
<li>Review and understand the performance of a metric on a scorecard</li>
<li>Create an action on a metric</li>
<li>Add a metric to your watch list</li>
</ol>
<div>
<br /></div>
<br />
<div>
You are a sales manager for a region for the Sample Outdoors Company. You regularly look at a scorecard that contains metrics about your sales area. The metrics give you an instant idea of how the current sales compare to the sales targets set by the company. Return quantity is one of the metrics.</div>
<div>
<br /></div>
<div>
<div>
To perform this exercise, you must have the appropriate licensing and security permissions for this functionality. </div>
<div>
<br /></div>
<div>
Things to notice:</div>
</div>
<div>
<div>
<ul style="text-align: left;">
<li>Metrics appear as either Poor (red), Average (yellow), or Excellent (green).</li>
<li>For each metric, you can see whether the trend is improving, staying the same, or getting worse.</li>
<li>When you move your pointer over the title of a metric, you see a history chart that shows the performance of the metric. A fly-out menu extends when you pause your pointer over a metric or a diagram.</li>
</ul>
<div>
<br /></div>
</div>
</div>
<div>
<div>
<b>Procedure</b></div>
<div>
1. Open IBM Cognos Connection:</div>
<div>
a. Start your Web browser.</div>
<div>
b. In the address bar, type the URL supplied by your administrator, and then press Enter. The URL looks something like this: http://servername/cognos<br />
<br /></div>
<div>
2. In the IBM Cognos Welcome page, click Manage my metrics.<br />
<br /></div>
<div>
3. Click Samples, Models, GO Metrics.<br />
<br /></div>
<div>
4. View the strategy map:</div>
<div>
a. In the left pane, click the Scorecards tab, and click GO Consolidated.</div>
<div>
b. In the right pane, click the Diagrams tab. In the GO Strategy map, notice how you can quickly evaluate the performance of each of the goals of the organization.<br />
<br />
The large indicators show the status for a specific strategy. The smaller indicators that appear below a strategy show the trend. The values for metrics that are not performing well appear in red. Status and trend indicators that appear in red indicate possible problem areas. For example, in the Production and Distribution function of the strategy map, in the Control product quality metric, Return quantity % is red, which shows a poor performance metric.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIP9DssWFrH4euqsLqeS5RFqF97gBbLnii6JmC8OUbjE5F2ww83pZN-gg7CX0IS7pMLQ08IovA-K5MM_3LulTH6Lf0N2DgUr1e3B7GH5O2eoAkLY9cDw2g-o2Yd2i82fBsU1iF4Y6SHZKr/s1600/Cognos+Metric+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIP9DssWFrH4euqsLqeS5RFqF97gBbLnii6JmC8OUbjE5F2ww83pZN-gg7CX0IS7pMLQ08IovA-K5MM_3LulTH6Lf0N2DgUr1e3B7GH5O2eoAkLY9cDw2g-o2Yd2i82fBsU1iF4Y6SHZKr/s1600/Cognos+Metric+Studio.jpg" height="271" width="320" /></a></div>
<br />
5. Explore the scorecard:<br />
a. In the left pane, click the Scorecards tab.<br />
b. Expand GO Consolidated.<br />
You see that the Sample Outdoors Company has scorecards for each of the four functions of the company: Finance, Sales and Marketing, Production and Distribution, and Human Resource.<br />
c. Expand Production and Distribution, and click Asia Pacific.<br />
d. Click the Metrics tab.<br />
All the metrics associated with the Asia Pacific region are shown. Notice that the Asia Pacific Return by reason % Wrong product ordered metric is red. You might want to explore this metric further to see what is causing the problem.<br />
e. Click Asia Pacific Return quantity %, and click the Diagrams tab.<br />
f. Expand the metrics in the diagram by clicking the arrow next to the Asia Pacific Return by reason % Failed Orders metric. You can see what data is in the Return quantity % metric. You can also see which return reason has a critical issue.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiASsJgmu3659Urq2wdRjpB0B0rGOrJHiNbGykwoZIbg74pqGwdS7cNl8gBC8TXxtbtBL5swF2l-DgBk7XR0fmnsWyemFADGLteOROaBrbeMnrYBs7aAvhYck_87F09vZuJoUQY9OuD11if/s1600/Cognos+Metric+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiASsJgmu3659Urq2wdRjpB0B0rGOrJHiNbGykwoZIbg74pqGwdS7cNl8gBC8TXxtbtBL5swF2l-DgBk7XR0fmnsWyemFADGLteOROaBrbeMnrYBs7aAvhYck_87F09vZuJoUQY9OuD11if/s1600/Cognos+Metric+Studio.jpg" height="180" width="320" /></a></div>
<br />
g. Pause your pointer over Asia Pacific Return quantity % to see more information about that metric.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLBl16CcJP6A7tkUl2YwMGrmGnDGX_FlZf01smrdfekVjPM063PvG618qPRZiTMspYybbusvluDznDr1s4s_fqgsQ-KE5v5wdaSwanQsh-WVTNNSuHzYZm189Ex2sMY4K36IQ10uEwN0nx/s1600/Cognos+Metric+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLBl16CcJP6A7tkUl2YwMGrmGnDGX_FlZf01smrdfekVjPM063PvG618qPRZiTMspYybbusvluDznDr1s4s_fqgsQ-KE5v5wdaSwanQsh-WVTNNSuHzYZm189Ex2sMY4K36IQ10uEwN0nx/s1600/Cognos+Metric+Studio.jpg" height="185" width="320" /></a></div>
<br />
h. In the left pane, under Production and Distribution, click Asia Pacific, and then click the Metrics tab to view the metric related to return quantity. Notice that the status of Asia Pacific Return by reason % Wrong product ordered metric is poor.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8mtXQEVUBQZ-bLsr2d213Nyc63sQvmEpBinvfxyqNS-3SsB3Y0VMUzd-ijzTcurPNQZC0kgVNSPtH13STBfV0JlE6433siwrqA4KjseeK-JZChlnsPMv1kAgcyK7ElDJo5jSvCfV2guM1/s1600/Cognos+Metric+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8mtXQEVUBQZ-bLsr2d213Nyc63sQvmEpBinvfxyqNS-3SsB3Y0VMUzd-ijzTcurPNQZC0kgVNSPtH13STBfV0JlE6433siwrqA4KjseeK-JZChlnsPMv1kAgcyK7ElDJo5jSvCfV2guM1/s1600/Cognos+Metric+Studio.jpg" height="104" width="320" /></a></div>
<br />
<br />
6. Click the Asia Pacific-Return by reason %-Wrong product ordered metric. In Metric Studio, the tabs represent the questions you might ask yourself, as you try to solve a problem or understand a piece of information.<br />
<br />
7. On the right pane, on the History tab, click List. The information on the History tab answers the question "When?". You see the actual and target values for the metric data for previous periods. You also<br />
see quarterly and yearly summaries.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlQplzn3bg6HV0bfjx1B5nGiZF4wQpjQ1M-e-rJTi7UsNHSVzYwwhYuFPi80si0ekCQnErvVAorjzi4Djt5hYBZmXjyLJs6VqgCFT1sVUcdqvgvpAntco-qzC2nJxFXPj6FtJagoHmtJJ0/s1600/Cognos+Metric+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlQplzn3bg6HV0bfjx1B5nGiZF4wQpjQ1M-e-rJTi7UsNHSVzYwwhYuFPi80si0ekCQnErvVAorjzi4Djt5hYBZmXjyLJs6VqgCFT1sVUcdqvgvpAntco-qzC2nJxFXPj6FtJagoHmtJJ0/s1600/Cognos+Metric+Studio.jpg" height="203" width="320" /></a></div>
<br />
<br />
8. Click the Diagrams tab.<br />
The information in the Diagrams tab helps you understand the question "How?" by comparing your metric with other metrics. Impact diagrams show the relationships between the Return by reason % metric and other metrics.<br />
<br />
9. Create an action for one of your business analysts to have her investigate the performance of product returns:<br />
a. Click the Actions tab.<br />
b. Click New Action<br />
Tip: You must select a metric to see the New Action icon.<br />
c. In the Name box, type Kazumi Uragome, the person who will own the action.<br />
d. To let Kazumi know what to do, in the Description box, type Please investigate.<br />
e. Beside the Planned Finish box, click the calendar icon, select a date one week from today. Tip: You may need to scroll down to see the Planned Finish box.<br />
f. Click OK.<br />
<br />
10. Add the Asia Pacific Return reason % Wrong product ordered metric to your watch list so that you can easily monitor it in the future:<br />
a. In the left pane, in the Production and Distribution scorecard, click Asia Pacific, and click the Metrics tab.<br />
b. Click the Asia Pacific Return reason % Wrong product ordered metric.<br />
c. On the upper toolbar, click Add to Watch List , and click OK.<br />
d. In the left pane, click My Folders and click Watch List. The Asia Pacific Return by reason % Wrong product ordered metric appears in your watch list.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDLk_SJ-RamXnsiEx63ZLvgmG4t_E5J6UQ_G9DX5CykhZRMEtv6ducELAajE5m7cAF1tEAngIFuh9k99i0n1ezUo8AuknZH661KnY94Y4-tghfsGvG71UxEqYOvWgfbwEP1n3Gk1qBiKVY/s1600/Cognos+Metric+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDLk_SJ-RamXnsiEx63ZLvgmG4t_E5J6UQ_G9DX5CykhZRMEtv6ducELAajE5m7cAF1tEAngIFuh9k99i0n1ezUo8AuknZH661KnY94Y4-tghfsGvG71UxEqYOvWgfbwEP1n3Gk1qBiKVY/s1600/Cognos+Metric+Studio.jpg" height="62" width="320" /></a></div>
<br />
<div>
<br /></div>
<br /></div>
</div>
</div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-23001766377102647932014-02-13T19:39:00.000-08:002014-02-13T19:39:00.945-08:00Cognos Event Studio<div dir="ltr" style="text-align: left;" trbidi="on">
In Event Studio, you set up agents to monitor your data and perform tasks when business events or exceptional conditions occur in your data that must be dealt with. When an event occurs, people are alerted to take action. Agents can publish details to the portal, deliver alerts by email, run and distribute reports based on events, and monitor the status of events. For example, a support call from a key customer or the cancellation of a large order may trigger an event, sending an e-mail to the appropriate people.<br />
<br />
<u>Example- Manage an Event</u><br />
<u><br /></u>
Use IBM Cognos Event Studio to define business events or exceptional conditions in your data that require attention. Create agents to monitor your data and notify decision-makers in your organization of events as they happen, so that they can make timely and effective decisions. You create agents to perform tasks or deliver alerts when the data meets predefined thresholds.<br />
<br />
This exercise shows how to<br />
<br />
<ul style="text-align: left;">
<li> Define business events</li>
<li> Define agent tasks</li>
<li>Review the status of events</li>
</ul>
<div>
<br /></div>
<br />
<div>
You are a business analyst for the Sample Outdoors Company. You want to ensure that your customers are satisfied with the products and services that you provide. In particular, if products are returned, you want to investigate why, and ensure that you offer a replacement before your customers decide to shop elsewhere.</div>
<div>
<div>
Event Studio can notify you when a customer returns a product because it was defective, unsatisfactory, incomplete, or because the wrong product was shipped to them. You want to immediately send an email to your customer service department with details about the order and the customer, so that they can contact</div>
<div>
the customer. You will create an agent that looks like the Event Studio sample Returns Agent in</div>
<div>
the GO Sales (query) sample package.</div>
<div>
<br /></div>
<div>
To perform this exercise, you must have the appropriate licensing and security permissions.</div>
<div>
<br /></div>
<div>
The tasks that you need to perform to create an agent in Event Studio appear in the I want to area. By default, when you open Event Studio, you start with the first task, defining an event.</div>
<div>
<br /></div>
<div>
<b>Procedure</b></div>
<div>
1. Open IBM Cognos Connection:</div>
<div>
a. Start your Web browser.</div>
<div>
b. In the address bar, type the URL supplied by your administrator, and then press Enter. The URL looks something like this: http://servername/cognos</div>
<div>
<br /></div>
<div>
2. In the IBM Cognos Welcome page, click Manage my events to open Event Studio.</div>
<div>
<br /></div>
<div>
3. Click Samples, Models, GO Sales (query).</div>
<div>
<br /></div>
<div>
4. Create the expression that defines the event:</div>
<div>
a. In the Insertable Objects pane, expand Returned items (query) andReturned items.</div>
<div>
b. Under Returned items (query), expand Return reason.</div>
<div>
c. Use both Return quantity and Reason description to create the followingexpression: [Return quantity]>0 AND [Reason description] IN (’Wrong product shipped’,’Unsatisfactory product’,’Incomplete product’,’Defective product’) Tip: Insert items from the Insertable Objects pane. To select from a list of possible values for the return reason, click the select values button. Move the values you want from the Select Value box to the Selected Items box and click OK.</div>
<div>
d. Click the validate button to validate your expression. </div>
<div>
<br /></div>
<div>
Tip: You can also click Preview from the Actions menu to see the data retrieved from the data source. You defined the expression that will notify you whenever a customer returns a product because it was defective, unsatisfactory, incomplete, or because the</div>
<div>
wrong product was shipped to them.</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
5. Create an email task to immediately send an email to your customer service department with details about the returned order and the customer so that they can contact the customer:</div>
<div>
a. In the I want to list, click Add a task and click Send an email.</div>
</div>
<div>
<div>
b. In the To box, type the email address for the customer service department.</div>
<div>
Tip: Since this example is for learning purposes, the agent will not actually run. Therefore, you can type any email address.</div>
<div>
c. In the Subject, type Products Returned.</div>
<div>
d. Above the Body box, click the insert table button, specify four columns and two rows, and click OK.</div>
<div>
e. Add information about returned products to the table as follows: Manually type the text for the heading row of the table. Overwrite the insert text... text in each cell. Drag objects from the Insertable Objects pane to the bottom row of the table.</div>
<div>
Tip: In the Insertable Objects pane, expand Returned items (query). Expand Order to find Order number; Products to find Product; Returned items to find Return quantity, and Retailers to find Company name.</div>
</div>
<div>
<br /></div>
<div>
<div>
When the agent runs, the data item for each event is replaced by the current value in the package.</div>
<div>
f. Select the heading row and then click bold to make the column headings more prominent.<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg68TqYjChN6NSPJOj_w82Hnr9S9yfhr9B-Hae225tQmzd3-J72IKFp3ntj6z9w4a62bej3OtpqhlkIBpLL_voGQFu0gkPYn1RpaztWNN48SnwGJJdgsEe7FezARWUVszxnEPYUMpSI1KpF/s1600/Cognos+Event+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg68TqYjChN6NSPJOj_w82Hnr9S9yfhr9B-Hae225tQmzd3-J72IKFp3ntj6z9w4a62bej3OtpqhlkIBpLL_voGQFu0gkPYn1RpaztWNN48SnwGJJdgsEe7FezARWUVszxnEPYUMpSI1KpF/s1600/Cognos+Event+Studio.jpg" height="197" width="320" /></a></div>
</div>
</div>
<div>
<br /></div>
<div>
<div>
6. Set the execution rules so that a notification is sent for new events only:</div>
<div>
a. In the I want to list, click Manage the task execution rules.</div>
<div>
b. Click the Event Key tab.</div>
<div>
c. In the Insertable Objects pane, click the Source tab.</div>
<div>
d. Expand Sales (query), Order, and drag Order number to the Event key box.</div>
<div>
e. Click the Event Selection tab.</div>
</div>
<div>
<div>
f. Under Select when to perform this task, ensure that only the New events check box is selected.</div>
<div>
g. Click OK.</div>
</div>
<div>
<br /></div>
<div>
<div>
7. Set the schedule for when you want to the event to run:</div>
<div>
a. In the I want to list, click Schedule the agent.</div>
<div>
b. In the Set the schedule pane, under Frequency, click the By Day tab, and select Every 1 hour(s).</div>
<div>
c. Click OK.</div>
<div>
<br /></div>
<div>
8. Save the agent as Returns Agent. Each hour, the agent runs and the next time a customer returns a product, an email is sent to the customer service department with information about the order.</div>
</div>
<div>
<br /></div>
</div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-77001546785683902172014-02-13T19:31:00.002-08:002014-02-13T19:31:26.257-08:00Cognos Report Studio<div dir="ltr" style="text-align: left;" trbidi="on">
Using Report Studio, report authors create, edit, and distribute a wide range of professional reports. They can also define corporate-standard report templates for use in Query Studio, and edit and modify reports created in Query Studio or Analysis Studio.<br />
<br />
Use Report Studio for reports that<br />
<br />
<ul style="text-align: left;">
<li>Are intended for a wide audience</li>
<li>Exist long enough to require maintenance for changing requirements and data</li>
<li>Require detailed control over the appearance</li>
</ul>
<br />
<br />
Report Studio provides powerful functionality, such as bursting, prompts, maps, and advanced charting, and provides many ways to customize reports.<br />
<br />
<u>Example- Create a Report</u><br />
<u><br /></u>
Use IBM Cognos Report Studio to create reports with complex layout, formatting, and report user interactions. Such reports are usually created by professional report authors who have a good knowledge of the data and tools.<br />
<br />
In this exercise, you will learn how to:<br />
<br />
<ul style="text-align: left;">
<li>Create a chart</li>
<li>Make the report interactive with prompts</li>
</ul>
<br />
You are a business analyst for the Sample Outdoors Company. You create a chart report in Report Studio to show the performance of returns over the last few years. You make the report interactive by adding a prompt. You will create a report that looks like the Report Studio sample Returns by Order Method - Prompted Chart in the GO Data Warehouse (analysis) sample package. To perform this exercise, you must have the appropriate licensing and security permissions for this functionality.<br />
<br />
<br />
Things to notice:<br />
<br />
<ul style="text-align: left;">
<li>When you use Report Studio, data is not live. You must run the report to view data.</li>
<li>You can view the XML report specification.</li>
<li>You can add multilingual capabilities.</li>
</ul>
<br />
<div>
<b>Procedure</b></div>
<div>
<div>
1. Open IBM Cognos Connection:</div>
<div>
a. Start your Web browser.</div>
<div>
b. In the address bar, type the URL supplied by your administrator, and then press Enter. The URL looks something like this: http://servername/cognos</div>
<div>
<br /></div>
<div>
2. In the IBM Cognos Welcome page, click Author advanced reports to open Report Studio.</div>
<div>
<br /></div>
<div>
3. Click Samples, Models, GO Data Warehouse (analysis).</div>
<div>
<br /></div>
<div>
4. Click Create new, click Crosstab, and click OK.</div>
<div>
<br /></div>
<div>
5. Insert data in the crosstab zones:</div>
<div>
a. In the Source pane, expand Sales and Marketing (analysis), Returned items, Return reason, and Return reason. Drag Reason description to the Columns zone.</div>
<div>
b. Under Returned items, expand Returned items. Drag Return quantity to the Measures zone.</div>
<div>
c. Under Sales and Marketing (analysis), expand Inventory, Products, and Products. Drag Product line to the Rows zone.</div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJq5IXyj-Xiyxo0gtzSetXASGF25YcEaqxSKB162Fz7gxdrYa9G5wlOXgziUN2y8H86DzQp6xKsGx6NfQZ3agqBrx4pjcDMKaArCxttlnMpHLhEqcPprQTa6tSs-NYvLIdoT_NMExVMf-Y/s1600/Cognos+Report+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJq5IXyj-Xiyxo0gtzSetXASGF25YcEaqxSKB162Fz7gxdrYa9G5wlOXgziUN2y8H86DzQp6xKsGx6NfQZ3agqBrx4pjcDMKaArCxttlnMpHLhEqcPprQTa6tSs-NYvLIdoT_NMExVMf-Y/s1600/Cognos+Report+Studio.jpg" height="69" width="320" /></a></div>
<div>
<div>
<br /></div>
<div>
6. Click Run Report to run your report and verify the content. The report output appears in IBM Cognos Viewer.</div>
<div>
Tip: To return to Report Studio, close the IBM Cognos Viewer Web browser.</div>
</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGrxX5yOwFQhE-ebmCwz7T_6p-GoBNYmvkFsmYPrCIFlLjSgUMrKbJcF-TyQVACe0a_Phk2LZBn6q3XAuUzYVmIPIepNGxrNTmWEfhQjvtrwxkkUSInWBwIgPj14KbRkFTo-PXiJnohK7F/s1600/Cognos+Report+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGrxX5yOwFQhE-ebmCwz7T_6p-GoBNYmvkFsmYPrCIFlLjSgUMrKbJcF-TyQVACe0a_Phk2LZBn6q3XAuUzYVmIPIepNGxrNTmWEfhQjvtrwxkkUSInWBwIgPj14KbRkFTo-PXiJnohK7F/s1600/Cognos+Report+Studio.jpg" height="65" width="320" /></a></div>
<div>
<div>
<br /></div>
<div>
7. Insert another column in the report:</div>
<div>
a. In the Source pane, expand Sales, Time, and Time.</div>
<div>
b. Drag Year to the column after the Reason description column.</div>
<div>
<br /></div>
<div>
8. Insert a chart in the report:</div>
<div>
a. In the Source pane, click the Toolbox tab.</div>
<div>
b. Drag the Chart object below the crosstab.</div>
<div>
c. When the Insert Chart window opens, click the Column chart type.</div>
<div>
d. Select Fill with data and click OK. The data from the crosstab is automatically added to the chart.</div>
<div>
e. Click the chart to select it.</div>
</div>
<div>
<div>
f. In the Properties pane, underData properties, select the Query property. Select Query1 from the list. Tip: When you change the Query property to the query that you used for the crosstab, it becomes easier to find and reuse the same data items for the chart.</div>
</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2C7DBUdrQSp-gwaCo7F39PWJtdVDwohg7grdAdHi2fRZY7JfIVgoqCJdQUcQcp6X4iFeJA99ijB6MnfiOTeiIbSQRUFYpMkGa7Bd757mWvjDvq6_-AecUtqw4d3fMczLFT6JOwrjAVkdS/s1600/Cognos+Report+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2C7DBUdrQSp-gwaCo7F39PWJtdVDwohg7grdAdHi2fRZY7JfIVgoqCJdQUcQcp6X4iFeJA99ijB6MnfiOTeiIbSQRUFYpMkGa7Bd757mWvjDvq6_-AecUtqw4d3fMczLFT6JOwrjAVkdS/s1600/Cognos+Report+Studio.jpg" height="320" width="290" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<div>
9. Create a filter to exclude the Wrong product ordered return reason from the crosstab:</div>
<div>
a. In the crosstab, click the Reason description column heading.</div>
<div>
b. On the toolbar, click the arrow next to the Filter icon, and click Create Custom Filter.</div>
<div>
c. Under Condition, select Do NOT show the following values.</div>
<div>
d. Under Values, select Wrong product ordered and move it to the Selected values list.</div>
<div>
e. Click OK.</div>
<div>
<br /></div>
<div>
10. Create a prompt page for the order method to allow users to filter data in the report and retrieve data only for the order method they select:</div>
<div>
a. Click the background of the work area to clear.</div>
<div>
b. From the Tools menu, click Build Prompt Page.</div>
<div>
c. Use Ctrl+click to select the Back and Next buttons, and the Double click to edit text prompt page title (that are automatically created) and delete them.</div>
<div>
d. In the Source pane, click the Toolbox tab.</div>
<div>
e. Drag the Value Prompt object into the prompt page. The Prompt Wizard - Value Prompt window opens.</div>
</div>
<div>
<div>
f. Click Next.</div>
<div>
g. Beside the Package item box, click the ellipsis (...) button.</div>
<div>
h. When the Choose Package Item window opens, expand Sales and Marketing (analysis), Sales, and Order method.</div>
<div>
i. Click the Order method dimension, and then click OK.</div>
<div>
j. Click Next to accept the defaults, and click Finish.</div>
</div>
<div>
<br /></div>
<div>
<div>
11. Pause the pointer over the Page Explorer button on the Explorer bar. In Report Pages, click Page1 to return to the report page.</div>
<div>
Tip: Click the Prompt Pages folder title to remove or rename a page, or to edit properties.</div>
</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimSxwDKD2Wsb4l6zOxfIZrU8xsGEczWeNLPwNm2Vg5G9rATUalc7q9Vk_geJRzu2DIpHV3aJ4IaZ3fdpRU8Je1PiKADbrakpDy_AW4HoclgGkSV4BnrZQceMLcfUCFcGRE7Nmc03SwTsfv/s1600/Cognos+Report+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimSxwDKD2Wsb4l6zOxfIZrU8xsGEczWeNLPwNm2Vg5G9rATUalc7q9Vk_geJRzu2DIpHV3aJ4IaZ3fdpRU8Je1PiKADbrakpDy_AW4HoclgGkSV4BnrZQceMLcfUCFcGRE7Nmc03SwTsfv/s1600/Cognos+Report+Studio.jpg" height="320" width="315" /></a></div>
<div>
<br /></div>
<div>
<div>
12. Add a title to the report:</div>
<div>
a. Double-click the Double click to edit text title area, type Returns by OrderMethod, and click OK.</div>
<div>
<br /></div>
<div>
13. Save the report:</div>
<div>
a. From the File menu, click Save As.</div>
<div>
b. Name the report Returns by Order Method - Prompted Chart and click Save.</div>
<div>
<br /></div>
<div>
14. Run your report and verify the content:</div>
<div>
a. Click the run report button.</div>
<div>
b. In the Order method drop-down list, click E-mail and then click Finish. The report output appears in IBM Cognos Viewer.</div>
</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfGsdugA9tmta4LTEX5_MJkFfA9zylJr5tEayRh-8YXweDEb3J4E7fRgJTJKViq0S_fngD16lJB1YYuRISAYhwaUjur6RtmCQDGDs8r5_OngmOCyMfDzj78KvyySWth5B_ndxRmDxSJ-US/s1600/Cognos+Report+Studio.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfGsdugA9tmta4LTEX5_MJkFfA9zylJr5tEayRh-8YXweDEb3J4E7fRgJTJKViq0S_fngD16lJB1YYuRISAYhwaUjur6RtmCQDGDs8r5_OngmOCyMfDzj78KvyySWth5B_ndxRmDxSJ-US/s1600/Cognos+Report+Studio.jpg" height="222" width="320" /></a></div>
<div>
<br /></div>
</div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-84923096153913527212014-02-13T19:12:00.001-08:002014-02-13T21:39:39.768-08:00Cognos Workspace<div dir="ltr" style="text-align: left;" trbidi="on">
In IBM Cognos Workspace, you can create sophisticated interactive workspaces using IBM Cognos content, as well as external data sources such as TM1 Websheets and CubeViews, according to your specific information needs. You can view and open favorite workspaces and reports, manipulate the content in the workspaces, and e-mail your workspaces. You can also use comments, activities and social software such as IBM Connections for collaborative decision making.<br />
<br />
<br />
<u>Example- Work with a Workspace</u><br />
<br />
Use IBM Cognos Workspace to build sophisticated interactive workspaces that facilitate collaborative decision making. You can open workspace widgets in IBM Cognos Workspace Advanced to edit them.<br />
<br />
<br />
In this exercise, you will open a Cognos Workspace widget in Cognos Workspace Advanced to make changes and then view your changes in Cognos Workspace. You are a report author in the Sample Outdoors Company. You want to create a workspace showing employee training by organization level. You have a report widget that shows some of the information you need, so you decide to customize<br />
this widget and create a workspace for future reference.<br />
<br />
To perform this exercise, you must have the appropriate licensing and security permissions for this functionality.<br />
<br />
<b><u>Procedure</u></b><br />
<br />
1. Open Cognos Workspace:<br />
a. Start your Web browser.<br />
b. In the address bar, type the URL supplied by your administrator, and then press Enter. The URL looks something like this: http://servername/cognos<br />
<br />
2. In the IBM Cognos Welcome page, click Create a workspace on the web.<br />
<br />
3. Click Create New.<br />
<br />
4. In the Content tab of the Content pane, expand Public Folders, Samples,models, Go Data Warehouse (analysis), and Cognos Workspace Source Reports. Drag Employee Training Cost to the workspace.<br />
<br />
5. Click the Actions menu icon for the Employee Training widget, and then click Do More. The report widget opens in Cognos Workspace Advanced.<br />
<br />
6. Click the chart body to show the drop zones where you can insert data items.<br />
<br />
7. Delete Course cost in the Default measure (y-axis) drop zone.<br />
<br />
8. In the Source tab of the Content pane, expand HR (analysis), Employee training, and Employee training fact. Drag Course cost to replace Employee expense type in the Series (primary axis) drop zone.<br />
9. In HR (analysis), Employee training, expand Organization, Organization, and drag Organization name (level 1) to replace Organization (level 1) in the Categories (x-axis ) drop zone. 10. Click Done to return to Cognos Workspace. Note your changes to the Employee Training widget.<br />
<br />
11. On the application bar, click the Actions menu icon , and click Save as.<br />
<br />
12. Click My Folders, and type My Employee Training in the Name text box, and<br />
then click Save.<br />
<br />
The final report looks like this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5i4Oc1poXwb8_4MWIEFAaISUKF9QJaL9UylVL6PVwIw1yfasQ-wuVt5ySYOEzdTf6q8fgQ27SVOkKIPcKtDFT5EO9Pj12dfGrNCEDfcHQrxK8v6n4eXRX1EVs5wQRRNPQTk_XQBAzpmUg/s1600/Cognos+Workspace.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5i4Oc1poXwb8_4MWIEFAaISUKF9QJaL9UylVL6PVwIw1yfasQ-wuVt5ySYOEzdTf6q8fgQ27SVOkKIPcKtDFT5EO9Pj12dfGrNCEDfcHQrxK8v6n4eXRX1EVs5wQRRNPQTk_XQBAzpmUg/s1600/Cognos+Workspace.jpg" height="296" width="320" /></a></div>
<br />
<br />
With IBM Cognos Workspace Advanced, you can perform advanced data exploration and author simple reports.<br />
<br />
When you are in a workspace in IBM Cognos Workspace and want to perform deeper analysis and report authoring, you can seamlessly graduate to Cognos Workspace Advanced, where you can perform more advanced data exploration, such as adding additional measures, conditional formatting, and advanced<br />
calculations. You can also launch Cognos Workspace Advanced directly from the IBM Cognos Connection portal.<br />
<br />
With Cognos Workspace Advanced, you can create reports with relational or dimensional data sources, and that show data in lists, crosstabs, and charts. You can also use your own external data source. When you are using Cognos Workspace Advanced, if you open a report that was authored in IBM Cognos Report Studio, you can see the objects that can be inserted only in Report Studio, such as map. However, you cannot modify these objects.<br />
<br />
<u>Example- Create a Statement-Style Report</u><br />
<br />
Use IBM Cognos Workspace Advanced to create reports with relational or dimensional data sources and to how data in lists, crosstabs, and charts. In this exercise, you will learn how to create a statement-style report.<br />
<br />
You are a report author in the finance department of the Sample Outdoors Company. You create a balance sheet that shows the assets, liabilities, and equity for the company over the last few years. To perform this exercise, you must have the appropriate licensing and security permissions for this functionality.<br />
<br />
Things to notice:<br />
-When you use Cognos Workspace Advanced, data is live. You do not have to run a report to see the data. From the View menu, you can switch between the Page Design and Page Preview views to see the live data and the design of your report.<br />
<br />
<b>Procedure</b><br />
1. Open IBM Cognos Connection:<br />
a. Start your Web browser.<br />
b. In the address bar, type the URL supplied by your administrator, and then press Enter. The URL looks something like this: http://servername/cognos<br />
<br />
2. In the IBM Cognos Welcome page, click Author business reports.<br />
<br />
3. Click Samples, Models, GO Data Warehouse (analysis).<br />
<br />
4. Click Create new, click Financial, and click OK.<br />
<br />
5. Insert data in the crosstab zones:<br />
a. In the Content pane, click Insert Members with Children , and click Insert Single Member.<br />
b. In the Source tab of the Content pane, expand Finance (analysis), Finance, Account, and Balance sheet (total). Drag Assets (total) to the Rows zone.<br />
c. Under Balance sheet (total), expand Liabilities & equities (total). Drag Liabilities (total) and Equity (total) to the Rows zone, under Assets (total). Tip: When you drag an object to the crosstab, you see a flashing<br />
horizontal or vertical bar to indicate where the item will be placed in the crosstab.<br />
d. Expand Submission. Drag 2012 Actual results in USD to the Columns zone.<br />
e. Drag 2011 Actual results in USD to the Columns zone, next to 2012 Actual results in USD.<br />
f. Expand Time, 2012, and Q4 2012. Drag December 2012 to the Columns zone, under the 2012 Actual results in USD.<br />
g. Under Time, expand 2011 and Q4 2011. Drag December 2011 to the Columns zone, under the 2011 Actual results in USD.<br />
h. Under Finance (analysis), expand Finance fact. Drag Amount (year to date) to the Measures zone.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuM8OIlx-JEDqMgRLr85PlM_v_TXT5LS6fVRt8yolEutoj_DCtw3jYW1SJWQSCVLy7BTfwbef6PFj4uQgejJ6XO8xGfgv9zWJ6mShjs6NyVp5UT1nIUxYs4xlEj0_qOwfFX_JmSiuZuJGI/s1600/Cognos+Workspace+Advanced.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuM8OIlx-JEDqMgRLr85PlM_v_TXT5LS6fVRt8yolEutoj_DCtw3jYW1SJWQSCVLy7BTfwbef6PFj4uQgejJ6XO8xGfgv9zWJ6mShjs6NyVp5UT1nIUxYs4xlEj0_qOwfFX_JmSiuZuJGI/s1600/Cognos+Workspace+Advanced.jpg" height="96" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both;">
6. Expand the rows to view the breakdown of assets, liabilities, and equity:</div>
<div class="separator" style="clear: both;">
a. In the report, right-click Assets (total) and click Expand Member to examine the members of the assets.</div>
<div class="separator" style="clear: both;">
b. Repeat for Liabilities (total) and Equities (total).</div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
7. Change the title of the report to reflect the contents of the balance sheet:</div>
<div class="separator" style="clear: both;">
a. Double-click the heading title, type Sample Outdoors Company, and click OK.</div>
b. In the Toolbox tab of the Content pane, drag the Block object to the right of the Sample Outdoors Company title. Repeat the steps to add a second block underneath the first.<br />
c. In the Toolbox tab of the Content pane, drag the Text Item object inside the first block object. When the Text window opens, type balance sheet as at Dec 31, 2012, and click OK.<br />
d. Drag the Text Item object inside the second block object. When the Text window opens, type (with prior year comparative data), and click OK.<br />
e. Ctrl+click both block objects and, by using the toolbar, change the font to 10 point size (10 pt).<br />
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
8. Change the currency format of the balance sheet:</div>
<div class="separator" style="clear: both;">
a. In your report, under the 2011 Actual results in USD, under December 2011, use Shift+click to select the whole column.</div>
<div class="separator" style="clear: both;">
b. Right-click the selection, click Style, and click Data Format.</div>
<div class="separator" style="clear: both;">
c. In the Format type list, select Currency.</div>
<div class="separator" style="clear: both;">
d. In the Properties pane, click the Currency property, and select $ (USD) - United States of America, dollar.</div>
<div class="separator" style="clear: both;">
e. Click the No. of Decimal Places property, and then select 0.</div>
<div class="separator" style="clear: both;">
f. Click OK.</div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
9. Copy the formatting to the 2012 column:</div>
<div class="separator" style="clear: both;">
a. To copy all the formatting that is applied to the item, click Pick up Style, click the items that you want to format, and then click Apply Style.</div>
<div class="separator" style="clear: both;">
b. To copy only one of the formatting styles, click the down arrow next to the Pick up Style icon, and click the style that you want to copy. Then, click the item that you want to format, and click Apply Style.</div>
<div class="separator" style="clear: both;">
c. If you want to change a style that you copied, click the down arrow next to the Pick up Style icon, and click Edit Dropper Style. Specify basic and advanced style characteristics, and then click OK.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhf0EtVBc34DUHLvE0og_dLytX2_oAR1Ldp54-CNmXyNoFCpIcb_vukJJmPEJFlx56PLwxeYzeJ1dbMxE_VneM_EJi1tZM5pzb2WMH_Hs4ajL3FLX7UVtasOUas4p73BRO_LmGSjgayV7BK/s1600/Cognos+Workspace+Advanced.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhf0EtVBc34DUHLvE0og_dLytX2_oAR1Ldp54-CNmXyNoFCpIcb_vukJJmPEJFlx56PLwxeYzeJ1dbMxE_VneM_EJi1tZM5pzb2WMH_Hs4ajL3FLX7UVtasOUas4p73BRO_LmGSjgayV7BK/s1600/Cognos+Workspace+Advanced.jpg" height="169" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both;">
10. Change the text formatting to reflect a standard balance sheet:</div>
<div class="separator" style="clear: both;">
a. Right-click Amount (year to date) and click Edit Data Item Label.In the Data item label box, type Year to date (USD), and click OK.</div>
<div class="separator" style="clear: both;">
b. Select Year to date (USD) and, by using the toolbar, change the text to bold.</div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
11. From the Run menu, click Run Report - HTML.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt8FoFDZTbG4MJdJlBq67b-uP0Id9Gybj55ycJIbIDux-sQsSfYft6dVwnqsTRhITgz_8EYed2HwSj_lIiVa9CzdpL9PSr7RsczqtnHFKVLApAF_pRF8_a8Vdtt1veeHjUyAK20w-G8FAK/s1600/Cognos+Report.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt8FoFDZTbG4MJdJlBq67b-uP0Id9Gybj55ycJIbIDux-sQsSfYft6dVwnqsTRhITgz_8EYed2HwSj_lIiVa9CzdpL9PSr7RsczqtnHFKVLApAF_pRF8_a8Vdtt1veeHjUyAK20w-G8FAK/s1600/Cognos+Report.jpg" height="185" width="320" /></a></div>
<div class="separator" style="clear: both;">
<br /></div>
</div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-56308732199265718512014-02-13T19:07:00.000-08:002014-02-13T19:07:02.426-08:00Cognos Insight<div dir="ltr" style="text-align: left;" trbidi="on">
In IBM Cognos Insight, you can analyze data, explore scenarios, and influence decisions by creating personal or managed workspaces. Use these interactive workspaces to communicate results to managers.<br />
<br />
Because Cognos Insight supports write-back, you can also use these workspaces to gather and consolidate<br />
management targets, commitments, and forecasts.<br />
<br />
<br />
IBM Cognos Insight is provided with IBM Cognos BI. Use the IBM Cognos Connection Installer for Cognos Insight to install provisioning software on Cognos BI servers. This software allows multiple users to download and install IBM Cognos Insight on their computers from the Cognos Connection interface.</div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-27585974273433442082014-02-13T10:28:00.001-08:002014-02-13T19:46:00.288-08:00Cognos Connection<div dir="ltr" style="text-align: left;" trbidi="on">
<div>
IBM Cognos Connection is the Web portal for IBM Cognos Business Intelligence. It is the starting point to access your BI information and the functionality of IBM Cognos BI.</div>
<div>
<br /></div>
<div>
Use the portal to publish, find, manage, organize, and view your organization's business intelligence content, such as reports, scorecards, and agents. If you have the necessary permissions, you can access the various studios from the portal and use the portal for content administration, including scheduling and distributing reports, and creating jobs.You view reports in IBM Cognos Viewer.</div>
<div>
<br /></div>
<div>
System administrators also use the portal to administer servers, optimize performance, and set access permissions.</div>
<div>
<br /></div>
<div>
<u>Example 1 -How to Run a Report</u></div>
<div>
<br /></div>
<div>
<div>
IBM Cognos Connection is the Web portal that gives you access to all the IBM Cognos Business Intelligence functionality. In the portal, you can run reports.</div>
<div>
<br /></div>
<div>
In this exercise, you will learn how to</div>
<div>
v Navigate the portal</div>
<div>
v Run a report</div>
<div>
v Navigate within a report</div>
<div>
v Drill through from one report to another</div>
<div>
v View the report in a different format</div>
</div>
<div>
<br /></div>
<div>
<div>
You are a business analyst for the Sample Outdoors Company. You are asked to study the percentage of returned products. Returned items reveal important information about the quality of products, especially products that are returned because they are defective or are missing parts.</div>
<div>
<br /></div>
<div>
You will drill down to more detailed information in the pie chart, drill back up to the beginning, then drill through to another report using the data shown in your current report as a filter.</div>
<div>
<br /></div>
<div>
Things to notice:</div>
<div>
1)The icon for a report shows the default format and default action of the report.</div>
<div>
2)Reports that have saved outputs have an additional icon in the Actions column.</div>
<div>
3) At any time, you can click the arrow next to the help button, and click Go to the Welcome Page to return to the IBM Cognos Welcome page.</div>
</div>
<div>
<br /></div>
<div>
<div>
Procedure</div>
<div>
1. Open IBM Cognos Connection:</div>
<div>
a. Start your Web browser.</div>
<div>
b. In the address bar, type the URL supplied by your administrator, and then press Enter. The URL looks something like this: http://servername/cognos</div>
<div>
<br /></div>
<div>
2. In the IBM Cognos Welcome page, click IBM Cognos content.InthePublic Folders tab, click Samples, Models, GO Data Warehouse (analysis), and Query Studio Report Samples.</div>
<div>
<br /></div>
<div>
3. Locate the Return Quantity by Product Line Chart report. Tip: The icon beside an entry identifies its default action. The default action for this report is to open it in IBM Cognos Query Studio. Instead, you want to run the report in HTML format in the viewer.</div>
<div>
<br /></div>
<div>
4. Under Actions, click the Run with Options icon next to the report, accept the defaults, and then click Run.</div>
<div>
<br /></div>
<div>
The report runs and opens with the latest data about product returns.</div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj58U3lOiqKL0T1PWvzVkBnAvL3eOzBX0yZrdKY4afckOUfoeo0aoamUJFHodWwrGnJyLemjd9i8aVdsbC470n14jvKp7cIjRjqPK_yTSAVS1aT9F236xMIyGLHY1r0DAZRlKweGNwWefkf/s1600/Cognos+Run+a+Report.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj58U3lOiqKL0T1PWvzVkBnAvL3eOzBX0yZrdKY4afckOUfoeo0aoamUJFHodWwrGnJyLemjd9i8aVdsbC470n14jvKp7cIjRjqPK_yTSAVS1aT9F236xMIyGLHY1r0DAZRlKweGNwWefkf/s1600/Cognos+Run+a+Report.png" height="320" width="291" /></a></div>
<div>
<br /></div>
<div>
<div>
5. Click the Outdoor Protection slice in the pie chart to drill down to more detailed information.</div>
<div>
Tip: You can also drill down by right-clicking or by clicking the legend label. At a quick glance, you notice that insect repellents have the highest number of returns.</div>
<div>
6. Drill down on Insect Repellents. You notice that the BugShield Lotion has the highest number of returns. You want to drill up to go back to where you started in this report.</div>
<div>
7. Drill up twice to return to the high-level product returns data. To do so,right-click any area on the pie chart and click Drill Up, then repeat this step to drill up again.</div>
<div>
<br /></div>
<div>
<div>
Example</div>
<div>
Use IBM Cognos Connection to try the following report features: - On the toolbar, click the Home or Return icon to return to the portal.- Change the report format to PDF.</div>
<div>
<br /></div>
<div>
Tip: Click Run with Options on the actions toolbar. From the Format list, select PDF, and click Run.</div>
<div>
<br /></div>
<div>
-Change the report to a different language. To do so, change the language settings in IBM Cognos Connection or in your Web browser, and then run the report again. Because the sample data is multilingual, all data will be translated.</div>
<div>
<br /></div>
<div>
Tip: Click My Area Options</div>
<div>
, My Preferences. Under Regional options,change the Product language and the Content language. To see the content language changes, you must run the report.<br />
<br />
<br />
<u>Example 2 : Schedule a Report</u><br />
<br />
You can schedule entries that are stored in IBM Cognos Connection, such as reports, queries, and agents, so that they run at a time that is convenient for you.<br />
<br />
In this exercise, you will learn how to<br />
- Save a report as a report view<br />
- Schedule a report so it runs daily<br />
- Use the schedule management tool to view the status of the schedule<br />
<br />
You are a business analyst for the Sample Outdoors Company. You want to schedule the Return Quantity by Product Line Chart report because some people in your organization need the data updated daily. You schedule the report to run daily, and then check that it is properly scheduled.<br />
<br />
Things to notice:<br />
<br />
<ul>
<li>When a report runs according to a schedule, the report output is saved, and appears in the Action column in IBM Cognos Connection.</li>
<li>At any time, you can click the arrow next to the Help button, and click Go to the Welcome Page to return to the IBM Cognos Welcome page.</li>
</ul>
<div>
<br /></div>
<br />
<div>
<b>Procedure</b></div>
<br />
<div>
</div>
<br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<div>
<div style="margin: 0px;">
1. Open IBM Cognos Connection:</div>
</div>
<div style="text-align: left;">
<div style="margin: 0px;">
a. Start your Web browser.</div>
</div>
<div>
<div style="margin: 0px;">
b. In the address bar, type the URL supplied by your administrator, and then press Enter. The URL looks something like this: http://servername/cognos</div>
</div>
<div>
<div style="margin: 0px;">
<br /></div>
</div>
<div>
<div style="margin: 0px;">
2. In the IBM Cognos Welcome page, click IBM Cognos content.InthePublic Folders tab, click Samples, Models, GO Data Warehouse (analysis), and Query Studio Report Samples.</div>
</div>
<div>
<div style="margin: 0px;">
<br /></div>
</div>
<div>
<div style="margin: 0px;">
3. Locate the Return Quantity by Product Line Chart report. You can also use any one of the IBM Cognos sample reports.</div>
</div>
<div>
<div style="margin: 0px;">
<br /></div>
</div>
<div>
<div style="margin: 0px;">
4. Create a report view for a daily view of the report:</div>
</div>
<div>
<div style="margin: 0px;">
a. Under Actions, click the Report View icon next to the report.</div>
</div>
<div>
<div style="margin: 0px;">
b. In the Name box, remove the words Report View of from the beginning of the name, type (daily) at the end of the name, and click Finish.A new entry appears in IBM Cognos Connection, with the report view icon.</div>
</div>
<div>
<div style="margin: 0px;">
<br /></div>
</div>
<div>
<div style="margin: 0px;">
5. Schedule the report view to run daily:</div>
</div>
<div>
<div style="margin: 0px;">
a. Click the Schedule icon next to the entry.</div>
</div>
<div>
<div style="margin: 0px;">
b. Under Frequency, click the By Day tab.</div>
</div>
<div>
<div style="margin: 0px;">
c. Accept the default time and other defaults.</div>
</div>
<div>
<div style="margin: 0px;">
d. Click OK.</div>
</div>
<div>
<div style="margin: 0px;">
<br /></div>
</div>
<div>
<div style="margin: 0px;">
6. Check the schedule:</div>
</div>
<div>
<div style="margin: 0px;">
a. Click My Area Options , My Activities and Schedules.</div>
</div>
<div>
<div style="margin: 0px;">
b. Click Schedules.</div>
</div>
<div>
<div style="margin: 0px;">
c. In the Filter pane, select Any status and Any priority, and click Apply.</div>
<div style="margin: 0px;">
<br /></div>
<div style="margin: 0px;">
Results</div>
<div style="margin: 0px;">
Your report view appears in the list of scheduled reports.</div>
<div style="margin: 0px;">
<br /></div>
<div class="separator" style="clear: both; margin: 0px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7IhpA5LG1asKxt2CW1Q5P2oQepw8StM-9pLnkTlhtBdWnfSjCKLvrds5BhI51AcxLkd20ZElrPSoT3bqDe5_4rQTf-wlxdH3RRlpSI3E_uybr59jtXM_yAcaOfFmNwZpNGfIHLywrQsgS/s1600/Cognos+Schedule+a+Report.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7IhpA5LG1asKxt2CW1Q5P2oQepw8StM-9pLnkTlhtBdWnfSjCKLvrds5BhI51AcxLkd20ZElrPSoT3bqDe5_4rQTf-wlxdH3RRlpSI3E_uybr59jtXM_yAcaOfFmNwZpNGfIHLywrQsgS/s1600/Cognos+Schedule+a+Report.png" height="83" style="cursor: move;" width="320" /></a></div>
<div style="margin: 0px;">
<br /></div>
<div style="margin: 0px;">
<br /></div>
<div style="margin: 0px;">
<u>Example 3- How to create a Portal page</u></div>
<div style="margin: 0px;">
<br /></div>
<div style="margin: 0px;">
You can customize the IBM Cognos Connection portal by creating your own portal pages. You can choose the information that is most important to you and make it available from your page. Choose from different types of content and organize the pages in a way that works for you.</div>
<div style="margin: 0px;">
<br /></div>
<ul>
<li>This exercise shows how to</li>
<li>Create a page</li>
<li>Add content to a page</li>
<li>Define the appearance of a page</li>
<li>Enhance the content of a page</li>
</ul>
<div style="margin: 0px;">
<br /></div>
<div style="margin: 0px;">
You want to create a personal page that includes all of the reports and content that you worked on in the previous exercises so that you can easily view the content each time you log on to IBM Cognos Business Intelligence.</div>
<div style="margin: 0px;">
<br /></div>
<div style="margin: 0px;">
Things to notice:</div>
<div style="margin: 0px;">
<br /></div>
<ul>
<li>In a portal page, you can add IBM Cognos content (such as business intelligence reports), utilities (such as URLs and bookmarks), and third-party portlets.</li>
<li>You can make a portal page available to a group in your organization, such as to the sales team, or you can create a portal page for your personal use.</li>
</ul>
<div>
<div style="margin: 0px;">
<br /></div>
</div>
<div>
<div>
<div style="margin: 0px;">
<b>Procedure</b></div>
</div>
<div>
<div style="margin: 0px;">
1. Open IBM Cognos Connection:</div>
</div>
<div>
<div style="margin: 0px;">
a. Start your Web browser.</div>
</div>
<div>
<div style="margin: 0px;">
b. In the address bar, type the URL supplied by your administrator, and then press Enter. The URL looks something like this: http://servername/cognos</div>
</div>
<div>
<div style="margin: 0px;">
<br /></div>
</div>
<div>
<div style="margin: 0px;">
2. In the IBM Cognos Welcome page, click IBM Cognos content and then click New Page</div>
</div>
<div>
<div style="margin: 0px;">
.</div>
</div>
<div>
<div style="margin: 0px;">
3. Type the name My Sample Outdoors page, click Select My Folders as the location for the new page, and click Next.</div>
</div>
<div>
<div style="margin: 0px;">
<br /></div>
</div>
<div>
<div style="margin: 0px;">
4. Specify the page layout:</div>
</div>
<div>
<div style="margin: 0px;">
a. Under Number of columns, select two columns.</div>
</div>
<div>
<div style="margin: 0px;">
b. Change the width of the first column to 40% and the second column to 60%.</div>
</div>
<div>
<div style="margin: 0px;">
<br /></div>
</div>
<div>
<div style="margin: 0px;">
5. Add content to your page:</div>
</div>
<div>
<div style="margin: 0px;">
a. Under the first column, click Add.</div>
</div>
<div>
<div style="margin: 0px;">
b. Click IBM Cognos Content.</div>
</div>
</div>
<div>
<div style="margin: 0px;">
<br /></div>
</div>
<div>
<div>
<div style="margin: 0px;">
c. Select the IBM Cognos Navigator, IBM Cognos Search, and IBM Cognos Viewer portlets. Click Add</div>
</div>
<div>
<div style="margin: 0px;">
to move them to the Selected entries box.</div>
</div>
<div>
<div style="margin: 0px;">
Tip: You can preview the content of the portlets by clicking View This Portlet.</div>
</div>
<div>
<div style="margin: 0px;">
d. Click OK.</div>
</div>
<div>
<div style="margin: 0px;">
e. In the first column, click IBM Cognos Viewer and click the right arrow</div>
</div>
<div>
<div style="margin: 0px;">
.</div>
<div class="separator" style="clear: both; margin: 0px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVh_PNr3E81LcVptl2lCP_IdX58bBKPLJ_mklDLfxlneIjTljhe7KM_JLp0S35UnF0CZCUWr_BeyN6Ib4U728WUVinOFo_chPSRAvqfi5krswbTlIsVBUgXDHJggvo17tqfX7QAgEfjY9n/s1600/Cognos+Create+a+Portal.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVh_PNr3E81LcVptl2lCP_IdX58bBKPLJ_mklDLfxlneIjTljhe7KM_JLp0S35UnF0CZCUWr_BeyN6Ib4U728WUVinOFo_chPSRAvqfi5krswbTlIsVBUgXDHJggvo17tqfX7QAgEfjY9n/s1600/Cognos+Create+a+Portal.png" height="218" style="cursor: move;" width="320" /></a></div>
<div class="separator" style="clear: both; margin: 0px; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; margin: 0px; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; margin: 0px;">
f. Click Next.</div>
<div class="separator" style="clear: both; margin: 0px;">
<br /></div>
<div class="separator" style="clear: both; margin: 0px;">
6. Define the appearance of the page:</div>
<div class="separator" style="clear: both; margin: 0px;">
a. In the Title box, type My Sample Outdoors page. Tip: You can change the formatting of the text.</div>
<div class="separator" style="clear: both; margin: 0px;">
b. Click Next.</div>
<div class="separator" style="clear: both; margin: 0px;">
c. Select the Add this page to the portal tabs check box.</div>
<div class="separator" style="clear: both; margin: 0px;">
d. Click Finish.</div>
<div class="separator" style="clear: both; margin: 0px;">
The My Sample Outdoors page that you created appears as a tab in IBM Cognos Connection.</div>
<div class="separator" style="clear: both; margin: 0px;">
<br /></div>
<div class="separator" style="clear: both; margin: 0px;">
7. Enhance the content of your page:</div>
<div class="separator" style="clear: both; margin: 0px;">
a. Click the My Sample Outdoors page tab.</div>
<div class="separator" style="clear: both; margin: 0px;">
b. In the IBM Cognos Viewer portlet title bar, click Edit.</div>
<div class="separator" style="clear: both; margin: 0px;">
c. Under Entry, click Select an entry. Click Public Folders, Samples, Models,GO Data Warehouse (analysis), and Query Studio Report Samples. Selectthe Return Quantity by Product Line Chart sample report and click OK.</div>
<div class="separator" style="clear: both; margin: 0px;">
Tip: You can also use any other sample report.</div>
<div class="separator" style="clear: both; margin: 0px;">
d. Under Height (pixels), type 600.</div>
<div class="separator" style="clear: both; margin: 0px;">
e. Click OK.</div>
<div class="separator" style="clear: both; margin: 0px;">
The report now appears in your portal page.</div>
<div class="separator" style="clear: both; margin: 0px;">
<br /></div>
<div class="separator" style="clear: both; margin: 0px;">
If the report was not previously run and saved, click the run button in the IBM Cognos Viewer portlet. In the Run with options page, click Save the report and then click Run.</div>
<div class="separator" style="clear: both; margin: 0px;">
<br /></div>
<div class="separator" style="clear: both; margin: 0px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZ59BKstemTRI2pJ5IwDiMXNe2dyhBPNRS78csOC7OEtDLjjAQvBat18arp0l3WWbo3jfu_qpvOkeJQYJ81xaj4ZVWiBnz_9xUr3FDuJPiQDS8YM7m0OeWlRpWzDZVogZRMalhujgKuzyz/s1600/Cognos+Portal.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZ59BKstemTRI2pJ5IwDiMXNe2dyhBPNRS78csOC7OEtDLjjAQvBat18arp0l3WWbo3jfu_qpvOkeJQYJ81xaj4ZVWiBnz_9xUr3FDuJPiQDS8YM7m0OeWlRpWzDZVogZRMalhujgKuzyz/s1600/Cognos+Portal.jpg" height="227" style="cursor: move;" width="320" /></a></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<br /></div>
</div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-50509604876471974382010-03-25T06:45:00.000-07:002010-03-25T06:51:23.311-07:00COG-180 : IBM Cognos 8 BI Professional<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgN5y9qBOd-DjO-b_Zygaqs0aAK11jm2jOfZ3IWDdZHiIO3RLgCTDBeConrSO5w075fq3pQJOAlCh_UnzLSNDalg9ckZlKREYWfJ0SKvBx1wGXuYZdF7h6_iNhP0Z0akWTV8KFsriSpm97E/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 236px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgN5y9qBOd-DjO-b_Zygaqs0aAK11jm2jOfZ3IWDdZHiIO3RLgCTDBeConrSO5w075fq3pQJOAlCh_UnzLSNDalg9ckZlKREYWfJ0SKvBx1wGXuYZdF7h6_iNhP0Z0akWTV8KFsriSpm97E/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452567575511272530" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixwT6tkOS0xdje15dze0QXCf5TeFYlXxQCwIAu_Oz-qvCJ7q9kY3y8jdrOdHYh0DQ9Vu4KK19DEZhjTUjMktQuzDypk2wA0mryIAmCpYr5JMM00GMgSURAG2hCNv-74yPHoeatf4lykyWv/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 127px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixwT6tkOS0xdje15dze0QXCf5TeFYlXxQCwIAu_Oz-qvCJ7q9kY3y8jdrOdHYh0DQ9Vu4KK19DEZhjTUjMktQuzDypk2wA0mryIAmCpYr5JMM00GMgSURAG2hCNv-74yPHoeatf4lykyWv/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452568029229439362" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifScTVSJguactra1F-vWs_dnLAPmUVol-BFGjmeumbvIQQjxs9cHjR4dwnp1jhi45OfvrKk-tI92CDEJeXQ4eSAjy3IlikdmohgyeneQ_OXbSA7TtCyYkXViQD1h51J4pnWONRuZNz3Jn8/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 215px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifScTVSJguactra1F-vWs_dnLAPmUVol-BFGjmeumbvIQQjxs9cHjR4dwnp1jhi45OfvrKk-tI92CDEJeXQ4eSAjy3IlikdmohgyeneQ_OXbSA7TtCyYkXViQD1h51J4pnWONRuZNz3Jn8/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452568601291835106" /></a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-53946985727028780872010-03-25T06:37:00.000-07:002010-03-25T06:52:20.530-07:00COG-145 : IBM Cognos 8 BI Multidimensional Author<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjN6YN0Vh3-OSI_7cDxnmVj7gnQeMLXOIerGNFXpLV5lDt4r9xBAFO1q0qm8Zp3yBcct0lu2t3S0K9V9iBSfwAjjA-v5WzsCQ7S5MrOcs08WHTZT1WFdX19qKdyFtlVISU2vHYtYkkqGrgG/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 233px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjN6YN0Vh3-OSI_7cDxnmVj7gnQeMLXOIerGNFXpLV5lDt4r9xBAFO1q0qm8Zp3yBcct0lu2t3S0K9V9iBSfwAjjA-v5WzsCQ7S5MrOcs08WHTZT1WFdX19qKdyFtlVISU2vHYtYkkqGrgG/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452566088672723986" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMRCj-MRxmUDDD5VvVu5YEfHw-9ls0d5xAHynVW4byvLha_UwRdWDYyqvD8Z5pTFAK01ki7JSUcoT-TXvCe3xGKwrtW_G8IdSuFnLTDdDPcIIVoDJNO7VTeTujaGn_g693vBXv6QPrziBZ/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 164px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMRCj-MRxmUDDD5VvVu5YEfHw-9ls0d5xAHynVW4byvLha_UwRdWDYyqvD8Z5pTFAK01ki7JSUcoT-TXvCe3xGKwrtW_G8IdSuFnLTDdDPcIIVoDJNO7VTeTujaGn_g693vBXv6QPrziBZ/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452566379879847458" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijp6GKP4dhYdd87cht1NGqDGhjL258gLn7jsg8tkmfBXtitliHjNFb_xhil6eYv49bHBoc4wJBRezZzaKCuxW1o_eaXsEVnQiujPT4EdQs9ZWHDMjTITaMHs8-Jt5UmX6i_5EWnVegdMI3/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 131px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijp6GKP4dhYdd87cht1NGqDGhjL258gLn7jsg8tkmfBXtitliHjNFb_xhil6eYv49bHBoc4wJBRezZzaKCuxW1o_eaXsEVnQiujPT4EdQs9ZWHDMjTITaMHs8-Jt5UmX6i_5EWnVegdMI3/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452567016693109682" /></a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-84365540619953607012010-03-25T06:32:00.000-07:002010-03-25T06:52:20.537-07:00COG-142 : IBM Cognos 8 BI Scorecard Developer<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9aa-lPWV62hw1YjPYuyWjanwcrnNm4_kxS1ZBN6fohroqcD-gzQkshki9bM8NW83q75WoVJkyb8sja7A-jIFZ6zETcSlujNVVAnBoNglrLz-_TgG2fOaKrL5_KeOI2QF6jL66dWr1E3Ek/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 255px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9aa-lPWV62hw1YjPYuyWjanwcrnNm4_kxS1ZBN6fohroqcD-gzQkshki9bM8NW83q75WoVJkyb8sja7A-jIFZ6zETcSlujNVVAnBoNglrLz-_TgG2fOaKrL5_KeOI2QF6jL66dWr1E3Ek/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452564467706244754" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxu53NqxtXVal6Gxs4cc-B6r1E-I4dP8fBmkEo_yOfA4-jky9AJdoA9CLMAObMBh8d76nhMcdirgiQJW-jJHg_9FpO-vgUhI6ELdR4JLZ59hvTWPAsNkxxQR2XnJBxlD_pKim5VIgnUKvP/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 174px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxu53NqxtXVal6Gxs4cc-B6r1E-I4dP8fBmkEo_yOfA4-jky9AJdoA9CLMAObMBh8d76nhMcdirgiQJW-jJHg_9FpO-vgUhI6ELdR4JLZ59hvTWPAsNkxxQR2XnJBxlD_pKim5VIgnUKvP/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452564778437869394" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmXrJfqYQuo93sI1hfdzdiLSIv-g_4UQVdQB0qIqgfUHVQfuve2rPuDkzoB7vnUZHbiNidQ1zOzpLjDivH0iNf4dJhyphenhyphenwZ6yv4if7ivDYLfPT3G37HIXVS-Wv_bjzVAVOguiwYrumqG0Zlp/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 232px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmXrJfqYQuo93sI1hfdzdiLSIv-g_4UQVdQB0qIqgfUHVQfuve2rPuDkzoB7vnUZHbiNidQ1zOzpLjDivH0iNf4dJhyphenhyphenwZ6yv4if7ivDYLfPT3G37HIXVS-Wv_bjzVAVOguiwYrumqG0Zlp/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452565090714442754" /></a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-74424376699423944732010-03-25T06:27:00.000-07:002010-03-25T06:52:20.541-07:00COG-135 : IBM Cognos 8 BI OLAP Developer<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5eiBsyAl_7dvd374H7pP_dWEVFVc1qeawas06jy-1s36IOnb8heRDCzvCymUFCypjmklDZEuL1RLqwwk-vQ9pyD6rASz1gV4m-gzZktdcdvtnC9vr_XOb5E4Z3bQpnhB99AeBJHW3Bojt/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 261px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5eiBsyAl_7dvd374H7pP_dWEVFVc1qeawas06jy-1s36IOnb8heRDCzvCymUFCypjmklDZEuL1RLqwwk-vQ9pyD6rASz1gV4m-gzZktdcdvtnC9vr_XOb5E4Z3bQpnhB99AeBJHW3Bojt/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452563038542334338" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5RxsMACim0fRniiN2o3Pj0WnjTS0jY_6yD2dvaxkYu1loYG-TAif9FN9ama8whicqpSYWkbcSrwRD3FzPrmJz-nSJZPzBVGCBb8gHo-CkmvH3O6sKjWUu1z0f_3RRmOqKAzP_VLAnMldX/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 153px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5RxsMACim0fRniiN2o3Pj0WnjTS0jY_6yD2dvaxkYu1loYG-TAif9FN9ama8whicqpSYWkbcSrwRD3FzPrmJz-nSJZPzBVGCBb8gHo-CkmvH3O6sKjWUu1z0f_3RRmOqKAzP_VLAnMldX/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452563382103756866" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhx1g5SATkokYRw9t9H1ULKBwuXeqypaVGfQ2FNiys1spUMMQYSxdl4NTfWr-qDvFCspLpg7-pW2Zi_5CMXjIBzltb9UpHQvBflj7naxtuj9RQsgY3urienLn6IWLu8_9WJyM2Yrxo5OHcd/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 151px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhx1g5SATkokYRw9t9H1ULKBwuXeqypaVGfQ2FNiys1spUMMQYSxdl4NTfWr-qDvFCspLpg7-pW2Zi_5CMXjIBzltb9UpHQvBflj7naxtuj9RQsgY3urienLn6IWLu8_9WJyM2Yrxo5OHcd/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452563726961945250" /></a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-41547910178487624132010-03-25T06:21:00.000-07:002010-03-25T06:52:20.548-07:00COG-132 : IBM Cognos 8 BI Metadata Model Developer<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtzfeHzF7n3WREe_gl9ax598FAJtg9K5vOGxCx8HiaNA6emcX4IVKW3eA2IVuBqOzf__CU0zcvi2lJgOGVel-KrhcpQOqBedF1AgFBss1bP1UyZkVATlpp8RuZmKZhAHaa2n0qz2ZGZBCa/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 260px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtzfeHzF7n3WREe_gl9ax598FAJtg9K5vOGxCx8HiaNA6emcX4IVKW3eA2IVuBqOzf__CU0zcvi2lJgOGVel-KrhcpQOqBedF1AgFBss1bP1UyZkVATlpp8RuZmKZhAHaa2n0qz2ZGZBCa/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452561679317767234" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlIS1yHOQOGMg1p8yS3IY_uLLUSpfAKeJ7JtrgFqWDzy87zYm5SAfEymi-mvvjQH8yhOmdLV829r6Dq867SQbJSe8NPauzLMpu8p4GA40BoFXLcsDJLJpONcLsc6eNQCawjCfB4ltzDoYa/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 118px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlIS1yHOQOGMg1p8yS3IY_uLLUSpfAKeJ7JtrgFqWDzy87zYm5SAfEymi-mvvjQH8yhOmdLV829r6Dq867SQbJSe8NPauzLMpu8p4GA40BoFXLcsDJLJpONcLsc6eNQCawjCfB4ltzDoYa/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452562065636028034" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXB5h850IpTbEnvrKsJ7EwKvCBy4kOpgO6TTJPToa1QFW8L99AorGR3NrfQKp39xMhKo5uQ4JFIMp_X69CrDZbUEsSXVIb-_m3EMwjtP7rmcrJQbEiafq4CZ4DJsstS_DzrTnFYkfg6GY9/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 172px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXB5h850IpTbEnvrKsJ7EwKvCBy4kOpgO6TTJPToa1QFW8L99AorGR3NrfQKp39xMhKo5uQ4JFIMp_X69CrDZbUEsSXVIb-_m3EMwjtP7rmcrJQbEiafq4CZ4DJsstS_DzrTnFYkfg6GY9/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452562463374163922" /></a><br />Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-48125934896943065332010-03-25T06:18:00.001-07:002010-03-25T06:52:20.556-07:00COG-125 : IBM Cognos 8 BI Data Warehouse Developer<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTqucUqHuYA90L_yWd-N8VXLsKcE7Q5JpZkFtK0dh6HX0SwnLzs1cBKjsHgfiJWnqHvwV3Yc6hxzqIU67wkaUHTDwEDqQZd28r7HrLOVaXCPqOb-QPvRorEvj9cc6y5spWfU0p9ab60qcJ/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 249px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTqucUqHuYA90L_yWd-N8VXLsKcE7Q5JpZkFtK0dh6HX0SwnLzs1cBKjsHgfiJWnqHvwV3Yc6hxzqIU67wkaUHTDwEDqQZd28r7HrLOVaXCPqOb-QPvRorEvj9cc6y5spWfU0p9ab60qcJ/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452560380577937202" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirpEbJAsQX7I0IzJqSgyBiVNJgxSi6nxO0liSL9AuGzp51iVXDioVbRKaaQ0t1BGaNO0BuLRwj2F-czeoCaqyTaYBYqb29WoPQ-cG9vj72_jAGrLmU4bOpfwkonIol3waCReQ40l6gH_Qa/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 184px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirpEbJAsQX7I0IzJqSgyBiVNJgxSi6nxO0liSL9AuGzp51iVXDioVbRKaaQ0t1BGaNO0BuLRwj2F-czeoCaqyTaYBYqb29WoPQ-cG9vj72_jAGrLmU4bOpfwkonIol3waCReQ40l6gH_Qa/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452560808969645298" /></a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-54637751637342939662010-03-25T04:36:00.000-07:002010-03-25T06:54:08.155-07:00COG-122 : IBM Cognos BI Administrator<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9jnL4_eFBv2bHC1_TYbUZB6osbfNlapVCFQAJ1OnUOpROJDGkIBaQo42k9zABbuPXCVi2sLafIqojg8objuJkvytyxu4LsLCSj9kQJOeFViB8jFiZy9jaIwxvGiMCBXYWX2mnWnC5a9np/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 261px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9jnL4_eFBv2bHC1_TYbUZB6osbfNlapVCFQAJ1OnUOpROJDGkIBaQo42k9zABbuPXCVi2sLafIqojg8objuJkvytyxu4LsLCSj9kQJOeFViB8jFiZy9jaIwxvGiMCBXYWX2mnWnC5a9np/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452534899602172082" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghV8wtlf-TK5YWK-y0-0uJSuLYOL-mHgzNf8ioOKG7ecGHC79yAFncADM3jQjUi1iS-dkT41j4YOhPOtjoGgN0cosB5zBPBT6bJBNpUDHC1pHW6phdMnfYWk41kptSiZwOuyCIDLPMziSH/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 111px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghV8wtlf-TK5YWK-y0-0uJSuLYOL-mHgzNf8ioOKG7ecGHC79yAFncADM3jQjUi1iS-dkT41j4YOhPOtjoGgN0cosB5zBPBT6bJBNpUDHC1pHW6phdMnfYWk41kptSiZwOuyCIDLPMziSH/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452535139828536754" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjL8_L9oIpR7Y_GNBz8CPOY53s3y1wxKf3AOMFeE4vMYZ0zGO39EKxWI0bYvDdH9u8COhcLiPuRvACIGyaglcuXyikEHfeZzB6gTu_2f1ZSrIgSb0LJEdIuuyOpsOwjmyrlhvfiswFOnjA8/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 117px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjL8_L9oIpR7Y_GNBz8CPOY53s3y1wxKf3AOMFeE4vMYZ0zGO39EKxWI0bYvDdH9u8COhcLiPuRvACIGyaglcuXyikEHfeZzB6gTu_2f1ZSrIgSb0LJEdIuuyOpsOwjmyrlhvfiswFOnjA8/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452556405295011746" /></a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-238085912797800562.post-42164190350924529522010-03-25T04:30:00.000-07:002010-03-25T06:52:20.565-07:00COG-112 : IBM Cognos BI Author<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMuEuuQBEXGSftSOmt2kAEQc08KqZfYDB2egAmzvotjXVJTDyJb5dIg1xVFi6-USsFfOuVDkimQaHxRiRThUdptVogX_Fx5Ztbcg7Zq80_RGPeNCvwRVaRJ5YdJCMiBQv7v_pWBc5_cKt9/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 258px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMuEuuQBEXGSftSOmt2kAEQc08KqZfYDB2egAmzvotjXVJTDyJb5dIg1xVFi6-USsFfOuVDkimQaHxRiRThUdptVogX_Fx5Ztbcg7Zq80_RGPeNCvwRVaRJ5YdJCMiBQv7v_pWBc5_cKt9/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452532780116646562" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2vtffHaDUpuewk4X6CGjtz20cuV0Of8bK4V2BcDeHFh_e00heEn7KX_Lq_IMreuHCsM_Y80hM7vjo0uHFiNV2dFOTiUy7P5UBGA78Lwl57JTvbS3YInGFsEoJVYivwoRPkW2yzDW1BjxM/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 136px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2vtffHaDUpuewk4X6CGjtz20cuV0Of8bK4V2BcDeHFh_e00heEn7KX_Lq_IMreuHCsM_Y80hM7vjo0uHFiNV2dFOTiUy7P5UBGA78Lwl57JTvbS3YInGFsEoJVYivwoRPkW2yzDW1BjxM/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452533335764009714" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQ02cbbWJvM8B9JNvcBKd08Twpv4w3gwZWpu63BAMifDbfhSMG9kZzPYHbOThiF0xkU6CwvW4MlixgiW4ELeDw3mcfJtX52521Zzbh_S5yLOzrisOBjD_sNnvWjIwcbPI9GwRzxXFHPAHw/s1600/Untitled.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 251px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQ02cbbWJvM8B9JNvcBKd08Twpv4w3gwZWpu63BAMifDbfhSMG9kZzPYHbOThiF0xkU6CwvW4MlixgiW4ELeDw3mcfJtX52521Zzbh_S5yLOzrisOBjD_sNnvWjIwcbPI9GwRzxXFHPAHw/s400/Untitled.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452533909398910594" /></a><br />Unknownnoreply@blogger.com