Unable to Connect my Sheet to database with Smatview vba
SummaryUnable to Connect my Sheet to database with Smatview vba
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