copyright © 2005, sas institute inc. all rights reserved. frank eckhausen sr. solutions architect...

Copyright © 2005, SAS Institute Inc. All rights reserved.

Frank EckhausenSr. Solutions ArchitectSAS Worldwide Marketing

Financial Reporting with SAS® Financial ManagementEnhancing Excel with the Power of SAS®

Copyright © 2005, SAS Institute Inc. All rights reserved. 2

Excel


Objectives

Quick SAS Financial Management Overview

Demo - Building Reports with SAS Financial Management and Excel

See Financial Intelligence at work


SAS Financial

Management

Allocations

Partial Ownership

Adjustments

SAS Consolidation and Reporting:

Statutory Consolidation

Dimension Management

Structure Management

User Administration

Data Management Reporting

Alerts

KPI’s

Portal Comments


Form ManagementPlanning Forms

Planning Cycles

Email Integration and Workflow

SAS Budgeting and Planning:

SAS Financial

ManagementAn Integrated Solution

Allocations

Partial Ownership

Adjustments





User Administration


Alerts

KPI’s

Portal Comments



Planning Cycles



SAS StrategicPerformance Management:

Scorecards

Strategy Maps

SAS Financial


Allocations

Partial Ownership

Adjustments





User Administration


Alerts

KPI’s

Portal Comments



Planning Cycles



SAS StrategicPerformance Management:

Scorecards

Strategy Maps

Complementary SAS Solutions and Technologies

Demand Forecasting, Activity Based Management, …

SAS Financial


Allocations

Partial Ownership

Adjustments





User Administration


Alerts

KPI’s

Portal Comments


Reporting Environment The Excel client provides dual interfaces to SAS FM

data:• OLAP table similar to Excel’s pivot table

• Excel function-based interface.

Data Entry forms, as well as reports, can be stored and retrieved from the SAS Portal or on your local machine.


This demonstration illustrates different reporting tasks:• Build a report from scratch using the wizard

• Share the report to the Portal

• Modify an existing report from the Portal

SAS FM Add-in for Excel


Cell Data Access Reports (CDA)

CDA reports extend Microsoft Excel’s functionality to enable users to access SAS FM data on a cell by cell basis.

Multiple ways:• Wizard-driven interface – similar to OLAP report wizard

• Ability to copy from OLAP table

• A Member browser to facilitate picking members

• A set of functions a user can type in to the cells to retrieve data from SAS FM Result Models.


CDA Formulas Use the formulas to get:

• a value with CDAGet

• a description with CDADesc

• a member property with CDAProperty

• an exchange rate with CDAXRate

• a price rate with CDARate


Benefits of CDA Reports

• Cell based – benefits:

− insert rows/columns without affecting the numbers

− use Excel functionality to add/subtract cells

− make adjustments to cell values

• Support for SAS FM security

• Full formatting support.


Drawbacks of CDA Reports

CDA reports do not refresh

• based on metadata changes

• when account or organization is added.

No expand/collapse/drill capability


SAS Financial Management

Highlights• On Demand Consolidation Results

• No Limits on Dimensionality

• Bi-Directional, Dynamic and Secure Link to Underlying Database

• OLAP and Cell Data Access reports

• Powerful Data Management and Data Validation


Excel

copyright © 2005, sas institute inc. all rights reserved. frank eckhausen sr. solutions architect...

Documents