Preparing to Work with Oracle BI EE Functions
Before you begin creating and editing VBA functions for Oracle BI EE, 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 Extension and Smart View references:
Start the Visual Basic Editor from a Microsoft Office application; for example, from Excel.
Select Tools, then References.
In Available References, check the following items:
Click OK.
Continue with Instantiating an Oracle Smart View BI Extension Object.