Cisco Training Courses

Insoft has been serving IT community with official Cisco training offering since 2010. Find all the relevant information on Cisco training on this page.

View More

Cisco Certifications

Experience a blended learning approach that combines the best of instructor-led training and self-paced e-learning to help you prepare for your certification exam.

View More

Cisco Learning Credits

Cisco Learning Credits (CLCs) are prepaid training vouchers redeemed directly with Cisco that make planning for your success easier when purchasing Cisco products and services.

Have CLCs and want to redeem them?

Cisco Continuing Education

The Cisco Continuing Education Program offers all active certification holders flexible options to recertify by completing a variety of eligible training items.

View More

Cisco Digital Learning

Certified employees are VALUED assets. Explore Cisco official Digital Learning Library to educate yourself through recorded sessions.

Browse CDLL Catalogue

Cisco Business Enablement

The Cisco Business Enablement Partner Program focuses on sharpening the business skills of Cisco Channel Partners and customers.

View More

Fortinet Technical Certifications

The Fortinet Network Security Expert (NSE) program is an eight-level training and certification program to teach engineers of their network security for Fortinet FW skills and experience.

View More

Fortinet Technical Courses

Insoft is recognised as Fortinet Authorized Training Center in selected locations across EMEA.

View More

ATC Status

Check our ATC Status across selected countries in Europe.

View More

Fortinet Services Packages

Insoft Services has developed a specific solution to streamline and simplify the process of installing or migrating to Fortinet Products.

Browse Packages

Prepforce Bootcamp

The only comprehensive source available today to prepare for Fortinet NSE 8 certification globally.

View More

Microsoft Training

Insoft Services provides Microsoft training in EMEAR. We provide Microsoft technical training and certification courses that are led by world-class instructors.

View More

Technical Training

The evolution of Extreme Networks Technical Training provides a comprehensive progressive pathway from Associate to Professional accreditation.

View More

ATP Accreditation

As an authorised training partner (ATP), Insoft Services ensures that you receive the highest standards of education available.

View More

What we do

Through our global presence and partner ecosystem, we provide strategic IT consulting services to align IT services with customers' business goals.

View More

 

We are pleased to launch pre-scoped Enterprise Networking Consulting Packages, our ready-made solutions, tailored to ensure efficiency and cost containment.

 

View More

 

We specialize in the deployment of vendor-specific automation tools as well as open-source and vendor-independent solutions, that can be tuned in accordance with the business needs of a specific organization.

 

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

 

View More

 

We provide comprehensive IoT consultancy, deployment and support solutions for businesses that want to launch or improve their use of connected technologies. You’ll have the expert guidance you need to streamline operations, increase efficiency and maximize outcomes.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

 

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

 

View More

 

We provide the highest level of expertise on Cisco consultancy services, that target audits of your current network and implementing updates for improved operational performance, secure data and compliant systems.

View More

 

We provide the highest level of expertise on Fortinet consultancy services that target audits of your current network and implementing updates for improved operational performance, secure data and compliant systems.

View More

 

Our team can help enterprises, get the most value from Extreme products and services following our predefined value-added packages or custom ones that fits business needs.

 

View More

About Us

Our training portfolio includes a wide range of IT training from IP providers, including Cisco, Extreme Networks, Fortinet, Microsoft, to name a few, in EMEA.

View More

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

Contact Us

We would love to hear from you. Please complete this form to pre-book or request further information about our delivery options.

Data Protection & Privacy

I hereby allow Insoft Ltd. to contact me on this topic. Further, I authorise Insoft Ltd. processing, using collecting and storing my personal data for the purpose of these activities. All your data will be protected and secured as outlined in our privacy policy.

Close

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

Enroll Now
Duration
5 Days
Delivery
(Online and onsite)
Price
Price Upon Request

The IBM Cognos Controller: Develop Applications (V10.1) is an intermediate five-day instructor-led training course. 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 the 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. In this Cognos Controller training, students will also learn how to work with currency conversion, intercompany transactions, and investments in subsidiaries, as well as define configuration settings and user access to the application.

 

See other courses available

Introduction to IBM Cognos Controller

  • Review the Cognos Performance Management (PM) solution and the role of IBM Cognos Controller in PM
  • Examine IBM Cognos Controller components
  • Examine the structures used in a Controller application
  • Examine the application setup workflow
  • Log on to a Controller application and set personal options

