Mapping Fields from a XMLA Datasource

[fbarajas]

I am having trouble mapping a xmla Rows in JasperReports.

I am able to get Measures to output using this syntax Data([Measure].[Rev],?) but when I try to bind the Rows (Axis1) to a field I get this error:

"Could no find dimension "Cities" on axis 1"

I've used the following combinations without success:

Rows[Cities][City]

Data(Rows[Cities][City])

I've also set the Query language to MDX and XMLA/MDX without anyluck.

I am using iReport 3, Jasper Reports 3 and JasperServer 3.

 

Any help would be appreciated.

[fbarajas]

anyone has any input on this? The user manual isn't very clear. This is what it says:

 

 

Mapping report fields to mondrian.olap.Member instances: If a report field member mapping doesn’t specify a dimension level (e.g., Rows[store]), then the Mondrian data source yields the mondrian.olap.Member instance as field value. The report designer would use this object to retrieve additional member information that is not accessible via other mapping conventions.

For XMLA, it is not possible to produce a complete mondrian.olap.Member object, hence this feature is not supported

Post Edited by francisco barajas at 12/24/08 02:03