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

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