Set Up Companies

  • Examine the importance of company structures in the Controller application
  • Enable the currencies and countries to be used in the Controller application
  • Create and link companies
  • Specify ownership relations between companies
  • Verify the company structure

Set Up Accounts

  • Examine the importance of account structures in a Controller application
  • Create and link accounts
  • Maintain an account structure
  • Verify the account structure

Configure the Application

  • Examine general configuration settings for a Controller application
  • Examine actualities
  • Identify the three types of actualities
  • Configure a Controller application

Enable Data Entry and Data Transfer

  • List different ways to enter data into Controller
  • Examine forms
  • Create forms and verify form structure
  • Examine form sets
  • Examine how to import data from an external system
  • Create an import specification
  • Import data from an external file

Set Up Accounts to Show Changes over Time

  • Use movement accounts to track changes over time
  • Examine the workflow process to create movement accounts
  • Enable and create movement accounts
  • Prepare movement accounts for data entry

Enhance Data Analysis

  • Enhance data analysis by using extended dimensions
  • Enable and define extended dimensions
  • Generate reports for extended dimensions
  • Prepare accounts for extended dimensions
  • Add extended dimensions to forms
  • Verify extended dimensions, accounts, and forms

Customize the Data Entry View

  • Customize the data entry view
  • Define and group the items you want to restrict
  • Generate reports for linked structures

Define and Schedule the Data Entry Process

  • Examine the data entry process
  • Enable and define report occasions for data entry
  • Examine different ways of making periods read-only

Test the Application Setup

  • Test structures
  • Manually enter data into the Controller application
  • Reconcile data
  • Examine the status of data
  • Track changes to metadata

Adjust Data Through Journal Entries

  • Identify the workflow process to set up consolidation of reported values
  • Identify how to make adjustments to data on a company level
  • Define and connect a journal type and a closing version
  • Enter data into company journals
  • Copy company journals
  • Run reports on company journals
  • Enter data into group journals

Convert Foreign Currency

  • Identify the workflow process for converting foreign currencies
  • Examine foreign currency conversion
  • Prepare the application with rules for currency conversion
  • Define the base currency and activate currency codes
  • Enter currency rates for a period
  • Convert foreign currency
  • Run reports and analyse currency converted data

Enable Automatic Journal Entries

  • Identify the workflow process for enabling automatic journal entries
  • Plan the use of automatic journals
  • Identify predefined automatic journal types
  • Define a contribution version and connect automatic journal types
  • Activate a predefined automatic journal
  • Identify how to use control tables

Allocate Data

  • Describe the purpose of allocations
  • Allocate by a fixed proportion
  • Allocate based on proportion values in a different account

Eliminate Intercompany Balances

  • Identify the workflow process for reconciliation and elimination of intercompany balances
  • Define intercompany accounts and enter period data
  • Define rules to control reconciliation and elimination of intercompany balances
  • Run and analyse reconciliation reports
  • Eliminate intercompany balances and verify postings

Enter Shareholdings and Investments

  • Identify the workflow process for entering shareholdings and investments
  • Prepare the application with necessary settings for entering shareholdings and investments
  • Enter shareholdings and investments data
  • Reconcile shareholdings and investments data

Calculate Acquisition Values

  • Identify the workflow process for calculating acquisition values
  • Define control tables for automatic journals
  • Configure a start period
  • Eliminate acquisition values and verify postings

Consolidate Group Values

  • Identify the workflow process for consolidating the group’s reported values
  • Prepare the application for the consolidation
  • Consolidate the group’s values manually
  • Run and analyse reports on consolidation
  • Review the status of the group’s data

Apply Security

  • Examine the IBM Cognos security architecture
  • Define security restrictions to different parts of the application
  • Define security restrictions for users
  • Run reports on applied security
  • Track changes to metadata
  • Examine options that can be personalized
  • Configure local preferences

Eliminate Intercompany Profit

  • Identify the workflow process for reconciliation and elimination of intercompany profit
  • Define intercompany profit accounts and enter period data
  • Define rules to control reconciliation and elimination of intercompany profit
  • Run and analyse reconciliation reports
  • Eliminate intercompany profit and verify postings

Create Complex Stored Calculations

  • Identify the purpose of advanced formula calculations
  • Identify built-in calculation operators and functions
  • Create advanced formula calculations

