Note that in ISO standard, a week begins with Monday being day 1. In North America where Sunday is the first day of the week being day 7. Also known as the Julian day. How to use Like these, there are various other Report functions as well that can be used.

Author:Shakar Akinojind
Language:English (Spanish)
Published (Last):1 February 2007
PDF File Size:9.95 Mb
ePub File Size:2.27 Mb
Price:Free* [*Free Regsitration Required]

Note that in ISO standard, a week begins with Monday being day 1. In North America where Sunday is the first day of the week being day 7. Also known as the Julian day.

How to use Like these, there are various other Report functions as well that can be used. When a report created in the older version of Cognos is upgraded it is automatically validated. To validate a report, go to the Tools menu and click on the Validate button as shown in the following screenshot.

Cognos - Report Run with Options You can run the report with different options. To set the report options, go to Run options. Rows per page and prompt option, etc. Cognos - Report Administration Report Administration allows you to give permissions to different users on the report level. You can define various other properties like output versions, permissions, general properties, etc.

By default, an entry acquires its access permissions from a parent. You can override those permissions with the permissions set explicitly for this entry. You can also move, copy or delete a report in More Options. You can create a shortcut entry or report view of the report. Cognos - Filters Filters are used to limit the data that you want in your report.

You can apply one or more filters in a Cognos report and the report returns the data that meet the filter conditions. You can create various custom filters in a report as per the requirement. Select the column to filter by. Click the drop down list from the Filter button. Choose Create Custom Filter. The Filter Condition dialog displays.

You can select one or many. Use the arrow button to add multiple values. Select a value and click the right pointing arrow to move the value into the selected column. You can use the Ctrl key to add multiple values at tone time. Click OK when the filter is defined.

You can go to the query explorer and view the filters. Click the insert calculation button and select the calculation to perform. To change the order of the operands or the name of the calculated item added to the report, click Custom. The calculation appears as a new row or a column in your report. Drilling Drill up and drill down is used to perform analysis by moving between levels of information. Drill down is used to see more detailed information to lowest level and drill up is used to compare the results.

To drill down or up in both a row and column simultaneously, click on the value at the intersection of the row and the column, and then click again. Cognos - Analysis Studio Analysis Studio is used to focus on the items that are important for the business. You can do comparisons, trend analysis and analysis like top and bottom performers and also allow you to share your analysis with others.

Analysis Studio is not only used by BI Analysts but also by business users who understand business and want to find answers to business queries using historical data. You can use Analysis Studio to compare and manipulate data to understand the relationships between data and its relative importance. Whether you want to assess revenue growth or to identify top performers, Analysis Studio provides the filtering, calculating, and sorting support you need for analysis. Interface The Analysis Studio consists of several areas that are shown in the following areas and are explain in detail as well.

You can display analysis in the form a Crosstab, chart or a combination of both. And lastly there is the Overview Area as well. Cognos - Create an Analysis To create an analysis in the Analysis studio, you have to select a package as data source. You can create a new analysis or use an existing analysis as reference to create a new analysis by changing its name before saving it. Go to Report Studio as shown in the following screenshot. In a new dialog window, select a Blank Analysis or Default Analysis.

After selecting, click OK. The Analysis Studio starts. The items that you can use in the analysis are listed in the Insertable Objects pane. Cognos - Save an Analysis To save an analysis, you can click on the save button at the top as shown in the following screenshot.

Cognos - Open Existing Analysis To open an existing Analysis, locate the name of the analysis that you want to open and click it. It is opened in Analysis Studio. You can make any changes as per the requirement. Save the analysis. You can also open a new analysis while working in an existing analysis, click the new button on the toolbar. The new analysis maintains the state of the source tree in the Insertable Objects pane and maintains any items on the Analysis Items tab.

Cognos - Event Studio Cognos Event Studio is a Web-based tool that allows you to create and manage agents to monitor data and perform tasks when the data meets predefined thresholds. Events You can specify an event condition to perform a task.

An event is defined as query expression in a data package. When a record matches the event condition, it causes an agent to perform tasks. When an agent runs, it checks the data for any event instances. Event Instance An agent monitors data, each event instance is detected. Task execution rules are followed to determine if an agent will perform the task. Task frequency defines that a task should be performed once or repeated for each event instance.

Event List You can categorize the event as per the task performed. The event list shows all the events that are executed by an agent. Event Studio compares the event instances detected in each agent run with those detected in the previous run. To ensure it correctly matches the event instances for comparison, you must define an event key. The event key is the combination of data items that uniquely defines an event instance.

Agent An agent runs to check occurrences of the event. An agent performs a task for events that meet the execution rules. Tasks A task can be used to notify users about a change in business event.

Users can take appropriate actions as per the event.



New Features in Version 8. Links to directly-related topics are included. You can disable query reuse for each individual query in Report Studio, or you can disable query reuse for the entire package in Framework Manager. For more information about query reuse, see the Framework Manager User Guide. Other types of drill-through targets are now supported.



Zutaxe This document describes various scenarios encountered when transitioning from Compatible to Dynamic Query Mode. This document outlines how to optimize a 8. In the previous articles of this series, you learned different techniques for integrating InfoSphere Warehouse Data Mining and simple Cognos reports. IBM Cognos BI — Unexpected Results When Performing Multi-Fact Queries Stitch Queries This document discusses a number of issues that advanced report authors may encounter when they create reports that generate a stitch query queries that include facts from multiple fact tables. Choosing the settings to enable high availability The goal of high availability is to provide a backup mechanism to transfer requests and data processing to a standby system in the event of primary system failure, but user and system requirements vary, meaning there is no one ideal configuration. In this article, follow a step-by-step guide to see how to integrate Google Maps in Cognos reports, providing a way for you to represent tabular data in a spatial context.


Cognos - Quick Guide


Related Articles