OnRails.org

  def report_as_xml
    sql = <<-EOSQL
    SELECT
     date.calendar_year,
     date.calendar_quarter,
     date.calendar_month_name,
     author.name,
     file_revision_facts.file_changed AS `file_changed`
    FROM
     file_revision_facts
    JOIN date_dimension as date
     ON file_revision_facts.date_id = date.id
    JOIN author_dimension as author
     ON file_revision_facts.author_id = author.id
    WHERE 
      date.calendar_year > '2005'
    EOSQL
    
    @@xml ||= ActiveRecord::Base.connection.select_all(sql).to_xml(:dasherize => false)
    render :text => @@xml
  end

	var data:ICollectionView = new ArrayCollection(result.records.record); // is Array
	cube.dataProvider = data;
	cube.addEventListener(CubeEvent.CUBE_COMPLETE, creationCompleteHandler);
	cube.refresh();		

	[Bindable]
	private var cubeResult:IOLAPResult;

	private function creationCompleteHandler(event:CubeEvent):void
	{
		//Cube was created, let's query it
		var query:OLAPQuery = new OLAPQuery;
			
		// TIME DIMENSION			
		var yearSet:IOLAPSet = new OLAPSet;
		yearSet.addElements(cube.findDimension("Time").findAttribute("Year").members);
		
		var quarterSet:IOLAPSet = new OLAPSet;
		quarterSet.addElements(cube.findDimension("Time").findAttribute("Quarter").members);
		
		//year-quarter
		var newTimeSet:IOLAPSet = yearSet.crossJoin(quarterSet);
		

		// AUTHOR	DIMENSION	
		var authorSet:IOLAPSet = new OLAPSet;
		authorSet.addElements(cube.findDimension("Author").findAttribute("Name").members);

		// ROW/COLUMNS		
		var rowAxis:IOLAPQueryAxis = query.getAxis(OLAPQuery.ROW_AXIS);
		rowAxis.addSet(authorSet.hierarchize(true));
		var colAxis:IOLAPQueryAxis = query.getAxis(OLAPQuery.COLUMN_AXIS);
		colAxis.addSet(newTimeSet.hierarchize(true));

		// QUERY CUBE
		var token:AsyncToken = cube.execute(query);
       token.addResponder(new AsyncResponder(displayResult, olapFaultHandler));
	}
	private function displayResult(result:Object, token:Object=null):void
	{
		cubeResult = result as IOLAPResult;
	}

<mx:OLAPDataGrid id="olapGrid" dataProvider="{cubeResult}" />

	[Bindable]
	private var chartData:Array;

	private function gridSelectionChanged():void {
		if (!(olapGrid.selectedItem is OLAPAxisPosition)) return;
		var rowIndex:Number = olapGrid.selectedIndex;
		var axis:IOLAPQueryAxis = cubeResult.query.getAxis(OLAPQuery.COLUMN_AXIS);
		var columnLength:Number = cubeResult.getAxis(OLAPQuery.COLUMN_AXIS).positions.length;
		var newChartData:Array = [];
		for (var i:int=0;i<columnLength;i++) {
			var tuple:OLAPTuple = axis.tuples[i];
			var key:String = tuple.explicitMembers.toArray().join(",");
			if (key.indexOf("(All)") > -1) continue;			newChartData.push({key:key, value:cubeResult.getCell(rowIndex, i).value});
		}
		chartData = newChartData;
	}

<mx:ColumnChart id="chart" width="100%" height="30%" dataProvider="{chartData}">
        <mx:series>
            <mx:ColumnSeries yField="value" />
        </mx:series>
        <mx:horizontalAxis>
            <mx:CategoryAxis categoryField="key" />
        </mx:horizontalAxis>
</mx:ColumnChart>

<?xml version="1.0" encoding="utf-8"?>
<mx:WindowedApplication xmlns:mx="http://www.adobe.com/2006/mxml" layout="vertical"
	nativeDragDrop="onDrop(event)"
	nativeDragEnter="onDragIn(event)" 	>
