olap view not showing all data

[ddaly]

I have a view that is missing certain pieces of data.

The MDX:

Code:

 

The attached image shows data missing for whse rows T & U.

 

 

I got the SQL query from the mondrian debug log and put the same query into a mysql client:

Code:

 

This shows there should be data for the T and U rows. Why is it not displaying in the olap view? size=280]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/jasperintel.png

Post edited by: Daryl, at: 2006/09/15 15:41

[ddaly]

It turns out that this problem is a case sensitivity issue. It appears that Mondrian is case-sensitive. The data in the mysql database is in non case-sensitive fields. The rows 'T' and 'U' that show no data have values 't' and 'u' respectively in their 'first' data rows in the database fact table. Mondrian seems to get confused at this.

 

My workaround was to make all the data in the fact table have consistent case.