SAS Financial Management: Data Administration Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

This SAS Financial Management: Data Administration training course provides skills 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.

By attending SAS Financial Management: Data Administration workshop, delegates will learn 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.

Knowledge of SAS Financial Management
Knowledge of SAS Data Integration Studio

The SAS Financial Management: Data Administration class is ideal for:

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

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

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days

Trained more than 50,000 Corporate executives across the Globe
All our trainings are conducted in workshop mode with more focus on hands-on sessions

SAS Financial Management - Data Administration

COURSE AGENDA