Oracle Financial Analyzer for End-Users

Course Overview

This course introduces the learner to the interface and functionality of an Oracle Financial Analyzer Budget workstation. Participants will be able to use Oracle Financial Analyzer (OFA) to enter, modify, analyze, display, and submit financial data. This course covers the OFA interface, reports, graphs, worksheets, solve definitions, models, Web components, and spreadsheet functionality. It also covers maintaining Express data objects and relations within OFA.

Learn To:

  • View data in a report.

    •  
  • Create and format a report.

    •  
  • Perform an ad hoc calculation in a report.

    •  
  • Create an asymmetric report.

    •  
  • Perform an ad hoc query.

    •  
  • View data in a graph.

    •  
  • Create and format a new graph.

    •  
  • Graph a report.

    •  
  • Create and format a worksheet.

    •  
  • Create a new financial data item.

    •  
  • Use worksheet tools to increase and grow data.

    •  
  • Associate a model with a financial data item within a worksheet.

    •  
  • Use a solve definition within a worksheet.

    •  
  • Submit data to the shared database.

    •  
  • Refresh data in the personal database.

    •  
  • Maintain dimensions, dimensions values, financial data items, hierarchies, and attributes.

    •  
  • Create and edit models.

    •  
  • Identify when and why a solve definition should be used.

    •  
  • Create a solve definition.

    •  
  • Display Oracle Financial Analyzer (OFA) documents on the Web.

    •  
  • View OFA data in a Java table or a Java graph.

    •  
  • Export data from a Web document to a spreadsheet.

    •  
  • Define an execute a query in Excel.

    •  
  • Create an asymmetric layout in Excel.

    •  
  • Refresh, clear delete a query.
Content Emphasis

Skills-Based

Audience

Database administrators, database designers, end users and managers.

Total Learning Time

6 - 8 Hour(s)

Course Contents

Unit 1: Oracle Financial Analyzer: An Overview
Duration: 1 Hour(s)
  • Describe each type of Oracle Financial Analyzer workstation.
  • Identify elements in the Oracle Financial Analyzer interface.
  • Identify features of a multidimensional database.
  • Identify a dimension, a dimension value, and a financial data item.
  • Identify a hierarchy and an attribute.
Unit 2: Working with Reports and Graphs
Duration: 1 Hour(s)
  • Label report window components.
  • View data in a report.
  • Create a new report.
  • Format a report.
  • Perform an ad hoc calculation in a report.
  • Create an asymmetric report.
  • Perform an ad hoc query.
  • Label graph window components.
  • View data in a graph.
  • Create a new graph.
  • Format a graph.
  • Graph a report.
Unit 3: Working with Data in a Worksheet
Duration: 1 Hour(s)
  • Identify worksheet window components.
  • Create a new worksheet based on an existing worksheet.
  • Format a worksheet.
  • Create a new financial data item.
  • Use worksheet tools to increase and grow data.
  • Associate a model with a financial data item within a worksheet.
  • Use a solve definition within a worksheet.
  • Submit data to a shared database.
  • Refresh data in a personal database.
Unit 4: Creating and Maintaining OFA Structures
Duration: 1 Hour(s)
  • Maintain dimensions.
  • Maintain dimensions values.
  • Maintain financial data items.
  • Maintain hierarchies.
  • Maintain attributes.
Unit 5: Maintaining Models and Solve Definitions
Duration: 1 - 2 Hour(s)
  • Create a model.
  • Identify when and why a solve definition should be used.
  • Create a solve definition.
Unit 6: Web and Spreadsheet Data Access
Duration: 1 - 2 Hour(s)
  • Compare and contrast Web documents to OFA documents.
  • Identify Web interface components.
  • Display OFA documents on the Web.
  • View OFA data in a Java table.
  • View OFA data in a Java graph.
  • Export data from a Web document to a spreadsheet.
  • Describe the function of the Express Spreadsheet Add-In.
  • Define and execute a query in Excel.
  • Create an asymmetric layout in Excel.
  • Refresh, clear and delete a query.
Regular price: $279.95padSale price: $249.95

Click here for Secure Yahoo Order: Oracle Financial Analyzer for End-Userspad

Get Train in Oracle
Oracle Training CD

Best Regards,
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.