Using FLEX3 to develop OLAP applications

Profile

On-Line Analytical processing (Online analytical processing, hereinafter referred to as OLAP) is a fast software technology that shares multidimensional information and online data access and analysis for specific problems. OLAP is designed to support complex analysis operations, focusing on decision support for decision-makers and senior management, and can quickly and flexibly perform complex query processing of large amounts of data according to the requirements of analysts. This article will introduce the use of Flex technology to make these complex query processing results beautiful, easy to display.

Software Environment requirements

Flash Player 9 or later

Adobe Flex SDK 3.0 or later

Adobe Flex SDK Builder 3 or later

Analysis components in Flex

In the traditional OLAP analysis component development, each business intelligence company has its own set of product realization, from the design and use are not open. In the Flex SDK, the native range provides a wide range of analysis components, such as pie, histogram, and other chart controls, and added Olapdatagrid to the Flex3, making it easier to develop OLAP applications based on Flex. In addition, because of the good extensibility of the Flex class library, it makes the development of customization possible and satisfies the wide range of users ' needs in OLAP analysis.

Use of chart controls

There are usually two ways to use components in Flex, one of which is to specify the presentation of this component directly in the class XML tag of the. mxml file, which is the most intuitive way. The other one will display and logically separate, in the. mxml file only declares the component that will be used, while the specific data acquisition process and the data presentation process are implemented programmatically in the corresponding. As (ActionScript). This article will be described in the second way:

First, create a new Olapappinflex Flex application.

Then use the Viewstack component to glue the three chart controls we want to show together, and click on the Viewstack tab to see the different display effects.

Listing 1. Olapappinflex.mxml

<mx:script source= "include/chart.as"/>
......
<mx:viewstack id= "Viewstack" width= "100%" height= "75%" creationcomplete= "ShowData" () >
<mx:hbox id= "Columnbox" name= "Columnchart" width= "100%" >
<mx:columnchart id= "Columnchart" showdatatips= "true" width= "100%" height= "100%"/>
<mx:panel id= "Columnlegendpanel" horizontalscrollpolicy= "Off" >
<mx:box maxheight= "horizontalscrollpolicy=" "Off" >
<mx:legend id= "Columnlegend" width= "100%"/>
</mx:Box>
</mx:Panel>
</mx:HBox>

<mx:hbox id= "Piebox" name= "Piechart" width= "100%" >
</mx:HBox>

<mx:hbox id= "Linebox" name= "Linechart" width= "100%" >
<mx:linechart id= "Linechart" showdatatips= "true" width= "100%" height= "100%"/>
<mx:panel id= "Linelegendpanel" horizontalscrollpolicy= "Off" >
<mx:box maxheight= "horizontalscrollpolicy=" "Off" >
<mx:legend id= "Linelegend" width= "100%"/>
</mx:Box>
</mx:Panel>
</mx:HBox>
</mx:ViewStack>

The first line in the above code introduces chart.as and implements the graphical presentation logic in this file.

And before introducing chart.as how to implement the graph's presentation logic, we introduce two general questions first: