Analytics Software

This post is similar to a post from about 2 years ago. There was no solution posted. Hopefully, a solution will be available now.

I'm writing Visual Basic code to extract data from an HFM application. I have obtained the Entity IDs for all base entities in the app. I was planning to loop through the Entities and extracting data by:

creating the corresponding currency cubes
begin enumeration of the currency cubes
extracting the data from each populated intersection
then end enumeration
destroy currency cube

This works great for single entities. When looping through dozens or more entities, the program freezes after 6 or 7 entities. It looks like the program is getting stuck on the .BeginEnumerationOfStoredData step after the cube is created.

The application appears to be doing nothing - no cpu no IO - it seems it's waiting for something to happen.

I know the BeginEnumerationOfStoredData step involves locking the currencycube and the EndEnumerationOfStoredData step releases the lock. I thought it may be a timing issue. When I step through with the debugger, the program also stalls.

Any ideas?