Oracle Financial Analyzer for End-Users

Financial Analyzer

Serebra Learning Corporation

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
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Duration:8 hours
Training Presented in:English
Training Provided by Serebra Learning Corporation
  • L asked: how can i enroll this on-line Oracle Financial Analyzer Traning program and what's the price
  • R asked: Hello, I live in Toronto, Canada. How much would it cost me for shipping if I buy the CD rom from you? Please get back to me soon. Regards,
  • C asked: Hello, My name is and I work for in Chicago Illinois. I am actually in the staffing industry for Information Technology for Fortune companies. I came across your website in search of a candidate with an OFA/Oracle Express background. I was wondering if you might actually have some students who have taken your course and would be interested in a position in Illinois. My direct contact information is included in this email. If you should have any questions, please feel free to contact me directly by phone or by email. Thanks so much for your time, and I look forward to helping out your students!
  • T asked: Want information on course instruction, length, cost, etc
Oracle Financial Analyzer for End-Users
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).
The network 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 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

Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC    V3W 1K5 Canada
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
Want to market your oracle business intelligence training?
Custom Search
tcw11-v473M-12/04/11-18:00:47-()[B]-[B]-[B] -01:44:31