Customize the Consolidation Process with User-Defined Business Rules (UDBRs)

  • Customize consolidation rules for customers using user-defined business rules
  • Create and validate a user-defined business rule (UDBR) script
  • Define, map, and run a UDBR job
  • Group companies into subsets
  • Use subsets in UDBRs

Introduction to Reporting with IBM Cognos Controller

  • Explore report types and the role of dimensions in reports
  • Run a report based on a data entry form

Create Ad Hoc Reports

  • Create simple ad hoc reports
  • Compare the data for multiple sets of dimensions
  • Export an ad hoc report to an external application

Verify and Analyse Data for Consolidation

  • Examine the benefits of using standard reports in consolidation
  • Select dimensions to run a simple trial balance
  • Drill down on dimensions to view more details
  • View the details behind a summary account using a ledger report

Create Custom Reports

  • Create advanced reports using the Report Generator
  • Determine which dimensions to use when running a report
  • Examine reporting options available with different dimensions
  • Use Controller functions to build reports

Report on Controller Data in Excel

  • Connect Controller to Excel using the Excel Link
  • Use the Report Generator to open and create reports in Excel
  • Add Controller data to a spreadsheet
  • Refresh workbooks to show the latest Controller data
  • Examine exporting data from a workbook back to Controller
  • Design efficient multi-page reports

Run Groups of Reports

  • Examine the purpose of using report books
  • Create a report book
  • Examine input selection values
  • Examine report output options
  • Run a report book

Optional Cognos Controller training modules

  • A: Consolidation Structure and Extended Dimensions in Sample Data
  • B: Identify Consolidation Models
  • C: Describe different consolidation models

The Cognos Controller training is intended for:

  • Application Developers
  • People with a financial or accounting background

Before attending this Cognos Controller training, you should have:

  • Basic knowledge of group accounting
The IBM Cognos Controller: Develop Applications (V10.1) is an intermediate five-day instructor-led training course. 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 the 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. In this Cognos Controller training, students will also learn how to work with currency conversion, intercompany transactions, and investments in subsidiaries, as well as define configuration settings and user access to the application.   See other courses available

Introduction to IBM Cognos Controller

  • Review the Cognos Performance Management (PM) solution and the role of IBM Cognos Controller in PM
  • Examine IBM Cognos Controller components
  • Examine the structures used in a Controller application
  • Examine the application setup workflow
  • Log on to a Controller application and set personal options

Set Up Companies

  • Examine the importance of company structures in the Controller application
  • Enable the currencies and countries to be used in the Controller application
  • Create and link companies
  • Specify ownership relations between companies
  • Verify the company structure

Set Up Accounts

  • Examine the importance of account structures in a Controller application
  • Create and link accounts
  • Maintain an account structure
  • Verify the account structure

Configure the Application

  • Examine general configuration settings for a Controller application
  • Examine actualities
  • Identify the three types of actualities
  • Configure a Controller application

Enable Data Entry and Data Transfer

  • List different ways to enter data into Controller
  • Examine forms
  • Create forms and verify form structure
  • Examine form sets
  • Examine how to import data from an external system
  • Create an import specification
  • Import data from an external file

Set Up Accounts to Show Changes over Time

  • Use movement accounts to track changes over time
  • Examine the workflow process to create movement accounts
  • Enable and create movement accounts
  • Prepare movement accounts for data entry

Enhance Data Analysis

  • Enhance data analysis by using extended dimensions
  • Enable and define extended dimensions
  • Generate reports for extended dimensions
  • Prepare accounts for extended dimensions
  • Add extended dimensions to forms
  • Verify extended dimensions, accounts, and forms

Customize the Data Entry View

  • Customize the data entry view
  • Define and group the items you want to restrict
  • Generate reports for linked structures

Define and Schedule the Data Entry Process

  • Examine the data entry process
  • Enable and define report occasions for data entry
  • Examine different ways of making periods read-only

Test the Application Setup

  • Test structures
  • Manually enter data into the Controller application
  • Reconcile data
  • Examine the status of data
  • Track changes to metadata

Adjust Data Through Journal Entries

  • Identify the workflow process to set up consolidation of reported values
  • Identify how to make adjustments to data on a company level
  • Define and connect a journal type and a closing version
  • Enter data into company journals
  • Copy company journals
  • Run reports on company journals
  • Enter data into group journals

