COGNOS REPORT STUDIO TRAINING
COGNOS REPORT STUDIO TRAINING INTRODUCTION:
Cognos Report Studio Training advanced report building techniques using mostly relational data models, and ways of enhancing, customizing, and managing professional reports. The Report studio window contains an insertable objects pane, a properties pane, an explorer bar and work area.
COGNOS REPORT STUDIO TRAINING COURSE CONTENT:
Create Query Models
- Build query models & then connect them to the report layout
- Edit an SQL statement to author custom queries
- Add filters & prompts to a report using the query model
Create Query Reports Based on Relationships
- Creating the reports by merging query results
- Creating the reports by joining queries
- Combine data containers based on relationships from the different queries
Create Advanced Dynamic Reports
- Filter reports on session parameter values
- Navigate a briefing book using a table of content
- Creating the dynamic headers & title that reflect report data
- Let users navigate to specific locations in the reports
- Cognos report studio training to create a customer invoice report
Design Effective Prompts
- Control report displays using prompts
- Specifying the conditional formatting values using the prompts
- Specifying the conditional rendering of objects based on prompt selection
- Create sorted & filtered reports based on prompt selection
Create Additional Advanced Reports
- Creating the report that displays summarized data before detailed data
- Highlight alternate rows in a list report
- Creating the report using an external data file
- Using the single data items to summarize report information
Examine the Report Specification
- Examine the report specification structure
- Modify a report specification
- Add custom toolbox objects & custom template options
Distribute Reports through Bursting
- Distribute reports using bursting
- Create burst keys
- Identify report recipients & data items using burst tables
- Distribute reports using email & IBM Cognos Connection
Enhance User Interaction with HTML
- Creating the tooltips that clarify report data
- Send emails using links in a report
Analyze Data Using Statistical Reports
- Discuss statistical report types
- Examine descriptive statistics
- Explore statistical charts
- A basic understanding of your institution’s business processes and data.
- Familiarity with producing ad hoc reports using query studio. Some exercises in this class build on skills you acquired in the query studio class.
Course Objective for Cognos Report Studio Training:
In this course you will learn how to
- Open the COGNOS Connection web page.
- Open Report Studio.
- Choose the package for report.
- Create a report.
- Choose a template for the report.
- Add query items for the report.
- Save the report.
- Validate & run the report.
- Recognize the types of reports.
- Create charts.
Reporting styles for Cognos Report Studio Training:
You can create reports in Cognos report studio using either a relational reporting style or a dimensional reporting style.The Report studio tools & query language are the same for both styles. However, it is important to choose a reporting style to ensure that you are making most of your data to avoid mixing dimensional and relational concepts in cognos report studio training.
How to choose a reporting style:
- When authoring a report in cognos report studio training, first choose your preferred reporting style for working with the data: relational or dimensional. You can choose a reporting style from your viewpoint:
- If you think about data as table and columns, you have a relational viewpoint and should use a relational style.
- If you think about your data as a number of dimensions intersect at cells, you have a dimensional viewpoint and should use a dimensional reporting style.
Relational Reporting Style:
- The relational reporting style consists of lists. You focus the data with filters & summarizing with header and footer summaries.
- If your data is purely rational, then only query subjects and query items appear in source tab, and you must use the relational reporting style.
- If your data is dimensional, then dimensional appear in source tab, and you can still use a relational style, but instead of query items (columns) & query subjects (tables), you use measures cognos report studio training levels & level properties.
- To see an example of the relational style reporting with the dimensional data, see the Manager Profile sample report in the GO Data warehouse (analysis) package. The relational reporting style to report authoring in Cognos query studio.
Dimensional reporting style:
- The dimensional reporting the style consists of measures & members from different hierarchies arranged in a cross tab with cell values at the intersections. You focus the data with set expression that navigate from specific members in the hierarchy and summarize with set summaries.
- To see an example of dimensional style reporting with dimensional data, see the GO Balance sheet as sample report in GO Data Warehouse (analysis) package. The dimensional reporting style is similar to report authoring in Cognos Analysis Studio.
Report Objects of Cognos Report Studio Online Training:
You build reports by adding and manipulating them to obtain the results you want. To understand how to work with objects in the Cognos report studio training, you must be familiar with the following concepts:
- Object Types
- Objects as containers
- Locking and unlocking objects
- Hierarchy of objects
In Cognos Report Studio training, layout objects are either inline ob black. You can insert other objects on the same line as an inline object, but not on same line as a block object. When you insert an object to the line above or below the block object, respectively. Examples of inline objects include the graphics and text items. Example of block objects includes any report type (list, cross tab, chart, map or repeater) and tables.
You can use an object’s floating property to define how other objects flow around object. For example, you can specify how the text flows around an image.
Objects as Containers:
In cognos report studio training, objects, such as table, blocks, and any reports frame, are containers in which you can insert other objects. For example, you can insert a list in one cell of table and a chart in another. You can also nest objects to create a sophisticated layout. For example, you can insert a table in a cell of another table.
Locking and Unlocking Objects:
To manipulate the contents of some objects, you must first unlock object. For example, you have a list that contains the column Product name. You want to insert a graphic inside Product Name column to show an image of each product. Unlocking the list allows you to insert the image objects inside a list column.
Hierarchy of objects:
In Cognos Report Studio online training, objects are organized hierarchically. For example, a list contains list columns, and each list columns contain a text item, which is the name of inserted data item.
The hierarchy of the objects is useful to remember when you apply formatting because formatting is applied to the child objects of the object. For example, you can specify that all list column titles in a list have red as the background colour. The formatting is automatically applied to any new columns you can add to the list because the following is applied to the list and is therefore applied to objects in the list. If you apply formatting to specific objects, it will override the same formatting specified for the parent object