MedInfoMan
IS-IT--Management
Hello,
I'd like to read the values contained in a dataprovider cube and put them into an array in VBA. (From there, I'll apply some additional data processing and put the data into a new cube using a VBA Stored Procedure).
Now, I see how to read the number of rows and the columns names from the cube ok, but not the individual data elements in the cube which seems sort of odd. I could always export the cube to an external file,and read it from there with visual basic file I/O commands, but, I'd like to avoid that route, and just do it in memory.
Any help will be most appreciated!
I'd like to read the values contained in a dataprovider cube and put them into an array in VBA. (From there, I'll apply some additional data processing and put the data into a new cube using a VBA Stored Procedure).
Now, I see how to read the number of rows and the columns names from the cube ok, but not the individual data elements in the cube which seems sort of odd. I could always export the cube to an external file,and read it from there with visual basic file I/O commands, but, I'd like to avoid that route, and just do it in memory.
Any help will be most appreciated!