Preparing to Work with Oracle BI EE Functions

Before you begin creating and editing VBA functions for Oracle Business Intelligence Enterprise Edition, you must first add references to the Oracle Smart View BI Extension type library and Oracle Smart View for Office type library.

To add Oracle Smart View BI Extensionand Smart View references:

  1. Start the Visual Basic Editor from a Microsoft Office application; for example, from Excel.
  2. Select Tools, then References.
  3. In Available References, check the following items:

    • Oracle Smart View BI Extension

    • Oracle SmartView RC 1.0 Type Library

  4. Click OK.

Continue with Instantiating an Oracle Smart View BI Extension Object.