Training offering

IBM Cognos Financial Statement Reporting (FSR) (V6.6)

Description

The IBM® Cognos® Financial Statement Reporting (FSR) 6.6 course is a hands-on instructor-led course that provides Administrators with knowledge on how to build and maintain financial statement reporting documents using FSR 6.6.

Participants

This intermediate course is for Administrators.

Prerequisite(s)

You should have:

Knowledge of Microsoft Excel and Microsoft Word
Experience with financial/accounting principals

Programme

Creating an FSR Report

Creating Report Sections
Creating a Page Setup Object
Creating Excel and Word Content Objects
Workflow Setup
Creating Headers and Footers
Sharing Objects and Exporting Excel Objects

Working with Content and Data

Introduction to FSR Data Load Methods
Loading Data from an OLAP Source
Using an OLAP Reference Variable
Loading Data from Excel Spreadsheets
Using Charts in FSR
Loading Supporting Data from a Web Page
Overview of FSR Variables
Superscripts and Notes
Variables in PowerPoint
Creating Block Variables, Validation Rules,
Applying Section Variables

Administrative Tasks in FSR

Working with Checklists in a Report
Using Customized Group
Viewing the Audit Trail, Snapshot
Creating a Workflow Rule
Overview of FSR Roles
Creating Users and Setting Permissions
Copying an FSR Report for Yearly Rollover

Advanced Topics

Loading Data from Query Builder
Adding, Creating, Validating and Executing a Query
Loading a Query in Excel
Applying a Query Variable
Insert AR Workflow
Account Mapping Interface
Creating Dimensions and Domain Members
Creating and Editing The Account Structure, Journal Entries
Restructuring Accounts
Configuring and Performing Calculations
Exporting Data
Applying Variables and Formulas
Loading Advanced Account Mapping Data in Excel
Using Variables for Dimension Names
Clearing Fact Data