What's new in Customer Journeys?

Connect and learn more! ×
large macro time out with Smart View — Cloud Customer Connect
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

large macro time out with Smart View

Received Response
edited Dec 4, 2018 3:45PM in Essbase 1 comment


SmartView macro timed out


Hi all,

I use macros to generate a lot of report each month (something around 4000 excel files)

The macro is quite simple: it puts value in a Essbase/Smartview range and actualize it, saze as pdf and go for another run with different value.

I can't publish my whole code but I use some basic functions of SmartView plugin

in this order:

X = HypConnect(Empty, User, pwd, cube)

sts = HypRetrieveRange(Empty, range, cube)

U = HypDisconnect(Empty, True)


Before this, i have basic VBA code, and same after.

My issue is quite strange because when I start the macro, everything is working, tabs are updated and files generated


Howdy, Stranger!

Log In

To view full details, sign in.


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