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
9
Views
1
Comments
edited Dec 4, 2018 3:45PM in Essbase 1 comment

Summary

SmartView macro timed out

Content

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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