This course demonstrates how to customize SAS Data Integration Studio jobs that are used to move data from organizational data sources to the financial data mart. The course includes an in-depth study of the tables and column data that must be loaded and the jobs that perform these tasks for SAS Financial Management.

The self-study e-learning includes:

• Annotatable course notes in PDF format.
• Virtual Lab time to practice.

Ismerje meg hogyan... use jobs supplied by SAS in SAS Data Integration Studio to

• load dimension members and hierarchies into the staging tables
• load financial transactions into the staging tables
• move data from the staging tables into the solutions data mart
• add new dimension types, members, and member hierarchies
• export financial data from the solutions data mart.

Kinek ajánljuk

Data administrators who maintain the data portion of the SAS Financial Management solution

Elérhető képzési formák	Időtartam
Tantermi:	2.0 nap
e-Learning:	14 óra/180 nap licensz

Before attending this course, you should have knowledge of

• SAS Financial Management
• SAS Data Integration Studio.

You can gain this knowledge by completing the SAS Financial Management: Financial Reporting and SAS Data Integration Studio: Essentials courses.

A tanfolyam SAS Financial Management szoftver használatára épül.

Introduction

• overview of SAS Financial Management
• SAS Financial Management solution data architecture
• case study and demonstration data

Creating the SAS Financial Management Environment

• overview
• after the installation - understanding the state of your system
• preparing the customer data

Loading Users and Groups

• loading users, user groups, and user-member associations

Loading StageFM Tables

Loading Dimension Tables

• dimension members and hierarchies
• general requirements
• detailed requirements
• jobs that load the dimension members and hierarchies
• adding custom properties

Moving Data into the Solutions Data Mart

• moving data into the data mart
• diagnosing errors
• validation

Making Data Available to SAS Data Integration Studio

• defining the source metadata

Adding a New Dimension Type

Adding New Dimensional Data

• loading the StageFM tables
• loading the custom property tables
• moving the dimension data into the data mart
• adding the CUSTOMER dimension

Loading Simple Exchange Rates into a SAS Financial Management Exchange Rate Set

• currency conversion in SAS Financial Management
• loading exchange rate data into StageFM tables
• loading exchange rates into the data mart

Loading Base Accounting Data

• preparing the customer data
• loading base accounting data
• data validation

Loading Driver Rates

• introduction to driver rates
• loading driver rate data into StageFM tables
• loading driver rates into the data mart

Loading Cell Visibility Rules for a Model

• creating visibility rules
• loading and testing visibility rules

Loading Data Validation Rules

Exporting Dimensions

Managing Data Locales

Creating a Stored Process

• overview of stored processes
• creating and running a stored process