export color changes to individual cells

01-07-2009, 6:40 AM
With alot of help I got the routine to color individual cells. it uses sub DCube_FetchAttributes(ByVal cellAttrib).
It has been a success and a failure because it keeps trying to run every time anything changes in the cube and there are alot of rows of data so it takes a long time. One major flaw is I can not export to excel with color. Seems like it is trying to call the fethcattribute every time ite exports a cell or something cause the CPU just goes 100% and bye bye IE7. Any ideas how to stabilize this routine so it has value and I can export the cube with the color chages?

Re: export color changes to individual cells

01-08-2009, 7:16 AM
jfradkin,

DynamiCube's FetchAttributes event is fired while exporting to Excel to access cellAttrib object which contains information about cell's color, etc. This is the way DynamiCube is designed. The lower the resources (RAM, processor, etc.), the slower the DynamiCube performance. You can find some tips on how to optimize DynamiCube here:
http://www.datadynamics.com/Help/DynamiCube3/OptimizingDynamiCube.html

Thank you,
Andrey T.

Re: export color changes to individual cells

01-08-2009, 7:37 AM
Thank you for the link.
I looked and none of those ideas be of any help. I removed the color option. I looked bad adding it. The cube does not do color, unless the data set is tiny and mine are not tiny. They should of made a way to store the color, but I understand because of the dynamic nature (the numbers the color is based on can change when the cube is modiied) it may just be a unsolvable problem. It is a major issue though the client still wants a score and even if Iput a score in the data set not sure how that could ever work. They use excel now so that is static and works fine for them. but they want the dynamic cube (our clients love it), so solving the score question might take some thought on my part, but I cant see moving it anywhere else. Probably have to explore the cutting it up into smaller chinks per the url suggestion. Any examples of calling a cube from a cell? I use web based pages, is there a way to have it open another web page and pass paremeters to the page by clicking a cell?

Re: export color changes to individual cells

01-09-2009, 2:54 AM

jfradkin,

Unfortunately, I do not a have a sample which opens new web page and passing parameters.
To get clicked DynamiCube cell parameters, you can use MouseDown event and HitRecord object:
http://www.datadynamics.com/Help/DynamiCube3/DynamiCubeLib~DCube~MouseDown_EV.html
http://www.datadynamics.com/Help/DynamiCube3/DynamiCubeLib~HitRecord.html
The attached web sample demonstrates how to get clicked cell's value.

Thank you,
Andrey T.