(Hopefully this will make sense...)
I'm using the OLAPDataGrid to display metrics for selected products over time.
I can get the time dimension working properly, but I want the rows to have
metric then the product beneath that. Something like:
SALES
-> Product A - Value, Value, etc.
-> Product B - Value, Value, etc.
on the rows. But instead I get :
(All)
Product A - SUM
Product B - SUM
SALES (no header text) Value, Value
SALES (no header text) Value, Value
Strangely enough all of the numbers are correct, but I lose the row header for
Product (where I have "no header text".
My OLAPASchema looks like:
<mx:OLAPCube id="cubeResults" complete="cubeCompleteHandler(event);" >
<mx:OLAPDimension name="TimeDim">
<mx:OLAPAttribute name="Timeline" dataField="Timeline"/>
</mx:OLAPDimension>
<mx:OLAPDimension name="MetricDim">
<mx:OLAPAttribute name="Metric" dataField="MetricType"/>
<mx:OLAPAttribute name="Product" dataField="ProductName" />
<mx:OLAPHierarchy name="Metric-Product" hasAll="true">
<mx:OLAPLevel attributeName="Metric"/>
<mx:OLAPLevel attributeName="Product"/>
</mx:OLAPHierarchy>
</mx:OLAPDimension>
<mx:OLAPMeasure name="Units"
dataField="MetricValue"/>
And then on the data result I do :
<--SNIPPET -->
metricSet.addElements(
cube.findDimension("MetricDim").findAttribute("Metric").children);
typeSet.addElements(cube.findDimension("MetricDim").findAttribute("Product").members);
rowQueryAxis.addSet(typeSet);
rowQueryAxis.addSet(metricSet.crossJoin(typeSet));
<-- END SNIPPET -->
Does anyone have insight into how to get the hierarchy to display properly?
