Calculated members

[Luben Manolov]

Hi guys,

I have a cube with some calculated members but cannot see them in
Halogen under the Measures dimension. Here is the relevant excerpt
from my mondrian schema xml:

<Measure name="Subunits" column="SUBUNIT_QUANTITY"
datatype="Numeric" formatString="#,##0" aggregator="sum" />
<Measure name="Capacity" column="PRODUCT_CAPACITY"
datatype="Numeric" formatString="#,##0" aggregator="sum" />
<Measure name="Price" column="Price" datatype="Numeric"
formatString="#,##0" aggregator="sum" />
<CalculatedMember name="Vend Cases" dimension="Measures"
formula="[Measures].[Subunits] / 24">
<CalculatedMemberProperty name="FORMAT_STRING" value="#,##0"/>
</CalculatedMember>

In Halogen I can see only the "Capacity" and "Price" measures. If I
change line 261 of Olap4JServiceImpl.java from:

for(int i=1; i<uniqueNameList.size(); i++)

to:

for(int i=0; i<uniqueNameList.size(); i++)

I can see the 3 measures "Subunits", "Capacity" and "Price", but the
calculated member "Vend Cases" is still not shown.

Best regards,

Luben

[william...@gmail.com]

I'll open a case on it. We haven't done any testing with calculated
members.

[Julian Hyde]

> > I have a cube with some calculated members but cannot see them in
> > Halogen under the Measures dimension.

I think this may be due to the olap4j driver not returning calculated
members. I fixed it recently for both mondrian and XMLA drivers.

Bill, it's still worth checking that calc members work.

Julian

[Luben Manolov]

Hi Julian,

I just tried the latest versions of Olap4J (revision 94 from SVN) and
Halogen (revision 34 from SVN). The mondrian driver still doesn't return
the calculated members. When I switch to the XMLA driver
(org.olap4j.driver.xmla.XmlaOlap4jDriver) the calculated members are
returned and everything seems to be OK.

Best regards,

Luben

[Julian Hyde]

> Luben Manolov wrote:
>
> I just tried the latest versions of Olap4J (revision 94 from SVN) and
> Halogen (revision 34 from SVN). The mondrian driver still
> doesn't return
> the calculated members.

What version of mondrian? (Look at VERSION.txt in mondrian.jar.)

Julian

[Luben Manolov]

>> I just tried the latest versions of Olap4J (revision 94 from SVN) and
>> Halogen (revision 34 from SVN). The mondrian driver still
>> doesn't return
>> the calculated members.
>
> What version of mondrian? (Look at VERSION.txt in mondrian.jar.)

I was using the version of mondrian which is included in halogen -
2.4.2.9831.

After upgrade to version 3.0.3.11016 everything works like a charm with
the mondrian driver - the calculated members are displayed. Thanks!

Best regards,

Luben

[william...@gmail.com]

I upgraded the mondrian and olap4j in the project so you shouldn't
have to do this manually anymore

Bill