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

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

Objectives

Quick SAS Financial Management Overview

Demo - Building Reports with SAS Financial Management and Excel

See Financial Intelligence at work

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

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

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

Form ManagementPlanning Forms

Planning Cycles

Email Integration and Workflow

SAS Budgeting and Planning:

SAS Financial

ManagementAn Integrated Solution

Allocations

Partial Ownership

Adjustments

SAS Consolidation and Reporting:

Statutory Consolidation

Dimension Management

Structure Management

User Administration

Data Management Reporting

Alerts

KPI’s

Portal Comments

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

Form ManagementPlanning Forms

Planning Cycles

Email Integration and Workflow

SAS Budgeting and Planning:

SAS StrategicPerformance Management:

Scorecards

Strategy Maps

SAS Financial

ManagementAn Integrated Solution

Allocations

Partial Ownership

Adjustments

SAS Consolidation and Reporting:

Statutory Consolidation

Dimension Management

Structure Management

User Administration

Data Management Reporting

Alerts

KPI’s

Portal Comments

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

Form ManagementPlanning Forms

Planning Cycles

Email Integration and Workflow

SAS Budgeting and Planning:

SAS StrategicPerformance Management:

Scorecards

Strategy Maps

Complementary SAS Solutions and Technologies

Demand Forecasting, Activity Based Management, …

SAS Financial

ManagementAn Integrated Solution

Allocations

Partial Ownership

Adjustments

SAS Consolidation and Reporting:

Statutory Consolidation

Dimension Management

Structure Management

User Administration

Data Management Reporting

Alerts

KPI’s

Portal Comments

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

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.

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

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

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

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.

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

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

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

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.

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

Drawbacks of CDA Reports

CDA reports do not refresh

• based on metadata changes

• when account or organization is added.

No expand/collapse/drill capability

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

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

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

Excel

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