This course teaches application developers how to set up a Controller application and effectively use Controller in their organization’s consolidation process. Students will also design and generate financial reports using Controller. Through a series of lectures and hands-on exercises, students will set up a Controller application by creating the necessary structures (such as accounts and companies), and then test the application to ensure that it works properly. Students will also learn how to work with currency translation, allocations, intercompany transactions, investments in subsidiaries, advanced formula calculations, and user-defined business rules, as well as define configuration settings and user access to the application.

Audience: Application Developers

Brand: DS&BA - Cognos Controller; Windows

Event Number: P8221G

Available Languages: English (US),English (UK),French (Canada),German (Germany),Russian (Russia),Japanese (Japan),Chinese (Simplified),Italian (Italy),Polish (Poland),Portuguese (Brazil),French (France),Spanish (Latin America),Spanish (Spain),Portuguese (Portugal),Thai (Thailand),Dutch (The Netherlands),Turkish (Turkey),Romanian (Romania),Czech (Czech Republic),Latvian (Latvia),Lithuanian (Lithuania),Norwegian (Bokml),Swedish (Sweden),Danish (Denmark),Hebrew (Israel),Arabic,Greek (Greece),Korean (Korea),Bulgarian (B

Subjects: Technical

Objectives:

Please refer to course overview

Learn about;
Cognos;
Cognos Controller;
Cognos Controller 10.2.0

Course Detail:

Create companies, consolidation types, and account structures
Create and organize forms for entering data into the Controller application
Generate movement accounts to show changes to data over time
Create extended dimensions to enhance data analysis
Link structures to customize end users’ access to Controller data
Define and schedule the data entry process
Test the Controller application setup
Adjust data through journal entries
Translate foreign currencies
Enable automatically created journal entries
Allocate values
Reconcile and eliminate intercompany transactions
Work with shareholdings and investments in group companies
Calculate and eliminate acquisition values
Consolidate a group’s reported values
Define security restrictions to different parts of the application
Eliminate intercompany profit
Create complex stored calculations
Customize the consolidation process using user-defined business rules (UDBRs)
Create ad hoc reports to quickly analyze and compare figures
Run standard reports to verify and analyze data for consolidation
Create custom reports using the Report Generator
Create, modify, and run reports in Excel using the Excel Link
Run multiple reports simultaneously by grouping reports into report books
Identify different consolidation models (Optional)

Pre-Requisite Text:

Basic knowledge of group accounting

GTR Start Date / End Date Class ID Location Language Price Enroll
GTR:
Start Date / End Date:
08/26/2019 10:00 EST -
08/30/2019 18:00 EST
765156 Location: NA Virtual - ET Language: English (US) Price: $4100.00 USD Enroll:

To add to cart,
Log in here

GTR:
Start Date / End Date:
11/04/2019 10:00 EST -
11/08/2019 18:00 EST
765155 Location: NA Virtual - ET Language: English (US) Price: $4100.00 USD Enroll:

To add to cart,
Log in here

GTR:
Start Date / End Date:
01/27/2020 10:00 EST -
01/31/2020 18:00 EST
765157 Location: NA Virtual - ET Language: English (US) Price: $4100.00 USD Enroll:

To add to cart,
Log in here