Oracle Financial Analyzer for End-Users

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.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

Database administrators database designers end users and managers.

Objective

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

Topics Include

Unit 1: Oracle Financial Analyzer: An Overview

• 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

• 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

• 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

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

Unit 5: Maintaining Models and Solve Definitions

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

Unit 6: Web and Spreadsheet Data Access

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

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

• Introduction to Data Warehousing
• Oracle Financial Analyzer 11i for End-Users