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|")
Tagged:
0