|
Provided by: Serebra Learning Corporation Oracle Financial Analyzer for End-UsersFinancial Analyzer |
![]() |
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.
|
|
||||||||
- 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
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.
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.
8
Minimum RequirementsThe 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).

