Problem accessing a measure, possible bug

kevinroll

I'm having a problem accessing a measure within a cross tab. Please see the attached sample report which uses the default dataset. Note that there is a defined column called INDEX which is simply a running count of the rows. This column is included in the Data Cube as one of the measures. Now note that in the Cross Tab, on the cell for the PRODUCTDESCRIPTION detail, there is some JavaScript:

this.setDisplayValue(measure["INDEX"])

The intention in our production report is to override the output based on some criteria in one of the measures, but this serves to illustrate the issue. When the report is run the following exception occurs:

java.lang.RuntimeException: org.eclipse.birt.data.engine.core.DataException: Cannot find measure "{0}" definition in cube, the measure does not exist or is invalid.
at org.eclipse.birt.data.engine.olap.script.JSMeasureAccessor.get(JSMeasureAccessor.java:67)

For starters this exception is incomplete - the parameter in the error string has not been filled in. I thought that perhaps the fact that the original source column is computed might be relevant, but in our production report using a non-computed column also produces this error. I can't figure out what the specific criteria is that causes the problem. Thoughts?

P.S. BIRT 2.3.2.

mwilliams

kevinroll,

The reason it doesn't work is because without "INDEX" being a part of the crosstab, the INDEX value doesn't get figured for the cube. If you put measure["INDEX"] into the crosstab like the other two measures and leave the same script in, it works.