Hey Bob. I'm using cube functions through VBA exactly because of the performance issue you've mentioned. I have to perform this operation to 127.108 rows, selecting data from the cube:


(TOTAL OF SALES IN VALUE / TOTAL OF SALES IN QUANTITY)


Using '=CUBEVALUE' and '=CUBESET' functions, each cell remains in the status "#GETTING_DATA" and after several minutes, a error message is issued.
Reading the MSDN threads, I found that in 2010 you was facing a similar situation:


https://social.msdn.microsoft.com/Fo...alysisservices


Do you know how can I perform this operation quickly, Bob? I've started working with these OLAP cubes on wednesday at my new job, so I'm stumbling a lot!


Thanks a lot.