In this section

Share this page

IBM Certified Developer - Cognos 10 Controller

The Controller developer is responsible to set up a Controller application by creating account and company structures, and to set up the consolidation processes such as currency conversion, intercompany transactions, and investments in subsidiaries. The developer must also be able to design and generate financial reports used for financial analysis.

Prerequisites

Prior to your preparation for this associate-level certification, the following knowledge and skills are recommended and assumed:

  • Knowledge of IBM Cognos 8/10 Cognos Connection
  • Knowledge of IBM Cognos 8/10 Controller Configuration

Recommended Training and Required Exam(s)

 Required Exam Recommended Training 
COG-605 - IBM Cognos 10 Controller Developer

IBM Cognos Controller: Develop Applications (V10.1) (P8121G)

Skills acquired during recommended training

Create Company Structures

  • Distinguish between the company types
  • How consolidation types settings affect the company structures

Create Account Structures

  • Describe how reconciliation between accounts settings handles reconciliation of opening balances
  • Effects of entering an investment code for an account
  • Scenarios for using movement accounts
  • Generating movement accounts
  • Using statistical and non-statistical account types for movement accounts
  • Integrated and non-integrated movement accounts affect reconciliation
  • Benefits of connecting extended dimensions to accounts

Set up General Configuration

  • Distinguish between weekly/daily actualities and linked actualities
  • Effects of enabling the advance account view setting
  • Benefits of using multiple submission
  • Effects of enabling Set Status for Submission to Ready After Reconciliation
  • Journal Type and Closing Version reconciliations
  • Describe how the reporting status is affected by reconciliation settings Total Difference and Difference per Row
  • Using Method 1, distinguish between currency conversion differences account1 and currency conversion differences account2
  • Impact of main settings and the reserves
  • Impact of changing account type settings

Enable Data Entry and Data Import

  • Different form types
  • Purpose of forms sets
  • Impact of using multiple submissions with form sets
  • Functions of the Form Properties
  • Using linked structures to limit data entry view
  • Distinguish between using the data entry view and the Excel link to add data
  • Adding movement accounts to forms
  • Scenarios for creating a link between forms
  • Importing different structures
  • Importing data into the Controller
  • Creating an import specification

Create Journals and Closing Versions

  • Relationship between journal type and closing version
  • Two ways to enter data into company journals
  • Scenarios for copying journals from one period to another
  • Impact of adjusting data on group journals versus company journals

Prepare for Currency Conversion

  • Rules for currency conversion
  • Workflow for converting foreign currency
  • Using currency conversion Method 1, identify the commonly used currency codes for P&L accounts, Balance Sheet accounts, and Equity accounts
  • Distinguish between the currency register and the historical register
  • Scenarios for entering historical rates when a company rolls up to several group currencies
  • Distinguish between currency conversion codes C and I when converting values for a company journal

Configure the Control Tables

  • Acquisition control tables
  • Intercompany elimination control tables
  • Enable automatic journal entries
  • Impact of the offset account in control tables

Eliminate and Reconcile Intercompany transactions and acquisitions

  • Use of counter dimensions
  • Elimination of intercompany balances
  • Effects of storing intercompany adjustments as group journals
  • How to enter data in the investment register for subsidiaries and associated companies
  • Explain scenarios when no balance control would be used in the investment register
  • Defining a start period for acquisition calculations
  • Run reports for reconciling data reported as intercompany balances
  • Impact of using Use Online Matching

Consolidate a Group's Reported Values

  • Distinguish between consolidating by steps and consolidating by status
  • Reports needed to analyze consolidation

Secure the Application and the Data

  • Benefits of creating security groups
  • Benefits of creating user rights
  • How using period locking at a company level affects the closing version
  • Distinguish between locking the period for data entry only and locking the period entirely

Create Reports to Analyze Data

  • Performance considerations when creating reports
  • Benefits between creating a Report Generator report and an Excel Link report
  • Report Conversion functionality when creating user-defined reports in Controller