The summary of the issue I have, which I can't find any answers so far is:
1. The list reports works fine with automatic summary.
2. The Crosstab works ok without automatic summary by Location.
3. It will get java.lang.NullPointerException once automatic summary is added into the Crosstab report.
The results of the Crosstab without automatic summary has been attached.
Does anyone experience this before?
Got some model information:
Measure A is from Fact table A and Measure B is from Fact table B. The location is a common dimension table.
Please let me know if you need more information.
How many queries do you have in the report? I have experienced this with multiple queries...
Only one query.
BTW, Comments from my user: it works fine in Excel.
BTW, I think the model is somewhat like the one in this example:
http://www.ibm.com/support/knowledgecenter/SSEP7J_10.1.0/com.ibm.swg.im.cognos.ug_fm.10.1.0.doc/ug_fm_id21013multi-factmulti-grainquery.html (http://www.ibm.com/support/knowledgecenter/SSEP7J_10.1.0/com.ibm.swg.im.cognos.ug_fm.10.1.0.doc/ug_fm_id21013multi-factmulti-grainquery.html)