dbTalk Databases Forums  

Cellsetgrid - Save Analysis Result

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Cellsetgrid - Save Analysis Result in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
alexl@innovation.com.my
 
Posts: n/a

Default Cellsetgrid - Save Analysis Result - 12-21-2006 , 04:10 AM






Hi,

I would like to save the analysis result from the cellsetgrid to the
database e.g. in the grid, i drop some measure and dimension. Then i
want to save the current coordinate into database so next time i can
automatically populate the previous selected dimension and cube. I
think i can save the MDX definition of the currently selected
dimension/measure, but not sure which files/code in the cellsetgrid
project i should check and modify. Appreciate any help on this. Thanks

Best Regards,
Alex


Reply With Quote
  #2  
Old   
timheff@leeinstitute.com
 
Posts: n/a

Default Re: Cellsetgrid - Save Analysis Result - 12-21-2006 , 08:05 AM






You can grab the value of the XML property off the CellSetGrid instance
and save the XML string into a database field.

alexl (AT) innovation (DOT) com.my wrote:
Quote:
Hi,

I would like to save the analysis result from the cellsetgrid to the
database e.g. in the grid, i drop some measure and dimension. Then i
want to save the current coordinate into database so next time i can
automatically populate the previous selected dimension and cube. I
think i can save the MDX definition of the currently selected
dimension/measure, but not sure which files/code in the cellsetgrid
project i should check and modify. Appreciate any help on this. Thanks

Best Regards,
Alex


Reply With Quote
  #3  
Old   
Mna
 
Posts: n/a

Default Re: Cellsetgrid - Save Analysis Result - 03-08-2007 , 01:56 PM



Hi Alex ,
That is good information,
but when I use the same thing to open the saved xml, it does not accept it,
As follow :
Cellsetgrid .xml = (saved xml)

Do you know a way to save and open the sate of Cellsetgrid

Thanks



"timheff (AT) leeinstitute (DOT) com" wrote:

Quote:
You can grab the value of the XML property off the CellSetGrid instance
and save the XML string into a database field.

alexl (AT) innovation (DOT) com.my wrote:
Hi,

I would like to save the analysis result from the cellsetgrid to the
database e.g. in the grid, i drop some measure and dimension. Then i
want to save the current coordinate into database so next time i can
automatically populate the previous selected dimension and cube. I
think i can save the MDX definition of the currently selected
dimension/measure, but not sure which files/code in the cellsetgrid
project i should check and modify. Appreciate any help on this. Thanks

Best Regards,
Alex



Reply With Quote
  #4  
Old   
Ram
 
Posts: n/a

Default RE: Cellsetgrid - Save Analysis Result - 03-14-2007 , 04:24 AM



Hi
I also having the same problem. How can save the selected measures and dimension and how how can i repopulate the selected measures and dimension in cellsetgrid.
pls help me ASAP

regrads
Ram


From http://developmentnow.com/g/112_2006...sis-Result.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.