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

Overnet Education
A Segrate

2.500 
+IVA
Vuoi parlare del corso con un consulente?
Confronta questo corso con altri simili
Leggi tutto

Informazione importanti

  • Corso
  • Segrate
  • Durata:
    5 Giorni
Descrizione

A continuazione troverai il programma di questo corso disegnato per migliorare le tue competenze e permetterti di realizzare gli obiettivi stabiliti.
Nel corso della formazione si alterneranno differenti moduli che ti permetteranno di acquisire le conoscenze sulle tematiche proposte. Iscriviti per accedere alle seguenti materie.

Informazione importanti
Sedi

Dove e quando

Inizio Luogo
Consultare
Segrate
Via Cassanese, 224, Palazzo Mantegna, Scala A, 20090, Milano, Italia
Visualizza mappa

Programma

  • 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
  • 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
  • Examine the importance of account structures in a Controller application
  • Create and link accounts
  • Maintain an account structure
  • Verify the account structure
  • Examine general configuration settings for a Controller application
  • Examine actualities
  • Identify the three types of actualities
  • Configure a Controller application
  • 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
  • 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 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
  • Define and group the items you want to restrict
  • Generate reports for linked structures
  • Examine the data entry process
  • Enable and define report occasions for data entry
  • Examine different ways of making periods read-only
  • Test structures
  • Manually enter data into the Controller application
  • Reconcile data
  • Examine the status of data
  • Track changes to metadata
  • 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
  • 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
  • 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
  • Describe the purpose of allocations
  • Allocate by a fixed proportion
  • Allocate based on proportion values in a different account
  • 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
  • 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
  • Identify the workflow process for calculating acquisition values
  • Define control tables for automatic journals
  • Configure a start period
  • Eliminate acquisition values and verify postings
  • 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
  • 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
  • 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
  • Identify the purpose of advanced formula calculations
  • Identify built-in calculation operators and functions
  • Create advanced formula calculations
  • 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
  • Explore report types and the role of dimensions in reports
  • Run a report based on a data entry form
  • Create simple ad hoc reports
  • Compare the data for multiple sets of dimensions
  • Export an ad hoc report to an external application
  • 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 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
  • 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
  • Examine the purpose of using report books
  • Create a report book
  • Examine input selection values
  • Examine report output options
  • Run a report book

A: Consolidation Structure and Extended Dimensions in Sample Data (Optional)

B: Identify Consolidation Models (Optional)

  • describe different consolidation models

Dotazione:
Each participant will have a station set up with operating systems and software needed for the exercises.


Confronta questo corso con altri simili
Leggi tutto