SAS Financial Management is a comprehensive solution for enterprise planning, budgeting, consolidation, and reporting. This course provides an overview of SAS Financial Management and its workspaces. You learn how to create and publish financial reports that comply with regulatory requirements. You also learn how to analyze financial results using real-time information and on-demand consolidations. This self-study course includes structured course notes that provide a detailed overview, essential skills, and exercises, along with a software Virtual Lab to practice.

The e-learning includes:

• digital course notes for self-study
• Virtual Lab: 30 hours of hands-on software practice

Learn how to

• automate core financial computations, including intercompany eliminations, manual and rule-based journal adjustments, and currency translation adjustment
• update and maintain dimensions
• perform cycle and period workspace tasks
• work with multiple exchange rates
• build and use models
• create, share, and enhance financial reports
• build formulas
• create a framework for building and managing business processes.

Who should attend Anyone who is responsible for performing consolidations, generating reports, and analyzing results Formats available Duration
: 21 hours/180 day license

There are no formal prerequisites.

This course addresses SAS Financial Management software.

SAS Financial Management Overview

• SAS Financial Management interfaces -- an overview
• SAS data flow architecture
• FASHBI case study

An Introduction to the SAS Financial Management Web Application

• an introduction to the SAS Financial Management web applications

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

• SAS Financial Management Add-in for Microsoft Excel

An Introduction to SAS Financial Management Studio

• introduction to SAS Financial Management Studio

Security

• SAS Management Console: groups, roles, and capabilities
• SAS Financial Management Studio: setting security

Understanding SAS Financial Management Dimensions

• understanding dimensions
• SAS Financial Management dimensions

The Dimensions Workspace

• an overview of the Dimensions workspace
• 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

Working with Read-Only Tables

• SAS Financial Management Add-in for Microsoft Excel
• creating and publishing a Read-Only table
• changing the layout of a table
• table properties
• other table options

Working with Cell Data Access (CDA) Tables

• overview of cell data access (CDA) tables
• building an initial CDA table
• designing a report with a CDA table

Cycles and the Periods Workspace

• an overview of cycles and the Periods workspace

The Models Workspace

• an introduction to models
• model tasks

Exchange Rates in the Rates Workspace

• exchange rates: an overview
• working with exchange rate sets and exchange rates

Driver Rates in the Rates Workspace

• driver rates: an overview
• working with driver rate sets and 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

• built-in computations: an overview
• elimination adjustments
• account types and frequency conversion
• currency conversion
• retained earnings (RE)
• cumulative translation adjustment (CTA)

Process Management

• about process management
• creating a process definition
• starting a process

FMREPT55.