Connecting to Essbase on OCI using VBA
Summary:
I am looking for a way to connect to Essbase on OCI via VBA through Smartview.
Content (please ensure you mask any confidential information):
I'd like, if possible, the syntax needed to connect to Essbase on OCI through VBA using SmartView. I've gone through documentation but the difference between the connections and then having the possibly use a different type of authentication is tripping me up. I'm trying to use this in combination with any method to modify or update sheet connections, as we are moving from one Essbase cloud server to another, and all connections must be modified and updated. Any guidance would be appreciated. I've seen documents below: