OWC, Undo and Save feature??

[Claude Vernier]

Hi!!

I've created a web interface that propose access to
several OLAP cubes. On each drag&drop of the user on a
OWC Pivot Table, I'd like to save the XMLData locally on
the computer, so the next time a user selects a cube, I
could use its last preferences... Seeking first if an XML
file exists locally for the selected cube and load it or
else, ask the server.

The part I'm not sure how to do is, saving and retrieving
the file... The most cool way would be in the user
profiles, to have a folder with the name of my WebApp and
to store over there the XML files.

Can someone tell me how to open and save those files? Is
it possible? Does someone have done this or tought of a
better way??

Thanks for any advice (and even code why not ;-) )!!
Claude

 

[Thao Moua [ms]]

Yes, you can do a save/load feature for the control. You
save the state of the control by querying the XMLData
property and you restore the control by calling the Load
() method. The save part is done through IE OM and I'm
sure you'll find some example on the IE forum.

Thao Moua
OWC Webchart Support

 

[Claude Vernier]

Thanks you very much!!

I've searched on Google and couldn't find what is IE OM ??
Can you give me a little bit more informations please?

I've started to code this feature using cookies but it
does not work very well, yet.. I'm starting to doubt that
the XMLData can be saved in cookies...

Also, I'd like to ask you (or anybody else ;-) ), if
there is already a feature to swap the rows and columns
in the pivot table, I know it exists in charts...

Also, I'd like a button to swap from to my pivot table to
a chart and vice versa and that the changes made in one
was reflected in the other one... For example, I open IE,
I select my cube, I drag&drop the countries in the rows
and subjects in columns, I want to be able to swap those
but also, to click on a button to get a chart, from the
chart, restrict the countries to Canada and France, click
again on a button to get back to Pivot tables and that my
selection was still at France and Canada...

Is that possible, what is the best way? Any code sample?
Thanks you for everything,
Claude

 

[Alvin Bruney]

what you want to do is this
var hidingPlace
hidingPlace = pt.XMLDATA;
do this on your unload routine when the page unloads

when the page loads do this
pt.XMLDATA = hidingPlace

if your page posts, then the data is lost so you have to persist/or round
trip the data in that case you make a control with tags runat=server and you
unload into that container
when the page loads you load in back. the data will be there because the
control persists the data in viewstate for you. it's basically a free ride

i've griped about that alot by the way. i think that these activeX controls
are not on the same level as html controls and so they ought to have the
intelligence to persist their data because of the multitude of scenarios in
which they are used which do not always include client side programming.