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:Akigor Viramar
Language:English (Spanish)
Published (Last):24 June 2011
PDF File Size:4.60 Mb
ePub File Size:17.80 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.



Mebar For example, you can map the member caption instead of the business key to the target. For more information, see Create a Drill-up and Drill-down Report. In addition, the sorting of data by member is enhanced. Many commands on shortcut menus have been reorganized to make them easier to find and use.


Cognos - Quick Guide

Akinozuru For more information, see Add Background Effects. A new property, Allocation Rule, allows you specify the type of allocation defined for the measure Query Items. For more information, see Insert a Hierarchy. New Chart Types The following new chart types are now available: You can now view lineage information of a data item to see what the item represents before you add it to a report. The report user will see the prompt that matches the prompt type on the attribute. If you have Composite data sources defined in IBM Cognos Connection, you must migrate the existing repository to the new default repository. OLAP cubes are designed to contain metadata for business intelligence reporting and analysis.


IBM Cognos Framework Manager

The Palette property provides palettes that match those from various versions of Excel. Viewing lineage information ensures that you add the correct data items to a report. For more information, see Suppress Empty Cells. Individual segment height is a percentage of the respective column total value.

Related Articles