IBM COG-706 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM Cognos Financial Statement Reporting Developer |
| Exam Number: | C2020-706 |
| Exam Format: | Multiple choice, Scenario-based questions |
| Exam Duration: | 90 minutes |
| Available Languages: | English |
| Related Certifications: | IBM Business Analytics certifications IBM Cognos Analytics certifications |
| Sample Questions: | IBM COG-706 Sample Questions |
| Exam Way: | Typically delivered via IBM-approved testing centers or online proctored exam (Pearson VUE) |
IBM COG-706 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Report Development and Design | - Bursting and distribution techniques - Creating financial statement reports - Layouts, prompts, and filters |
| Topic 2: Financial Statement Reporting Concepts | - Financial reporting structure and statements - Disclosure and regulatory reporting requirements |
| Topic 3: IBM Cognos Architecture and Components | - Content Manager and dispatcher services - Cognos Analytics architecture overview - Report Studio and authoring tools |
| Topic 4: Security and Governance | - User authentication and authorization - Report access control and permissions |
| Topic 5: Data Modeling and Querying | - Data sources and query relationships - Framework Manager models |
IBM Cognos Financial Statement Reporting Developer Sample Questions:
A company compiled its 2010 Q2 quarterly report using an OLAP data source and a query variable for the quarter. They are now performing a rollover from the 2010 Q2 quarterly report to the 2010 Q3 quarterly report. How do you ensure that the OLAP connection for the new Q3 quarterly report will be updated with data from 2010 Q3?
- A. Change the ##R variable for the quarter to Q3.
- B. Change the value for the quarter query variable from Q2 to Q3.
- C. Change the ##S variable for the quarter to Q3.
- D. Update the value of the quarter field in the OLAP connection to Q3.
Correct Answer: B 🗳️
Upon generating the balance sheet Excel object, an end-user realizes that the generated balance sheet object is not generated with the line items containing zeros. Why does this happen?
- A. Dollar ($) signs need to be placed in separate columns.
- B. FSR automatically suppresses the line items with zeros.
- C. The line items containing zeros need to be merged.
- D. The items do not have the ##NL and ##SL in the column.
Correct Answer: B 🗳️
A company has recently purchased the XBRL module to enable them to submit their latest financial results to the appropriate government financial reporting body. Which two steps need to be taken to install this module? (Choose two.)
- A. Create an XBRL template and assign a user access to this template.
- B. Install the updated license key to enable XBRL/XET at the server level.
- C. Download the latest release of XBRL from Customer Care and install it on the desktop of the user who will be submitting the reports.
- D. From the User Administration screen, enable the XBRL and XET options for the user who will be submitting the reports.
Correct Answer: B,D 🗳️
A user is retrieving data from 2009 and 2010 using an OLAP connection. How can the retrieval be automated so when the report is rolled over to 2011, data from 2011 and 2010 will be retrieved?
- A. Set up note variables for both the current and prior years.
- B. Set up ##GSD variables for both the current and prior years.
- C. Set up ##S variables for both the current and prior years and use ##D to retrieve the data.
- D. Set up query variables for both the current and prior years.
Correct Answer: D 🗳️
A client is loading data from an Excel spreadsheet but is not certain whether to enable the Allow query variables in the path and sheet name. What do you tell the client?
- A. This feature will provide a dynamic link to Excel source files during the rollover process.
- B. This feature needs to be used to be able to load an Excel sheet; if it is not selected, the user will receive an error when trying to complete the load.
- C. This should never be enabled; it is not a supported function in the current version.
- D. This feature will enable you to link data across reports.
Correct Answer: A 🗳️

We're so confident of our products that we provide no hassle product exchange.


By Lindsay