Convert Foreign Currency

  • Identify the workflow process for converting foreign currencies
  • Examine foreign currency conversion
  • Prepare the application with rules for currency conversion
  • Define the base currency and activate currency codes
  • Enter currency rates for a period
  • Convert foreign currency
  • Run reports and analyse currency converted data

Enable Automatic Journal Entries

  • Identify the workflow process for enabling automatic journal entries
  • Plan the use of automatic journals
  • Identify predefined automatic journal types
  • Define a contribution version and connect automatic journal types
  • Activate a predefined automatic journal
  • Identify how to use control tables

Allocate Data

  • Describe the purpose of allocations
  • Allocate by a fixed proportion
  • Allocate based on proportion values in a different account

Eliminate Intercompany Balances

  • Identify the workflow process for reconciliation and elimination of intercompany balances
  • Define intercompany accounts and enter period data
  • Define rules to control reconciliation and elimination of intercompany balances
  • Run and analyse reconciliation reports
  • Eliminate intercompany balances and verify postings

Enter Shareholdings and Investments

  • Identify the workflow process for entering shareholdings and investments
  • Prepare the application with necessary settings for entering shareholdings and investments
  • Enter shareholdings and investments data
  • Reconcile shareholdings and investments data

Calculate Acquisition Values

  • Identify the workflow process for calculating acquisition values
  • Define control tables for automatic journals
  • Configure a start period
  • Eliminate acquisition values and verify postings

Consolidate Group Values

  • Identify the workflow process for consolidating the group’s reported values
  • Prepare the application for the consolidation
  • Consolidate the group’s values manually
  • Run and analyse reports on consolidation
  • Review the status of the group’s data

Apply Security

  • Examine the IBM Cognos security architecture
  • Define security restrictions to different parts of the application
  • Define security restrictions for users
  • Run reports on applied security
  • Track changes to metadata
  • Examine options that can be personalized
  • Configure local preferences

Eliminate Intercompany Profit

  • Identify the workflow process for reconciliation and elimination of intercompany profit
  • Define intercompany profit accounts and enter period data
  • Define rules to control reconciliation and elimination of intercompany profit
  • Run and analyse reconciliation reports
  • Eliminate intercompany profit and verify postings

Create Complex Stored Calculations

  • Identify the purpose of advanced formula calculations
  • Identify built-in calculation operators and functions
  • Create advanced formula calculations

Customize the Consolidation Process with User-Defined Business Rules (UDBRs)

  • Customize consolidation rules for customers using user-defined business rules
  • Create and validate a user-defined business rule (UDBR) script
  • Define, map, and run a UDBR job
  • Group companies into subsets
  • Use subsets in UDBRs

Introduction to Reporting with IBM Cognos Controller

  • Explore report types and the role of dimensions in reports
  • Run a report based on a data entry form

Create Ad Hoc Reports

  • Create simple ad hoc reports
  • Compare the data for multiple sets of dimensions
  • Export an ad hoc report to an external application

Verify and Analyse Data for Consolidation

  • Examine the benefits of using standard reports in consolidation
  • Select dimensions to run a simple trial balance
  • Drill down on dimensions to view more details
  • View the details behind a summary account using a ledger report

Create Custom Reports

  • Create advanced reports using the Report Generator
  • Determine which dimensions to use when running a report
  • Examine reporting options available with different dimensions
  • Use Controller functions to build reports

Report on Controller Data in Excel

  • Connect Controller to Excel using the Excel Link
  • Use the Report Generator to open and create reports in Excel
  • Add Controller data to a spreadsheet
  • Refresh workbooks to show the latest Controller data
  • Examine exporting data from a workbook back to Controller
  • Design efficient multi-page reports

Run Groups of Reports

  • Examine the purpose of using report books
  • Create a report book
  • Examine input selection values
  • Examine report output options
  • Run a report book

Optional Cognos Controller training modules

  • A: Consolidation Structure and Extended Dimensions in Sample Data
  • B: Identify Consolidation Models
  • C: Describe different consolidation models

The Cognos Controller training is intended for:

  • Application Developers
  • People with a financial or accounting background

Before attending this Cognos Controller training, you should have:

  • Basic knowledge of group accounting
    Upcoming Dates
  • ` Jun 26 - Jun 30, 2023
  • ` Jul 24 - Jul 28, 2023
  • ` Aug 21 - Aug 25, 2023
  • ` Sep 18 - Sep 22, 2023
  • ` Oct 16 - Oct 20, 2023