Cognos Controller Online Training

Cognos Controller Online Training

0 STUDENTS ENROLLED

    Introduction

    IBM Cognos Controller: Develop Applications (V10.1) is an intermediate five-day instructor-led training course. It is designed to teach application developers how to set up a Controller application and effectively use Controller in their organization’s consolidation process.

    Prerequisites

    • Basic knowledge of group accounting

    Course Content

    1. 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
    2. 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
    3. 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
    4. Configure the Application
      • Examine general configuration settings for a Controller application
      • Examine actualities
      • Identify the three types of actualities
      • Configure a Controller application
    5. 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
    6. 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
    7. 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
    8. Customize the Data Entry View
      • Customize the data entry view
      • Define and group the items you want to restrict
      • Generate reports for linked structures
    9. 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
    10. Test the Application Setup
      • Test structures
      • Manually enter data into the Controller application
      • Reconcile data
      • Examine the status of data
      • Track changes to metadata
    11. 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
    12. 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 analyze currency converted data
    13. 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
    14. Allocate Data
      • Describe the purpose of allocations
      • Allocate by a fixed proportion
      • Allocate based on proportion values in a different account
    15. 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 analyze reconciliation reports
      • Eliminate intercompany balances and verify postings
    16. 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
    17. 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
    18. Consolidate Group Values
      • Identify the workflow process for consolidating the group’s reported values
      • Prepare the application for consolidation
      • Consolidate the group’s values manually
      • Run and analyze reports on consolidation
      • Review the status of the group’s data
    19. 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
    20. 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 analyze reconciliation reports
      • Eliminate intercompany profit and verify postings
    21. Create Complex Stored Calculations
      • Identify the purpose of advanced formula calculations
      • Identify built-in calculation operators and functions
      • Create advanced formula calculations
    22. 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
    23. 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
    24. 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
    25. Verify and Analyze 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
    26. 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
    27. 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
    28. 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

    Write a Review

    Your email address will not be published. Required fields are marked *

    Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. keen Technologies also verifies their technical background and expertise.

    We record each LIVE class session you undergo through and we will share the recordings of each session/class.

    If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers.

    You will work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready.

    Our Trainers will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

    If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

    The Training itself is Real-time Project Oriented.

    Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

    There are some Group discounts available if the participants are more than 2.

    As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, India and other parts of the world.

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 1 month, 1 week
    Contact Us

    +1 475-212-0075

    Drop us a query

    Job Support

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies

    Disclaimer

    This web site or keentechnologies.com team is not associated with SAP AG or any other product. We are providing this service absolutely for Education and Training purpose only. We charge for the support services only, not for the actual SAP System access. Keen Technologies does not provide official SAP training courses or certifications and does not provide any access to SAP software. SAP and its product names, including HANA, S/4HANA, HYBRIS, and LEONARDO are trademarks or registered trademarks of SAP in Germany and other countries.

    Keen Technologies does not provide official SAP training courses or certifications and does not provide any access to SAP software. SAP and its product names, including HANA, S/4HANA, HYBRIS, and LEONARDO are trademarks or registered trademarks of SAP in Germany and other countries.

    IBM® is a registered trademark of IBM in the United States.

    Popular Courses

    Countries

    Keen Technologies offering training in cities: Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Texas, Chicago, San Francisco, Dallas, Washington, New York, Houstan, Atlanta, Orlando, Boston, Toronto, Ottawa, Windsor, Australia, Dubai, Leeds.


    ONLINE MEETING PARTNERS

    top
    COPYRIGHT © 2020 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED