OLAP dataGrid add columns??

[davej]

I have data that I am presenting in a datagrid. I need to add the totals for each column and row. I have found OLAPDataGrid that is capable of that. However I cant seem to find a basic tutorial. The few I have found are very complex and involve lots of other queries. I just need a basic start to get myself wrapped around this.

Here is my OLAPCube

<mx:OLAPCube name="FlatSchemaCube"
dataProvider="{results.result}"
id="myMXMLCube">

<mx:OLAPDimension name="STRUCTURESDim">
<mx:OLAPAttribute name="STRUCTURES" dataField="STRUCTURES"/>
<mx:OLAPHierarchy name="STRUCTURESHier" hasAll="true">
<mx:OLAPLevel attributeName="STRUCTURES"/>
</mx:OLAPHierarchy>
</mx:OLAPDimension>

<mx:OLAPDimension name="AVIONICSDim">
<mx:OLAPAttribute name="AVIONICS" dataField="AVIONICS"/>
<mx:OLAPHierarchy name="AVIONICSHier" hasAll="true">
<mx:OLAPLevel attributeName="AVIONICS"/>
</mx:OLAPHierarchy>
</mx:OLAPDimension>

<mx:OLAPDimension name="PROPULSIONDim">
<mx:OLAPAttribute name="PROPULSION" dataField="PROPULSION"/>
<mx:OLAPHierarchy name="PROPULSIONHier" hasAll="true">
<mx:OLAPLevel attributeName="PROPULSION"/>
</mx:OLAPHierarchy>
</mx:OLAPDimension>

<mx:OLAPMeasure name="Revenue"
dataField="revenue"
aggregator="SUM"/>
</mx:OLAPCube>

Any direction would be great.

[JamesLee]

Create spectacular charts in your ASP.NET projects with this high-quality yet cost-effective 2D/3D chart component. Features extensive ASP.NET support including chart streaming, image maps and response, server-side events with postback, persistent states, script injection, browser detection and automatic temporary file cleanup.
Still if you want to know more about OLAP dataGrid then i would recommend a book on OLAP . The book is available on Amazon (http://www.amazon.com/Multidimensional-Data-Modeling-Toolkit-Intelligence/dp/0981775306) & you can buy an e-book directly from the publisher by writing OLAPWorldPress@gmail.com.