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

HypRetrieveRange() return error 4 when executed in loop

Received Response
5
Views
3
Comments
edited Feb 4, 2019 2:32PM in Essbase 3 comments

Summary

HypRetrieveRange() return error 4 when executed in loop

Content

Hi everyone,

I have a small macro where I use the function HypRetrieveRange() on a selected range and everything works fine.

But when I use this function in a loop with for example 20 ou 25 ranges to refresh, the function return an error "4" which is basically "we don't know what is happening"

I looked in developer's guide but I don't see any restriction to use this function.

I tried with adding a delay of 10sec before each refresh but this is the same. I put my code below in the snippet

 

Thank you

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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