This course provides an overview of SAS Financial Management and its workspaces. Students learn to create financial reports that adhere to corporate and government standards. They learn how to analyze financial results using real-time information and on-demand consolidation.

Learn how to

• automate core financial computations, including intercompany eliminations, rule-based journal entries, and foreign currency translations
• update and maintain dimensions
• perform cycle workspace tasks
• work with exchange rates
• build and use models
• create, share, and enhance reports
• build formulas.

Who should attend

Anyone who is responsible for performing consolidations, generating reports, and analyzing results

Formats available	Standard duration
Classroom:	3 days

There are no formal prerequisites.

This course addresses SAS Financial Management software.

SAS Financial Management Overview

• touring SAS Financial Management interfaces and products
• SAS data flow architecture
• FASHBI case study

An Introduction to the SAS Information Delivery Portal

• working in the SAS Information Delivery Portal

An Introduction to the SAS Financial Management Add-in for Microsoft Excel

• working with the SAS Financial Management Add-in for Microsoft Excel

An Introduction to SAS Financial Management Studio

• exploring cycles and workspaces in SAS Financial Management Studio

Security

• groups and roles
• setting security in SAS Financial Management Studio

Understanding SAS Financial Management Dimensions

• understanding dimensions
• understanding SAS Financial Management dimensions and dimension members

The Dimensions Workspace

• an overview of the Dimensions workspace
• viewing dimensions, hierarchies, and members
• member custom properties
• data locales and calendar templates

Required Dimension Types

• Account dimension type
• Organization and Trader dimension types
• Analysis dimension type
• Currency dimension type
• Time and Frequency dimension types
• Source dimension type

Cycles and the Periods Workspace

• overview of cycles and the Periods workspace

The Models Workspace

• introduction to models
• model tasks

Creating Read-Only Tables Using the SAS Financial Management Add-in for Microsoft Excel

• SAS Financial Management Add-in for Microsoft Excel
• creating and publishing a read-only table
• modifying the table layout
• table property options
• other table options

Creating CDA Tables Using the SAS Financial Management Add-in for Microsoft Excel

• overview of cell data access (CDA) reports
• building a CDA report
• enhancing CDA reports

Exchange Rates in the Rates Workspace

• overview of exchange rates
• exchange rate sets and exchange rates

Driver Rates in the Rates Workspace

• overview of driver rates
• creating and managing driver rates

An Overview of Formula Types and Formulas

• overview of formula types
• optimizing formula performance

Model Manual Adjustments and Adjustment Rules

• overview of the model adjustment process
• manual adjustments
• adjustment rules

Built-in Computations

• overview of built-in computations
• elimination adjustments
• account types and frequency conversion
• currency conversion
• retained earnings (RE)
• Cumulative Translation Adjustment (CTA)