why olapdatagrid always show only one olapmeasure?

[geroge77]

I have defined two olapmeasures in olapcube,
but the olapdatagrid always shows the first defined olapmeasure,and the second measure don't show.
anyone has a solution?
thanks

[geroge77]

no answer?

[Cosma]

On 16 Apr, 02:28, "geroge77" <webforumsu...@macromedia.com> wrote:

> no answer?

Same question here..

[sylvain.postolec@gmail.com]

How do you define your ColAxis ?

Get the source from this sample :
[url]http://flexpearls.blogspot.com/2008/04/custom-aggregator-sample-for-flex-olap.html[/url]

In this sample there are two different measures.

[sylvain.postolec@gmail.com]

How do you define your ColAxis ?

Get the source from this sample :
[url]http://flexpearls.blogspot.com/2008/04/custom-aggregator-sample-for-flex-olap.html[/url]

In this sample there are two different measures.

[Sreenivas R]

The first measure is by default included in the query results.

If you want to display multiple measures you need to include the required
measures either in the column axis or the row axis of the query.

[RJRoman]

Try creating a separate OLAPSet for metrics

var metricSet:OLAPSet= new OLAPSet;
metricSet.addElement(cube.findDimension("Measures" ).findMember("Revenue"));
metricSet.addElement(cube.findDimension("Measures" ).findMember("Cost"));

add metricSet as crossjoin to the column query axis:

var colQueryAxis:IOLAPQueryAxis = query.getAxis(OLAPQuery.COLUMN_AXIS);
colQueryAxis.addSet(customerSet.crossJoin(metricSe t));

Here, customerSet is
var customerSet:OLAPSet = new OLAPSet;
customerSet.addElements(cube.findDimension("Custom erDim").findAttribute("Customer").children);



OLAPCube itself looks like this

<mx:OLAPCube name="FlatSchemaCube"
dataProvider="{flatData}"
id="myMXMLCube"
complete="runQuery(event);">

<mx:OLAPDimension name="CustomerDim">
<mx:OLAPAttribute name="Customer" dataField="customer"/>
<mx:OLAPHierarchy name="CustomerHier" hasAll="true">
<mx:OLAPLevel attributeName="Customer"/>
</mx:OLAPHierarchy>
</mx:OLAPDimension>

<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="QuarterDim">
<mx:OLAPAttribute name="Quarter" dataField="quarter"/>
<mx:OLAPHierarchy name="QuarterHier" hasAll="true">
<mx:OLAPLevel attributeName="Quarter"/>
</mx:OLAPHierarchy>
</mx:OLAPDimension>

<mx:OLAPDimension name="ZIPCodeDim">
<mx:OLAPAttribute name="ZIPCode" dataField="zip"/>
<mx:OLAPHierarchy name="ZIPCodeHier" hasAll="true">
<mx:OLAPLevel attributeName="ZIPCode"/>
</mx:OLAPHierarchy>
</mx:OLAPDimension>

<mx:OLAPMeasure name="Revenue"
dataField="revenue"
aggregator="SUM"/>
<mx:OLAPMeasure name="Cost"
dataField="cost"
aggregator="SUM"/>
</mx:OLAPCube>