This course introduces learners to the interface and functionality of Oracle Financial Analyzer (OFA) 11i budget workstation, interactive Web environment, and Express Spreadsheet Add-In. Learners also will use case-study scenarios to explore the OFA and Oracle Express Server consolidated multidimensional database system. Additionally, learners will design and analyze financial documents, such as budgets and forecasts, and enter and modify financial data using an OFA worksheet and Web data entry form. Learners will submit data and documents to the shared database to share with other OFA users and monitor the process using the task queue. Learners also will create and maintain dimensions, dimension values, financial data items, solve definitions, models, attributes, and hierarchies.
Course Objectives
- Identify special features of the Express and OFA consolidated system
- Create data structures by using the Maintain menu commands
- Select data by using the Selector dialog box
- Apply format characteristics to document elements by using various formatting commands
- Submit data and documents to the shared database by using the Submit menu commands
- Analyze data and change views by using reports, graphs, and worksheets in the client interface
- Analyze data and change views by using Java tables, graphs, and data entry forms in the Web interface
- Install the Express Spreadsheet AddIn and work with spreadsheets
Course Benefits
- Identify special features of the Express and OFA consolidated system
- Create data structures by using the Maintain menu commands
- Select data by using the Selector dialog box
- Apply format characteristics to document elements by using various formatting commands
- Submit data and documents to the shared database by using the Submit menu commands
- Analyze data and change views by using reports, graphs, and worksheets in the client interface
- Analyze data and change views by using Java tables, graphs, and data entry forms in the Web interface
- Install the Express Spreadsheet AddIn and work with spreadsheets