Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Smart View / VBA / Open Form

Hi there,
I try to open a web form in smart view (11.1.2.5.710) with vba methods
lRet = HypCreateConnectionEx("Planning", "server", app, "Plan1", "/Forms/Form1", "http://server:19000/HyperionPlanning/SmartView", "My conn", user, pass, "Descr My conn", "", "")
lRet = HypUIConnect(Empty, user, pass, "My conn")
lRet = HypSetActiveConnection("My conn")
lRet = HypOpenForm(Empty, "/Forms", "Form1", dimlist, memlist)
HypOpenForm ends with a -41 error (Provider not supported)
Anyone has an idea ?
Thanks a lot.
Regards.
Best Answer
-
Hello, yes i've always see this doc, but with new reading, my problem is finally solved. I change few things in HypCreateConnectionEx(database set to "", form path as "/Forms")
Documentation isn't really clear on this point.
Thanks for your help.
See below:
lRet = HypCreateConnectionEx("Planning", "server", app, "", "/Forms", "http://server:19000/HyperionPlanning/SmartView", "My conn", user, pass, "Descr My conn", "", "")
Answers
-
Per the manual try; -
lRet = HypOpenForm(Empty, "/Forms/Form1", "Form1", dimlist, memlist)
-
Hi Robert,
Thanks for your reply. Sorry, it doesn't work, always the same error.
If i look at the sheet property "sheet info" in excel, sheet type is defined as "Empty", when i open a form manually, sheet type is set to "Form".
Regards
-
-
Hello, yes i've always see this doc, but with new reading, my problem is finally solved. I change few things in HypCreateConnectionEx(database set to "", form path as "/Forms")
Documentation isn't really clear on this point.
Thanks for your help.
See below:
lRet = HypCreateConnectionEx("Planning", "server", app, "", "/Forms", "http://server:19000/HyperionPlanning/SmartView", "My conn", user, pass, "Descr My conn", "", "")