Preparing to Work with Oracle Analytics Cloud Functions

Before you begin creating and editing VBA functions for Oracle Analytics Cloud, 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.