Home Tutorial Flex Flex4 Components About OLAP Schemas in OLAP DataGrid in Flex4

 
 

Share on Google+Share on Google+
About OLAP Schemas in OLAP DataGrid in Flex4
Posted on: June 18, 2010 at 12:00 AM
Advertisement
OLAP Schema is used for to convert a flat data in to an OLAP cube.

About OLAP Schemas in OLAP DataGrid in Flex4:

OLAP Schema is used for to convert a flat data in to an OLAP cube. You will create OLAP schema which is used for defines the dimensions of the cube. The fields of the flat data that supply the members along each dimensions and the measure for any point in the cube. we have the following flat data:

value:Object = {
product:"monitor"
month :"Jan"
price: "7000",
}

The general form of OLAP schema are following:

<fx:Declarations>

<mx:OLAPCube name="Managesale"

dataProvider="{flatData}"

id="olapCube"

complete="runQuery(event);">

<!-- Define dimensions. -->

<mx:OLAPDimension ... />

.

.

.

<mx:OLAPDimension ... />

...

<!-- Define measures. -->

<mx:OLAPMeasure ... />

...

</mx:OLAPCube>

</fx:Declarations>

The general form of OLAP dimensions are following:

<mx:OLAPDimension name="MonthDim">

<mx:OLAPAttribute name="Month" dataField="Month"/>

...

<mx:OLAPHierarchy name="MonthHier" hasAll="true">

<mx:OLAPLevel attributeName="Month"/>

...

</mx:OLAPHierarchy>

</mx:OLAPDimension>

The OLAP schema according the above flat data are following:

<mx:OLAPCube name="Managesale"

dataProvider="{flatData}"

id="olapCube"

complete="runQuery(event);">

<mx:OLAPDimension name="ProductDim">

<mx:OLAPAttribute name="Product" dataField="product"/>

<mx:OLAPHierarchy name="ProductHier" hasAll="true">

<mx:OLAPLevel attributeName="Product"/>

</mx:OLAPHierarchy>

</mx:OLAPDimension>

<mx:OLAPDimension name="MonthDim">

<mx:OLAPAttribute name="Month" dataField="Month"/>

<mx:OLAPHierarchy name="MonthHier" hasAll="true">

<mx:OLAPLevel attributeName="Month"/>

</mx:OLAPHierarchy>

</mx:OLAPDimension>

<mx:OLAPDimension name="PriceDim">

<mx:OLAPAttribute name="Price" dataField="Price"/>

<mx:OLAPHierarchy name="PriceHier" hasAll="true">

<mx:OLAPLevel attributeName="Price"/>

</mx:OLAPHierarchy>

</mx:OLAPDimension>

<mx:OLAPMeasure name="TOtal"

dataField="total"/>

</mx:OLAPCube>

 

Advertisement

Related Tags for About OLAP Schemas in OLAP DataGrid in Flex4:


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: June 18, 2010

Recommend the tutorial

Advertisements Advertisements
 

 

 

DMCA.com