| Jim Thomlinson 2006-03-23, 8:37 pm |
| I am having some issues with the Microsoft Cube Analysis Addin. Specifically
the issue seems to revolve around events. In thier literature these is a not
that "Events are suppressed when building, refreshing or manipulating
reports. Where I have a problem is that there are instances where the events
do not get re-enabled. After that any event code I have does not fire. It is
very hard to write VBA when I can not gurantee that events will fire. On top
of that when I am working with sheets that have report s on them I am
constanly getting a VBA error message that my project is being reset. What is
up here and is there any fix for this?
The second issue that I have is that I have Essbase on my machine. I know
that when you zoom in on a memeber in Essbase it fires the selection change
event (repeatedly). The Cube analysis Addin seems to recognize when zoomin is
clicked from the menu but it does not effective deal with a zoomin prompted
by a double click. The Cube analysis addin fires code with each selection
change event and the retrieves flash repeatedly and take an exhorbanenet
amount of time to complete.
Any help in this would be appreciated...
Jim Thomlinson
|