<mx:Script>
	<![CDATA[
	import flash.desktop.ClipboardFormats;	
	import flash.utils.CompressionAlgorithm;
	public function onDragIn(event:NativeDragEvent):void {
	    var transferable:Clipboard = event.clipboard;
	    if (transferable.hasFormat(ClipboardFormats.FILE_LIST_FORMAT)) {
	            DragManager.acceptDragDrop(this);
	    }      
	}
	public function onDrop(event:NativeDragEvent):void {
		var fileList:Array = event.clipboard.dataForFormat(ClipboardFormats.FILE_LIST_FORMAT) as Array;
		if (fileList.length==0) return;

		var inFile:File = fileList[0];
		var fileStream:FileStream = new FileStream();
		fileStream.open(inFile, FileMode.READ);
		var ba:ByteArray = new ByteArray();
		fileStream.readBytes(ba, 0, fileStream.bytesAvailable);
		fileStream.close();
		
		var newFileName:String = inFile.nativePath+".zlib";
		ba.compress();
		
		var outFile:File = new File(newFileName);
		fileStream = new FileStream();
		fileStream.open(outFile, FileMode.WRITE);
		fileStream.writeBytes(ba, 0, ba.length);
		fileStream.close();		
	}					
	]]>
</mx:Script>	
</mx:WindowedApplication>

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="vertical" creationComplete="loadData()">
<mx:Script>
	<![CDATA[
	import mx.rpc.events.ResultEvent;
	import flash.utils.ByteArray;
	
    import flash.events.*;
    import flash.net.*;	
	
	private function loadData():void {
 		var loader:URLLoader = new URLLoader();
 		loader.dataFormat = "binary";
 		loader.addEventListener(Event.COMPLETE, completeHandler); 
 		var request:URLRequest = new URLRequest("../data/report.xml.zlib");
 		loader.load(request);
	}
	private function completeHandler(event:Event):void {
        var loader:URLLoader = URLLoader(event.target);
		var ba:ByteArray = loader.data;
		ba.uncompress();
		var s:String = ba.toString();
		var xml:XML = new XML(s);
    }
	]]>
</mx:Script>	
</mx:Application>

app/models/category.rb
class Category < ActiveRecord::Base
  acts_as_nested_set
end

app/controllers/categories_controller.rb
class CategoriesController < ApplicationController
  def index
     Category.result_to_attributes_xml(Category.root.full_set)
  end
end

ActsAsNestedSet.mxml
<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" 
  layout="vertical"
  applicationComplete="categories.send()">
<mx:HTTPService id="categories" url="http://localhost:3000/categories" resultFormat="e4x" />
<mx:Tree dataProvider="{categories.lastResult}" 
  labelField="@name"
  width="100%" height="100%" />  
</mx:Application>

XML generated by Category.result_to_attributes_xml(Category.root.full_set)
<node name="Main Category" id="15" description="">
  <node name="Cameras &amp; Photo" id="16" description="">
    <node name="Bags" id="17" description=""/>
    <node name="Accessories" id="18" description=""/>
    <node name="Analog Cameras" id="19" description=""/>
    <node name="Digital Cameras" id="20" description=""/>
  </node>
  <node name="Cell Phones" id="21" description="">
    <node name="Accessories" id="22" description=""/>
    <node name="Phones" id="23" description=""/>
    <node name="Prepaid Cards" id="24" description=""/>
  </node>
  <node name="Dvds" id="25" description="">
    <node name="Blueray" id="26" description=""/>
    <node name="HD DVD" id="27" description=""/>
    <node name="DVD" id="28" description=""/>
  </node>
</node>

Example Test Case
package tests
{
  import flexunit.framework.*;  
  import mx.rpc.AsyncToken;
  import mx.rpc.events.ResultEvent;
  import resources.Rafflespackage tests

{

  import flexunit.framework.*;  

  import mx.rpc.AsyncToken;

  import mx.rpc.events.ResultEvent;

  import resources.Raffles;
public class TestRaffles extends BaseTestCase
{
private var raffles:Raffles;
public function TestRaffles(name : String = null)
{
super(name);
fixtures(["raffles"]);
raffles = new Raffles();
}
public function testRemoteFindRaffle():void
{
assertRemote(raffles.show(1));
}
public function assertRemote_testRemoteFindRaffle(data:Object):void
{
Assert.assertTrue("Raffle show successfully called", data is ResultEvent);
assertEquals("MyString", data.result.name);
}

}
}

  if RAILS_ENV == "test"
    map.resources :fixtures, :new => { :test_results => :post }
    map.crossdomain '/crossdomain.xml', :controller => 'fixtures', :action => 'crossdomain'
  end