Number of questions: 50
Time allowed in minutes: 60
Required passing score: 74%
Languages: English, French, German, Japanese, Spanish Castilian
If your job role includes building reports using relational data models, as well as enhancing, customizing, and managing professional reports, then you may consider adding this certification to your professional portfolio.
The Cognos 10 BI Author exam covers key concepts, technologies, and functionality of the Cognos products. In preparation for an exam, we recommend a combination of training and hands-on experience, and a detailed review of product documentation.
Create reports (14%)
Describe how to create list, crosstab, and repeater reports
Present data graphically
Focus reports (12%)
Describe how to focus reports using filters
Describe how to focus reports using prompts
Enhance reports (44%)
Describe the use of calculations in reports
Identify techniques to enhance layout and content
Describe how to customize reports with conditional formatting
Identify steps to set-up Drill-through Access
Create reports using the query model (18%)
Identify the purpose and components of the query model
Describe how to create the query model
Describe techniques used in the query model that determine how data is aggregated
Identify the effects on the query model(s) of creating a master/detail relationship in the report layout
Setup reports for bursting (6%)
Describe the function of the settings required to distribute reports through bursting
Manage events using agents (6%)
Describe the use of Event Studio in Cognos 8 BI
IBM Certified Designer – Cognos 10 BI Reports
Job Role Description / Target Audience
The professional report author is responsible for building reports using relational data models, as well as enhancing, customizing, and managing professional reports. This individual is new to Report Authoring and will be able to participate as an effective team member.
To achieve the IBM Certified Designer – Cognos 10 BI Reports certification, candidates must possess the skills identified under Recommended Prerequisite Skills, if any, and pass one (1) exam.
Click the test link below to see the overview, objectives, and test preparation recommendations.
Recommended Prerequisite Skills
Prior to your preparation for this associate-level certification, the following knowledge and skills are recommended and assumed:
Experience using Windows operating system and a web browser
Knowledge of XML
In Report Studio, which chart lets the report author plot a third measure?
D. Progressive Column
An author wants to create a report that displays certain list columns depending on the user’s prompt selection. What property of the list column must the author define to create this variable?
A. Text source variable
B. String variable
C. Style variable
D. Render variable
An author creates a report in Report Studio. The report contains a parameter for the Product line query item. The author wants to let users drill through to this report from a variety of reports created using the GO Data Warehouse (query) package. To ensure that this target report contains data for the appropriate products, the author wants to limit the report cells that users can drill through from in source reports. What must the author do when creating the drill-through definition?
A. Set the Product line query item as the target of the drill-through definition.
B. Set the Product line query item as the scope of the drill-through definition.
C. Add a parameter for the Product line query to the drill-through definition.
D. Delete all data items except for the Product line query item from the drill-through definition.
Which statement about the tabular data retrieved by Report Studio queries is true?
A. Tabular data includes a column for each data item in the query. No grouping is applied to the tabular data.
B. Tabular data includes a column for each data item in the query. Grouping applied in the report layout is also applied to the tabular data.
C. Tabular data can only include columns for data items that appear in the layout. No grouping is applied to the tabular data.
D. Tabular data includes a column for each data item that appears in both the query and the layout. Grouping applied in the report layout is also applied to the tabular data.
In Report Studio, what is a baseline?
A. A value in a list report that other values are compared against.
B. A constant value that represents the x-axis in a chart.
C. A constant value drawn on a chart to indicate major divisions in the data.
D. A break point that keeps part of a report stationary while the user scrolls.