Forum Stats

  • 3,826,625 Users
  • 2,260,682 Discussions
  • 7,897,041 Comments

Discussions

Smart View / VBA / Open Form

Menagerp
Menagerp Member Posts: 13
edited Nov 2, 2017 6:13AM in Planning and Budgeting

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.

Tagged:

Best Answer

  • Menagerp
    Menagerp Member Posts: 13
    edited Nov 2, 2017 6:13AM 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

This discussion has been closed.