Test COG-605: IBM Cognos 10 Controller Developer

This test will certify that the successful candidate has important knowledge and skills necessary to set up a Controller application by creating account and company structures, and set up the consolidation processes such as currency conversion, intercompany transactions, and investments in subsidiaries. The successful candidate must also be able to design and generate financial reports used for financial analysis.

Create Company Structures (5%)

1. Distinguish between the company types
2. Describe how consolidation types settings affect the company structures

Create Account Structures (12%)

1. Describe how reconciliation between accounts settings handles reconciliation of opening balances
2. Describe the effect of entering an investment code for an account
3. Describe a scenario for using movement accounts
4. Identify how to generate movement accounts
5. Describe the effect of using statistical and non-statistical account types for movement accounts
6. Identify how integrated and non-integrated movement accounts affect reconciliation
7. Describe the benefits of connecting extended dimensions to accounts

Set up General Configuration (14%)

1. Distinguish between weekly/daily actualities and linked actualities
2. Describe the effect of enabling the advance account view setting
3. Describe the benefits of using multiple submission
4. Describe the effect of enabling Set Status for Submission to Ready After Reconciliation
5. Distinguish between reconciliation made by Journal Type and Closing Version
6. Describe how the reporting status is affected by reconciliation settings Total Difference and Difference per Row
7. Using Method 1, distinguish between currency conversion differences account1 and currency conversion differences account2
8. Describe the impact of main settings and the reserves
9. Explain the impact of changing account type settings

Enable Data Entry and Data Import (19%)

1. Distinguish between different form types
2. Describe the purpose of forms sets
3. Describe the impact of using multiple submissions with form sets
4. Describe any of the functions of the Form Properties
5. Describe how to use linked structures to limit data entry view
6. Distinguish between using the data entry view and the Excel link to add data
7. Describe the process of adding movement accounts to forms
8. Describe a scenario for creating a link between forms
9. Identify the different structures that can be imported and the process
10. Identify the different ways that data can be imported into Controller
11. Describe the process of creating an import specification

Create Journals and Closing Versions (5%)

1. Define the relationship between journal type and closing version
2. Identify the two ways to enter data into company journals
3. Describe scenarios for copying journals from one period to another
4. Determine impact of adjusting data on group journals versus company journals

Prepare for Currency Conversion (11%)

1. Identify when rules for currency conversion are defined
2. Identify the workflow for converting foreign currency
3. Using currency conversion Method 1, identify the commonly used currency codes for P&L accounts, Balance Sheet accounts, and Equity accounts
4. Distinguish between the currency register and the historical register
5. Describe a scenario for entering historical rates when a company rolls up to several group currencies
6. Distinguish between currency conversion codes C and I when converting values for a company journal

Configure the Control Tables (9%)

1. Explain the purpose of acquisition control tables
2. Explain the purpose of intercompany elimination control tables
3. Identify the process for enabling automatic journal entries
4. Identify the impact of the offset account in control tables

Eliminate and Reconcile Intercompany transactions and acquisitions (10%)

1. Identify when counter dimensions are used
2. Identify the ways intercompany balances can be eliminated
3. Identify the effect of storing intercompany adjustments as group journals
4. Identify how to enter data in the investment register for subsidiaries and associated companies
5. Explain scenarios when no balance control would be used in the investment register
6. Describe the importance of defining a start period for acquisition calculations
7. Describe the ways to run reports for reconciling data reported as intercompany balances
8. Identify the impact of using Use Online Matching

Consolidate a Group's Reported Values (5%)

1. Distinguish between consolidating by steps and consolidating by status
2. Identify the reports needed to analyze consolidation

Secure the Application and the Data (4%)

1. Describe the benefits of creating security groups
2. Describe the benefits of creating user rights
3. Describe how using period locking at a company level affects the closing version
4. Distinguish between locking the period for data entry only and locking the period entirely

Create Reports to Analyze Data (6%)

1. Identify the performance considerations when creating reports
2. Distinguish the benefits between creating a Report Generator report and an Excel Link report
3. Describe the Report Conversion functionality when creating user-defined reports in Controller