You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to Connect my Sheet to database with Smatview vba

edited Aug 2, 2018 2:36AM in Essbase 1 comment

Summary

Unable to Connect my Sheet to database with Smatview vba

Content

I must be inherently doing something wrong and I was hoping you could assist me. I tried writing a vba to connect to and retrieve from one of our Essbase production cubes using vba but it seems I am able to create the connection but unable to actually connect ie (HypConnect) to the vtFriendlyName (ie SalesDB) which is created as a Private connection by the HypCreatconnection I declare. Hence nothing retrieves in Sheet1.

All I am trying to do is to establish a connection to the server and database (which I am able to), but somehow unable to connect to the database with my sheets and also unable to retrieve. I have my code below; My apologies if I am not following some set of rules on how to post. It's my first

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!