Saving pivottable OWC views?

[mrwoopey]

Could somebody post code to save and load pivottable views?
For now I need to save it to XML. The techinique that is used here doesn't work:
http://msdn.microsoft.com/msdnmag/issues/03/10/OLAP/default.aspx

Thanks!

P

 

[Claude Vernier]

The key feature is the XMLData member of the pivot table,
for example, you can add a button:

<input id="btnDisplayXML" onclick="javascriptopupXMLData
();" type="button" value="View XML">

and the function:

function PopupXMLData()
{
if( document.getElementById("OWCPivotTable") )
{
var oPopup = window.createPopup();
var oPopBody = oPopup.document.body;
oPopBody.style.backgroundColor = "lightyellow";
oPopBody.style.border = "solid black 1px";
oPopBody.innerText =
document.frmDisplayOWC.OWCPivotTable.XMLData;

var iScreenWidth = screen.availWidth;
var iScreenHeight = screen.availHeight;

var iFrmWidth = iScreenWidth * 0.75;
var iFrmHeight = iScreenHeight * 0.75;

oPopup.show( (iScreenWidth-iFrmWidth)/2,
(iScreenHeight-iFrmHeight)/2, iFrmWidth, iFrmHeight);
}
}


There is plenty of ways to use this XMLData, you can save
it in a hidden tag and post it to the server or store it
locally on the computer so the user can load it later on.

Personnaly, I save the XML on the server and the user can
select which view he wants and I only need to load the
pivot table with the content of the file.

You can also get an XML Schema from the file and create
it as a class, using C# serialization you can build your
view...

Good luck and merry christmas,
Claude