套件 | mx.olap |
介面 | public interface IOLAPCube |
實作者 | OLAPCube |
語言版本: | ActionScript 3.0 |
產品版本: | Flex 3 |
執行階段版本: | Flash Player 9, AIR 1.1 |
An OLAP cube is analogous to a table in a relational database. Where a table in a relational database has two dimensions, an OLAP cube can have any number of dimensions. In its simplest form, the dimensions of an OLAP cube correspond to a field of the flat data set.
After setting the schema of the OLAP cube, you must call
the IOLAPCube.refresh()
method to build the cube.
Upon completion of cube initialization, the OLAP cube dispatches
the complete
event to signal that the cube is ready to query.
相關 API 元素
屬性 | 定義自 | ||
---|---|---|---|
dimensions : IList [唯讀]
All dimensions in the cube, as a list of IOLAPDimension instances. | IOLAPCube | ||
name : String [唯讀]
The name of the OLAP cube. | IOLAPCube |
方法 | 定義自 | ||
---|---|---|---|
Aborts a query that has been submitted for execution. | IOLAPCube | ||
Aborts the current cube refresh, if one is executing. | IOLAPCube | ||
Queues an OLAP query for execution. | IOLAPCube | ||
Returns the dimension with the given name within the OLAP cube. | IOLAPCube | ||
Refreshes the cube from the data provider. | IOLAPCube |
dimensions | 屬性 |
name | 屬性 |
cancelQuery | () | 方法 |
public function cancelQuery(query:IOLAPQuery):void
語言版本: | ActionScript 3.0 |
產品版本: | Flex 3 |
執行階段版本: | Flash Player 9, AIR 1.1 |
Aborts a query that has been submitted for execution.
參數
query:IOLAPQuery — The query to abort.
|
cancelRefresh | () | 方法 |
public function cancelRefresh():void
語言版本: | ActionScript 3.0 |
產品版本: | Flex 3 |
執行階段版本: | Flash Player 9, AIR 1.1 |
Aborts the current cube refresh, if one is executing.
execute | () | 方法 |
public function execute(query:IOLAPQuery):mx.rpc:AsyncToken
語言版本: | ActionScript 3.0 |
產品版本: | Flex 3 |
執行階段版本: | Flash Player 9, AIR 1.1 |
Queues an OLAP query for execution.
After you call the refresh()
method to update the cube,
you must wait for a complete
event
before you call the execute()
method.
OLAP cubes can be complex, so you do not want your application
to pause while Flex calculates the results of your OLAP query.
The execute()
method returns an instance of the AsyncToken class,
which lets you set up handlers for asynchronous operations so that
your application can continue to execute during query processing.
When using the AsyncToken class, you set up two functions to handle the query results. In this example, the showResult() function handles the query results when the query succeeds, and the showFault() function handles any errors detected during query execution:
<mx:Script> // Function to execute a query. private function runQuery(cube:IOLAPCube):void { // Create a query instance. var query:IOLAPQuery = getQuery(cube); // Execute the query. var token:AsyncToken = cube.execute(query); // Set up handlers for the query results. token.addResponder(new AsyncResponder(showResult, showFault)); } // Handle a query fault. private function showFault(result:FaultEvent, token:Object):void { Alert.show("Error in query."); } // Handle a query success. private function showResult(result:Object, token:Object):void { if (!result) { Alert.show("No results from query."); return; } myOLAPDG.dataProvider= result as OLAPResult; } </mx:Script> <mx:OLAPDataGrid id="myOLAPDG" width="100%" height="100%" />
參數
query:IOLAPQuery — The query to execute, represented by an IOLAPQuery instance.
|
mx.rpc:AsyncToken — An AsyncToken instance.
|
相關 API 元素
findDimension | () | 方法 |
public function findDimension(name:String):IOLAPDimension
語言版本: | ActionScript 3.0 |
產品版本: | Flex 3 |
執行階段版本: | Flash Player 9, AIR 1.1 |
Returns the dimension with the given name within the OLAP cube.
參數
name:String — The name of the dimension.
|
IOLAPDimension — An IOLAPDimension instance representing the dimension,
or null if a dimension is not found.
|
refresh | () | 方法 |
public function refresh():void
語言版本: | ActionScript 3.0 |
產品版本: | Flex 3 |
執行階段版本: | Flash Player 9, AIR 1.1 |
Refreshes the cube from the data provider. After setting the cube's schema, you must call this method to build the cube.
This method dispatches a progress
event to indicate progress,
and dispatches a complete
event when the cube is complete
and ready to execute queries.
You must wait for a complete
event
before you call the execute()
method to run a query.
相關 API 元素
Tue Jun 12 2018, 03:47 PM Z