I am referencing to the guide below in order to have a view of a table in OBIEE to refresh using VBA.
The code worked well but I’ve got the “Cannot connect to provider. The attempt to connect to the server failed. Make sure the server is running in the specified URL” error for the line below.
obiee.InsertView InsertServer, InsertAnswer, PromptTable, prompts, Default_Format, SameSheet
I think it has something to do with the syntax of the file path.
Friendly Name localhost
Catalog Folder /users/chris.cheng/testing/
Report Name test
Report Table tableView!1
Prompt Table tableView!2