large macro time out with Smart View
SummarySmartView macro timed out
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