Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Using the SmartView Toolkit to connect to HFM

Summary:

Does anybody have an example using the HypConnect API in Excel to connect to an on premise HFM application?

Content (please ensure you mask any confidential information):

I know this isn't a cloud application, but I am hoping somebody that has done this in the past, or currently, has successfully connected with the toolkit. I haven't used it in years, and I never used it to connect to HFM.

I can connect using a connection in SmartView manually (https://****.com/workspace/SmartViewProviders).

My VBA is  sts = HypConnect(Null, "my id", "my pw", "https://****.com/hfmadf/officeprovider|****.com|app name|")

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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