Oracle OBIEE

Overview :

OBIEE (Oracle Business Intelligence Suite Enterprise Edition) is a comprehensive Business suite of enterprise BI products that delivers a full range of analysis and reporting capabilities. It gives business users the capability to perform in depth analysis and data mining of detailed business data and gives real and significant information for making critical decisions.

Training Objectives of OBIEE :

OBIEE is the foundation for building enterprise BI (Business Intelligence) Applications. It includes a wide range of end user tools such as interactive dashboards, advanced reporting and publishing, ad hoc analysis across the Web, mobile analytics, proactive detection and alerts, Microsoft Office integration, Web Services and business process integration.

Target Students / Prerequisites :

Students must be familiar with concepts in Oracle.

Course contents :

  • Oracle BI Enterprise Edition Overview
  • Exploring Oracle BI Enterprise Edition User Interfaces
  • Oracle BI Enterprise Edition Architecture
  • Oracle BI Applications Overview Repository Basics
  • Building the Physical Layer of a Repository
  • Building the Business Model and Mapping
  • Layer of a Repository
  • Building the Presentation Layer of a Repository
  • Testing and Validating a Repository
  • Working with Oracle Business Intelligence Answers
  • Building Views and Charts in Requests

Different Views :

  • Table View
  • Compound View
  • No result View
  • Narrative View
  • Pivot View
  • Column selector View
  • view selector
  • Filtering Requests in Oracle Business Intelligence Answers
  • Combined Filter
  • Group Filter
  • Filter Based on other Request
  • Dynamic filter using variable
  • Dynamic filter using Dashboard
  • Creating Interactive Dashboards
  • Configuring Interactive Dashboards
  • Save Dashboard Selection
  • Configuring Guided Navigation Links
  • RPD Adding Multiple Logical Table Sources
  • RPD Adding Calculations to a Fact
  • RPD Creating Dimension Hierarchies and
  • RPD Level-Based Measures
  • RPD Using Aggregates
  • RPD Using Repository Variables
  • RPD Cache Management
  • RPD Using Administration Tool Utilities
  • Security Setup and Features
  • Customizing and Administrating he Oracle Business Intelligence User Interface
  • Multi-User Development
  • Using Oracle Business Intelligence Delivers

III. Budgets in General Ledger :

  • Introduction to Budgets
  • What is Budget
  • Types of Budgets
  • Define Planning Budget
  • Define Budget Organization
  • Enter Budget Amounts
  • Inquiry Account Balances
  • Define Funding Budget
  • Define Funding Organization
  • Enable Reserve for Encumbrance
  • Setup Budget controls
  • Enter Budget Journals
  • Enquiry Funds availability
  • Passing Actual Against Budget
  • Passing Encumbrance against Budget

IV. Purchasing Module :

  • Introduction to Purchasing
  • Prepare Purchase Order
  • Understand Matching Levels
  • Setup Matching Level at PO
  • Enter and Maintain Goods Receipts
  • Perform Inspection Accept/Reject
  • Transfer Stock to Inventory
  • Verify Stock at Inventory Level
  • Cancelling Purchase Order

V. Account Payables :

  • Setup Payment Terms
  • Setup Distribution Sets
  • Setup Internal Banks
  • Setup Supplier Banks
  • Setup Supplier
  • Invoice Workbench
  • Invoices Types in AP
  • Match Invoice with PO
  • Maintain Standard Invoice
  • Understanding types Payments
  • Maintain Payments
  • Maintain Debit Memo
  • Refund from Supplier
  • Types of Prepayment
  • Prepayment with Supplier
  • Prepayment with Employee
  • Generating Expense Report
  • Maintain Mixed Invoice
  • Define special Calendar
  • Withholding Tax Invoice
  • Maintain Recurring Invoices
  • Maintain Interest Invoice
  • Setup Payable Options
  • e tables

VI. Account Receivables :

  • Introduction to Receivables
  • Key flexfields in Receivables
  • Setup Receivables Quick Codes
  • Define Customer Class
  • Define Customer Category
  • Define FOB
  • Define Freight Terms
  • Define Freight Carriers
  • Setup Payment Terms
  • Setup Distribution Sets
  • Define Remittance Banks
  • Setup Customers Banks
  • Define Collectors
  • Define Statement Cycle
  • Define Auto Cash Rule set
  • Setup Customer Profile-Class
  • Enter Standard Customers
  • Define Transaction Types
  • Define Transaction Sources
  • Maintain Invoice
  • Maintain Debit Memo
  • Maintain Credit Memo
  • Maintain Deposit Invoice
  • Maintain Chargeback Invoice
  • Accounting for Invoice
  • View Accounting for Invoice
  • Define Receipt Class
  • Define Receipt Source
  • Maintain Receipts
  • Accounting for Receipt
  • View Accounting for Receipt
  • Raising Remittances
  • View Account Overview
  • View Account Details

Courses Duration : 3-4 weeks

1
Main