| <!-- |
| Licensed to the Apache Software Foundation (ASF) under one or more |
| contributor license agreements. See the NOTICE file distributed with |
| this work for additional information regarding copyright ownership. |
| The ASF licenses this file to You under the Apache License, Version 2.0 |
| (the "License"); you may not use this file except in compliance with |
| the License. You may obtain a copy of the License at |
| |
| http://www.apache.org/licenses/LICENSE-2.0 |
| |
| Unless required by applicable law or agreed to in writing, software |
| distributed under the License is distributed on an "AS IS" BASIS, |
| WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| See the License for the specific language governing permissions and |
| limitations under the License. |
| --> |
| <!-- saved from url=(0014)about:internet --> |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html xmlns="http://www.w3.org/1999/xhtml"> |
| <head> |
| <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> |
| <title>sample1.mxml</title> |
| <link rel="stylesheet" type="text/css" href="../SourceStyles.css"/> |
| </head> |
| |
| <body><pre><span class="MXMLProcessing_Instruction"><?xml version="1.0" encoding="utf-8"?></span> |
| <span class="MXMLComponent_Tag"><mx:Application</span><span class="MXMLDefault_Text"> xmlns:mx="</span><span class="MXMLString">http://www.adobe.com/2006/mxml</span><span class="MXMLDefault_Text">" layout="</span><span class="MXMLString">vertical</span><span class="MXMLDefault_Text">" verticalAlign="</span><span class="MXMLString">top</span><span class="MXMLDefault_Text">" |
| horizontalAlign="</span><span class="MXMLString">center</span><span class="MXMLDefault_Text">" backgroundGradientColors="</span><span class="MXMLString">[0x000000,0x323232]</span><span class="MXMLDefault_Text">" paddingTop="</span><span class="MXMLString">0</span><span class="MXMLDefault_Text">" creationComplete="</span><span class="ActionScriptDefault_Text">creationCompleteHandler</span><span class="ActionScriptBracket/Brace">()</span>;<span class="MXMLDefault_Text">" viewSourceURL="</span><span class="MXMLString">srcview/index.html</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">></span> |
| |
| <span class="MXMLSpecial_Tag"><mx:Script></span> |
| <span class="ActionScriptOperator"><!</span><span class="ActionScriptBracket/Brace">[</span><span class="ActionScriptDefault_Text">CDATA</span><span class="ActionScriptBracket/Brace">[</span> |
| <span class="ActionScriptReserved">import</span> <span class="ActionScriptDefault_Text">mx</span>.<span class="ActionScriptDefault_Text">rpc</span>.<span class="ActionScriptDefault_Text">AsyncResponder</span>; |
| <span class="ActionScriptReserved">import</span> <span class="ActionScriptDefault_Text">mx</span>.<span class="ActionScriptDefault_Text">rpc</span>.<span class="ActionScriptDefault_Text">AsyncToken</span>; |
| <span class="ActionScriptReserved">import</span> <span class="ActionScriptDefault_Text">mx</span>.<span class="ActionScriptDefault_Text">olap</span>.<span class="ActionScriptDefault_Text">OLAPQuery</span>; |
| <span class="ActionScriptReserved">import</span> <span class="ActionScriptDefault_Text">mx</span>.<span class="ActionScriptDefault_Text">olap</span>.<span class="ActionScriptDefault_Text">OLAPSet</span>; |
| <span class="ActionScriptReserved">import</span> <span class="ActionScriptDefault_Text">mx</span>.<span class="ActionScriptDefault_Text">olap</span>.<span class="ActionScriptDefault_Text">IOLAPQuery</span>; |
| <span class="ActionScriptReserved">import</span> <span class="ActionScriptDefault_Text">mx</span>.<span class="ActionScriptDefault_Text">olap</span>.<span class="ActionScriptDefault_Text">IOLAPQueryAxis</span>; |
| <span class="ActionScriptReserved">import</span> <span class="ActionScriptDefault_Text">mx</span>.<span class="ActionScriptDefault_Text">olap</span>.<span class="ActionScriptDefault_Text">IOLAPCube</span>; |
| <span class="ActionScriptReserved">import</span> <span class="ActionScriptDefault_Text">mx</span>.<span class="ActionScriptDefault_Text">olap</span>.<span class="ActionScriptDefault_Text">OLAPResult</span>; |
| <span class="ActionScriptReserved">import</span> <span class="ActionScriptDefault_Text">mx</span>.<span class="ActionScriptDefault_Text">events</span>.<span class="ActionScriptDefault_Text">CubeEvent</span>; |
| <span class="ActionScriptReserved">import</span> <span class="ActionScriptDefault_Text">mx</span>.<span class="ActionScriptDefault_Text">controls</span>.<span class="ActionScriptDefault_Text">Alert</span>; |
| <span class="ActionScriptReserved">import</span> <span class="ActionScriptDefault_Text">mx</span>.<span class="ActionScriptDefault_Text">collections</span>.<span class="ActionScriptDefault_Text">ArrayCollection</span>; |
| |
| |
| <span class="ActionScriptComment">// |
| </span> <span class="ActionScriptComment">// Format of Objects in the ArrayCollection: |
| </span> <span class="ActionScriptComment">// |
| </span> <span class="ActionScriptComment">// data:Object = { |
| </span> <span class="ActionScriptComment">// customer:"AAA", |
| </span> <span class="ActionScriptComment">// product:"ColdFusion", |
| </span> <span class="ActionScriptComment">// quarter:"Q1" |
| </span> <span class="ActionScriptComment">// revenue: "100.00" |
| </span> <span class="ActionScriptComment">// } |
| </span> <span class="ActionScriptComment">// |
| </span> |
| <span class="ActionScriptBracket/Brace">[</span><span class="ActionScriptMetadata">Bindable</span><span class="ActionScriptBracket/Brace">]</span> |
| <span class="ActionScriptReserved">private</span> <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">flatData</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">ArrayCollection</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptReserved">new</span> <span class="ActionScriptDefault_Text">ArrayCollection</span><span class="ActionScriptBracket/Brace">(</span> |
| <span class="ActionScriptBracket/Brace">[</span> |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"ColdFusion"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q1"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>210, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>25<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flex"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q2"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>210, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>25<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Dreamweaver"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q3"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>250, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>125<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flash"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q4"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>430, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>75<span class="ActionScriptBracket/Brace">}</span>, |
| |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"ColdFusion"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q2"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>125, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>20<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flex"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q3"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>210, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>20<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Dreamweaver"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q4"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>320, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>120<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flash"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q1"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>280, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>70<span class="ActionScriptBracket/Brace">}</span>, |
| |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"ColdFusion"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q3"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>375, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>120<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flex"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q4"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>430, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>120<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Dreamweaver"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q1"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>470, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>220<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flash"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q2"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>570, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>170<span class="ActionScriptBracket/Brace">}</span>, |
| |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"ColdFusion"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q4"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>215, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>90<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flex"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q1"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>210, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>90<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Dreamweaver"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q2"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>175, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>190<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flash"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q3"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>670, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>75<span class="ActionScriptBracket/Brace">}</span>, |
| |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"ColdFusion"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q1"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>175, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>20<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flex"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q2"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>210, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>20<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Dreamweaver"</span>,<span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q3"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>120, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>120<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flash"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q4"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>310, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>70<span class="ActionScriptBracket/Brace">}</span>, |
| |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"ColdFusion"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q1"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>385, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>120<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flex"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q2"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>340, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>120<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Dreamweaver"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q3"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>470, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>220<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flash"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q4"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>270, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>170<span class="ActionScriptBracket/Brace">}</span>, |
| |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"ColdFusion"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q1"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>100, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>25<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flex"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q2"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>150, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>25<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Dreamweaver"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q3"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>200, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>125<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flash"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q4"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>300, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>75<span class="ActionScriptBracket/Brace">}</span>, |
| |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"ColdFusion"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q2"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>175, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>20<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flex"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q3"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>100, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>20<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Dreamweaver"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q4"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>270, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>120<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flash"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q1"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>370, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>70<span class="ActionScriptBracket/Brace">}</span>, |
| |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"ColdFusion"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q3"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>410, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>120<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flex"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q4"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>300, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>320<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Dreamweaver"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q1"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>510, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>220<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flash"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q2"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>620, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>170<span class="ActionScriptBracket/Brace">}</span>, |
| |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"ColdFusion"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q4"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>215, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>90<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flex"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q1"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>210, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>90<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Dreamweaver"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q2"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>175, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>190<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"AAA"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flash"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q3"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>420, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>75<span class="ActionScriptBracket/Brace">}</span>, |
| |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"ColdFusion"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q1"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>240, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>20<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flex"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q2"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>100, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>20<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Dreamweaver"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q3"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>270, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>120<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"BBB"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flash"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q4"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>370, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>70<span class="ActionScriptBracket/Brace">}</span>, |
| |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"ColdFusion"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q1"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>375, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>120<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flex"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q2"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>420, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>120<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Dreamweaver"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q3"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>680, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>220<span class="ActionScriptBracket/Brace">}</span>, |
| <span class="ActionScriptBracket/Brace">{</span><span class="ActionScriptDefault_Text">customer</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"CCC"</span>, <span class="ActionScriptDefault_Text">product</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Flash"</span>, <span class="ActionScriptDefault_Text">quarter</span><span class="ActionScriptOperator">:</span><span class="ActionScriptString">"Q4"</span>, <span class="ActionScriptDefault_Text">revenue</span><span class="ActionScriptOperator">:</span>570, <span class="ActionScriptDefault_Text">cost</span><span class="ActionScriptOperator">:</span>170<span class="ActionScriptBracket/Brace">}</span> |
| <span class="ActionScriptBracket/Brace">])</span>; |
| |
| <span class="ActionScriptReserved">private</span> <span class="ActionScriptfunction">function</span> <span class="ActionScriptDefault_Text">creationCompleteHandler</span><span class="ActionScriptBracket/Brace">()</span><span class="ActionScriptOperator">:</span><span class="ActionScriptReserved">void</span> <span class="ActionScriptBracket/Brace">{</span> |
| <span class="ActionScriptComment">// You must initialize the cube before you |
| </span> <span class="ActionScriptComment">// can execute a query on it. |
| </span> <span class="ActionScriptDefault_Text">myMXMLCube</span>.<span class="ActionScriptDefault_Text">refresh</span><span class="ActionScriptBracket/Brace">()</span>; |
| <span class="ActionScriptBracket/Brace">}</span> |
| |
| <span class="ActionScriptComment">// Create the OLAP query. |
| </span> <span class="ActionScriptReserved">private</span> <span class="ActionScriptfunction">function</span> <span class="ActionScriptDefault_Text">getQuery</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">cube</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">IOLAPCube</span><span class="ActionScriptBracket/Brace">)</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">IOLAPQuery</span> <span class="ActionScriptBracket/Brace">{</span> |
| <span class="ActionScriptComment">// Create an instance of OLAPQuery to represent the query. |
| </span> <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">query</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">OLAPQuery</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptReserved">new</span> <span class="ActionScriptDefault_Text">OLAPQuery</span>; |
| |
| <span class="ActionScriptComment">// Get the row axis from the query instance. |
| </span> <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">rowQueryAxis</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">IOLAPQueryAxis</span> <span class="ActionScriptOperator">=</span> |
| <span class="ActionScriptDefault_Text">query</span>.<span class="ActionScriptDefault_Text">getAxis</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">OLAPQuery</span>.<span class="ActionScriptDefault_Text">ROW_AXIS</span><span class="ActionScriptBracket/Brace">)</span>; |
| <span class="ActionScriptComment">// Create an OLAPSet instance to configure the axis. |
| </span> <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">productSet</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">OLAPSet</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptReserved">new</span> <span class="ActionScriptDefault_Text">OLAPSet</span>; |
| <span class="ActionScriptComment">// Add the Product to the row to aggregate data |
| </span> <span class="ActionScriptComment">// by the Product dimension. |
| </span> <span class="ActionScriptDefault_Text">productSet</span>.<span class="ActionScriptDefault_Text">addElements</span><span class="ActionScriptBracket/Brace">(</span> |
| <span class="ActionScriptDefault_Text">cube</span>.<span class="ActionScriptDefault_Text">findDimension</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptString">"ProductDim"</span><span class="ActionScriptBracket/Brace">)</span>.<span class="ActionScriptDefault_Text">findAttribute</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptString">"Product"</span><span class="ActionScriptBracket/Brace">)</span>.<span class="ActionScriptDefault_Text">children</span><span class="ActionScriptBracket/Brace">)</span>; |
| <span class="ActionScriptComment">// Add the OLAPSet instance to the axis. |
| </span> <span class="ActionScriptDefault_Text">rowQueryAxis</span>.<span class="ActionScriptDefault_Text">addSet</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">productSet</span><span class="ActionScriptBracket/Brace">)</span>; |
| |
| <span class="ActionScriptComment">// Get the column axis from the query instance, and configure it |
| </span> <span class="ActionScriptComment">// to aggregate the columns by the Quarter dimension. |
| </span> <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">colQueryAxis</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">IOLAPQueryAxis</span> <span class="ActionScriptOperator">=</span> |
| <span class="ActionScriptDefault_Text">query</span>.<span class="ActionScriptDefault_Text">getAxis</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">OLAPQuery</span>.<span class="ActionScriptDefault_Text">COLUMN_AXIS</span><span class="ActionScriptBracket/Brace">)</span>; |
| <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">quarterSet</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">OLAPSet</span><span class="ActionScriptOperator">=</span> <span class="ActionScriptReserved">new</span> <span class="ActionScriptDefault_Text">OLAPSet</span>; |
| <span class="ActionScriptDefault_Text">quarterSet</span>.<span class="ActionScriptDefault_Text">addElements</span><span class="ActionScriptBracket/Brace">(</span> |
| <span class="ActionScriptDefault_Text">cube</span>.<span class="ActionScriptDefault_Text">findDimension</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptString">"QuarterDim"</span><span class="ActionScriptBracket/Brace">)</span>.<span class="ActionScriptDefault_Text">findAttribute</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptString">"Quarter"</span><span class="ActionScriptBracket/Brace">)</span>.<span class="ActionScriptDefault_Text">children</span><span class="ActionScriptBracket/Brace">)</span>; |
| <span class="ActionScriptDefault_Text">colQueryAxis</span>.<span class="ActionScriptDefault_Text">addSet</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">quarterSet</span><span class="ActionScriptBracket/Brace">)</span>; |
| |
| <span class="ActionScriptReserved">return</span> <span class="ActionScriptDefault_Text">query</span>; |
| <span class="ActionScriptBracket/Brace">}</span> |
| |
| <span class="ActionScriptComment">// Event handler to execute the OLAP query |
| </span> <span class="ActionScriptComment">// after the cube completes initialization. |
| </span> <span class="ActionScriptReserved">private</span> <span class="ActionScriptfunction">function</span> <span class="ActionScriptDefault_Text">runQuery</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">event</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">CubeEvent</span><span class="ActionScriptBracket/Brace">)</span><span class="ActionScriptOperator">:</span><span class="ActionScriptReserved">void</span> <span class="ActionScriptBracket/Brace">{</span> |
| <span class="ActionScriptComment">// Get cube. |
| </span> <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">cube</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">IOLAPCube</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">IOLAPCube</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">event</span>.<span class="ActionScriptDefault_Text">currentTarget</span><span class="ActionScriptBracket/Brace">)</span>; |
| <span class="ActionScriptComment">// Create a query instance. |
| </span> <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">query</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">IOLAPQuery</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">getQuery</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">cube</span><span class="ActionScriptBracket/Brace">)</span>; |
| <span class="ActionScriptComment">// Execute the query. |
| </span> <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">token</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">AsyncToken</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">cube</span>.<span class="ActionScriptDefault_Text">execute</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">query</span><span class="ActionScriptBracket/Brace">)</span>; |
| <span class="ActionScriptComment">// Setup handlers for the query results. |
| </span> <span class="ActionScriptDefault_Text">token</span>.<span class="ActionScriptDefault_Text">addResponder</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptReserved">new</span> <span class="ActionScriptDefault_Text">AsyncResponder</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">showResult</span>, <span class="ActionScriptDefault_Text">showFault</span><span class="ActionScriptBracket/Brace">))</span>; |
| <span class="ActionScriptBracket/Brace">}</span> |
| |
| <span class="ActionScriptComment">// Handle a query fault. |
| </span> <span class="ActionScriptReserved">private</span> <span class="ActionScriptfunction">function</span> <span class="ActionScriptDefault_Text">showFault</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">result</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">Object</span>, <span class="ActionScriptDefault_Text">token</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">Object</span><span class="ActionScriptBracket/Brace">)</span><span class="ActionScriptOperator">:</span><span class="ActionScriptReserved">void</span> <span class="ActionScriptBracket/Brace">{</span> |
| <span class="ActionScriptDefault_Text">Alert</span>.<span class="ActionScriptDefault_Text">show</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptString">"Error in query."</span><span class="ActionScriptBracket/Brace">)</span>; |
| <span class="ActionScriptBracket/Brace">}</span> |
| |
| <span class="ActionScriptComment">// Handle a successful query by passing the query results to |
| </span> <span class="ActionScriptComment">// the OLAPDataGrid control.. |
| </span> <span class="ActionScriptReserved">private</span> <span class="ActionScriptfunction">function</span> <span class="ActionScriptDefault_Text">showResult</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">result</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">Object</span>, <span class="ActionScriptDefault_Text">token</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">Object</span><span class="ActionScriptBracket/Brace">)</span><span class="ActionScriptOperator">:</span><span class="ActionScriptReserved">void</span> <span class="ActionScriptBracket/Brace">{</span> |
| <span class="ActionScriptReserved">if</span> <span class="ActionScriptBracket/Brace">(!</span><span class="ActionScriptDefault_Text">result</span><span class="ActionScriptBracket/Brace">)</span> <span class="ActionScriptBracket/Brace">{</span> |
| <span class="ActionScriptDefault_Text">Alert</span>.<span class="ActionScriptDefault_Text">show</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptString">"No results from query."</span><span class="ActionScriptBracket/Brace">)</span>; |
| <span class="ActionScriptReserved">return</span>; |
| <span class="ActionScriptBracket/Brace">}</span> |
| <span class="ActionScriptDefault_Text">myOLAPDG</span>.<span class="ActionScriptDefault_Text">dataProvider</span><span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">result</span> <span class="ActionScriptReserved">as</span> <span class="ActionScriptDefault_Text">OLAPResult</span>; |
| <span class="ActionScriptBracket/Brace">}</span> |
| <span class="ActionScriptBracket/Brace">]]</span><span class="ActionScriptOperator">></span> |
| <span class="MXMLSpecial_Tag"></mx:Script></span> |
| |
| <span class="MXMLComponent_Tag"><mx:OLAPCube</span><span class="MXMLDefault_Text"> name="</span><span class="MXMLString">FlatSchemaCube</span><span class="MXMLDefault_Text">" dataProvider="</span><span class="MXMLString">{</span><span class="ActionScriptDefault_Text">flatData</span><span class="MXMLString">}</span><span class="MXMLDefault_Text">" id="</span><span class="MXMLString">myMXMLCube</span><span class="MXMLDefault_Text">" complete="</span><span class="ActionScriptDefault_Text">runQuery</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">event</span><span class="ActionScriptBracket/Brace">)</span>;<span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">></span> |
| |
| <span class="MXMLComponent_Tag"><mx:OLAPDimension</span><span class="MXMLDefault_Text"> name="</span><span class="MXMLString">CustomerDim</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">></span> |
| <span class="MXMLComponent_Tag"><mx:OLAPAttribute</span><span class="MXMLDefault_Text"> name="</span><span class="MXMLString">Customer</span><span class="MXMLDefault_Text">" dataField="</span><span class="MXMLString">customer</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">/></span> |
| <span class="MXMLComponent_Tag"><mx:OLAPHierarchy</span><span class="MXMLDefault_Text"> name="</span><span class="MXMLString">CustomerHier</span><span class="MXMLDefault_Text">" hasAll="</span><span class="MXMLString">true</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">></span> |
| <span class="MXMLComponent_Tag"><mx:OLAPLevel</span><span class="MXMLDefault_Text"> attributeName="</span><span class="MXMLString">Customer</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">/></span> |
| <span class="MXMLComponent_Tag"></mx:OLAPHierarchy></span> |
| <span class="MXMLComponent_Tag"></mx:OLAPDimension></span> |
| |
| <span class="MXMLComponent_Tag"><mx:OLAPDimension</span><span class="MXMLDefault_Text"> name="</span><span class="MXMLString">ProductDim</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">></span> |
| <span class="MXMLComponent_Tag"><mx:OLAPAttribute</span><span class="MXMLDefault_Text"> name="</span><span class="MXMLString">Product</span><span class="MXMLDefault_Text">" dataField="</span><span class="MXMLString">product</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">/></span> |
| <span class="MXMLComponent_Tag"><mx:OLAPHierarchy</span><span class="MXMLDefault_Text"> name="</span><span class="MXMLString">ProductHier</span><span class="MXMLDefault_Text">" hasAll="</span><span class="MXMLString">true</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">></span> |
| <span class="MXMLComponent_Tag"><mx:OLAPLevel</span><span class="MXMLDefault_Text"> attributeName="</span><span class="MXMLString">Product</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">/></span> |
| <span class="MXMLComponent_Tag"></mx:OLAPHierarchy></span> |
| <span class="MXMLComponent_Tag"></mx:OLAPDimension></span> |
| |
| <span class="MXMLComponent_Tag"><mx:OLAPDimension</span><span class="MXMLDefault_Text"> name="</span><span class="MXMLString">QuarterDim</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">></span> |
| <span class="MXMLComponent_Tag"><mx:OLAPAttribute</span><span class="MXMLDefault_Text"> name="</span><span class="MXMLString">Quarter</span><span class="MXMLDefault_Text">" dataField="</span><span class="MXMLString">quarter</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">/></span> |
| <span class="MXMLComponent_Tag"><mx:OLAPHierarchy</span><span class="MXMLDefault_Text"> name="</span><span class="MXMLString">QuarterHier</span><span class="MXMLDefault_Text">" hasAll="</span><span class="MXMLString">true</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">></span> |
| <span class="MXMLComponent_Tag"><mx:OLAPLevel</span><span class="MXMLDefault_Text"> attributeName="</span><span class="MXMLString">Quarter</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">/></span> |
| <span class="MXMLComponent_Tag"></mx:OLAPHierarchy></span> |
| <span class="MXMLComponent_Tag"></mx:OLAPDimension></span> |
| |
| <span class="MXMLComponent_Tag"><mx:OLAPMeasure</span><span class="MXMLDefault_Text"> name="</span><span class="MXMLString">Revenue</span><span class="MXMLDefault_Text">" |
| dataField="</span><span class="MXMLString">revenue</span><span class="MXMLDefault_Text">" |
| aggregator="</span><span class="MXMLString">SUM</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">/></span> |
| <span class="MXMLComponent_Tag"></mx:OLAPCube></span> |
| |
| <span class="MXMLComponent_Tag"><mx:Panel</span><span class="MXMLDefault_Text"> title="</span><span class="MXMLString">OLAPDataGrid Control</span><span class="MXMLDefault_Text">" layout="</span><span class="MXMLString">vertical</span><span class="MXMLDefault_Text">" color="</span><span class="MXMLString">0xffffff</span><span class="MXMLDefault_Text">" borderAlpha="</span><span class="MXMLString">0.15</span><span class="MXMLDefault_Text">" width="</span><span class="MXMLString">500</span><span class="MXMLDefault_Text">" |
| paddingTop="</span><span class="MXMLString">5</span><span class="MXMLDefault_Text">" paddingRight="</span><span class="MXMLString">10</span><span class="MXMLDefault_Text">" paddingBottom="</span><span class="MXMLString">10</span><span class="MXMLDefault_Text">" paddingLeft="</span><span class="MXMLString">10</span><span class="MXMLDefault_Text">" horizontalAlign="</span><span class="MXMLString">center</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">></span> |
| |
| <span class="MXMLComponent_Tag"><mx:OLAPDataGrid</span><span class="MXMLDefault_Text"> id="</span><span class="MXMLString">myOLAPDG</span><span class="MXMLDefault_Text">" color="</span><span class="MXMLString">0x323232</span><span class="MXMLDefault_Text">" width="</span><span class="MXMLString">100%</span><span class="MXMLDefault_Text">" height="</span><span class="MXMLString">100%</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">/></span> |
| |
| <span class="MXMLComponent_Tag"></mx:Panel></span> |
| <span class="MXMLComponent_Tag"></mx:Application></span></pre></body> |
| </html> |