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

VBA Connection to Server - Deprecated data source provider

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

Summary

VBA Connection to Server - Deprecated data source provider

Content

I've been attempting to automate our retrieval process through a VBA script, though have run into problems with the "HypCreateConnection" function. When manually connected to the server, it shows our provider as "Analytic Services Smart View Provider". This suggests we should use vtProvider "HYP_ANALYTICAL_SERVICES" in the HypCreateConnection function. HypCreateConnection returns an error value of "-15, Invalid Connection Parameter"

The most current Developers Documentation says: "The global constant HYP_ANALYTIC_SERVICES = "Analytic Provider Services" is deprecated." What provider should we use instead? Is there an alternate method to connect to our server with?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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