| |
DynamiCube Support
Started by jfradkin at 01-07-2009 6:40 AM. Topic has 3 replies.
  
|
|
Sort Posts:
|
|
|
|
 01-07-2009, 6:40 AM
|
jfradkin
Joined on 09-03-2003
Posts 37
|
export color changes to individual cells
|
|
|
|
|
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?
|
|
|
|
|
Report
|
|
|
|
|
01-08-2009, 7:16 AM
|
Andrey - DD
Joined on 08-01-2007
Russia, Novosibirsk
Posts 671
|
Re: export color changes to individual cells
|
|
|
|
|
|
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.
|
|
|
|
|
Report
|
|
|
|
|
01-08-2009, 7:37 AM
|
jfradkin
Joined on 09-03-2003
Posts 37
|
Re: export color changes to individual cells
|
|
|
|
|
|
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?
|
|
|
|
|
Report
|
|
|
|
|
01-09-2009, 2:54 AM
|
Andrey - DD
Joined on 08-01-2007
Russia, Novosibirsk
Posts 671
|
|
|
|
|
|
|
GrapeCity » Product Support » DynamiCube Supp... » Re: export color changes to individual cells
|
|
|
|
|