How to hide #null from Analysis View

[marasheed]

 Hi,

I'm using JasperServer 4.0 community edition. 

I have generated warehouse using JasperETL.

I have a column meal period which contains (NULL) when the location does not associated with any meal period.

Attached is the output screenshot (AnalysisViewOutput.jpg).

 

Following is my mdx query.

select {({[Measures].[Product Sales]} * [item].[item Type].Members)} ON COLUMNS,

  Hierarchize([Location].[Meal Period].Members) ON ROWS

from [sales]

 

 

In my mind there are two alternates.

1- In the database column for non existing values instead of (NULL) generate empty string ''. I checked and this resolves my issue.

2- May be some filter define in mondrain schema using JasperAnalysis Schema WorkBench or some expression in MDX query to show blank space instead of #null.

Looking for your feedback.

Regards

M. Abdur Rasheed

[marasheed]

In JasperServer OLAP Settings I found
mondrian.olap.NullMemberRepresentation=#null

I have added an entry
mondrian.olap.NullMemberRepresentation=
in mondrian.properties file and now instead of #null it is showing empty space.

It's now resolved.

Post Edited by marasheed at 04/05/2011 20:45