Financial Reporting wit SAS Financial Management Enhancing Excel

Financial Reporting wit SAS® Financial Management Enhancing Excel with the Power of SAS® Frank Eckhausen Sr. Solutions Architect SAS Worldwide Marketing Copyright © 2005, SAS Institute Inc. All rights reserved.

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

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. 3

SAS Financial Manageme nt SAS Consolidation and Reporting: KPI’s Dimension Management Structure Management Data Management Reporting Partial Ownership Portal Comments Adjustments User Administration Allocations Alerts Statutory Consolidation Copyright © 2005, SAS Institute Inc. All rights reserved. 4

SAS Financial Manageme nt SAS Consolidation and Reporting: An Integrated Solution KPI’s Dimension Management Structure Management Data Management Reporting Partial Ownership Portal Comments Adjustments User Administration Allocations Alerts Statutory Consolidation Copyright © 2005, SAS Institute Inc. All rights reserved. SAS Budgeting and Planning: Planning Cycles Planning Forms Form Management Email Integration and Workflow 5

SAS Financial Manageme nt SAS Consolidation and Reporting: SAS Strategic Performance Management: Scorecards Strategy Maps KPI’s Dimension Management Structure Management Data Management Reporting Partial Ownership Portal Comments Adjustments User Administration Allocations Alerts Statutory Consolidation Copyright © 2005, SAS Institute Inc. All rights reserved. An Integrated Solution SAS Budgeting and Planning: Planning Cycles Planning Forms Form Management Email Integration and Workflow 6

SAS Financial Manageme nt SAS Consolidation and Reporting: SAS Strategic Performance Management: Scorecards Strategy Maps KPI’s Dimension Management Structure Management Data Management Reporting Partial Ownership Portal Comments Adjustments User Administration Allocations Alerts Statutory Consolidation An Integrated Solution SAS Budgeting and Planning: Planning Cycles Planning Forms Form Management Email Integration and Workflow Complementary SAS Solutions and Technologies Demand Forecasting, Activity Based Management, … Copyright © 2005, SAS Institute Inc. All rights reserved. 7

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. 8

SAS FM Add-in for Excel § 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 Copyright © 2005, SAS Institute Inc. All rights reserved. 9

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. 10

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. 11

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. 12

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. 13

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. 14

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

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