tags:

views:

213

answers:

0

Hi folks, i want to know if is it possible to avoid mondrian´s fatal error when it doesn't have any member in defined cube. for instance i have this MDX Query

select {[Measures].[Unit_Sales], [Measures].[Quantity], [Measures].[Total]} ON COLUMNS, Hierarchize({([Country.CountryHeirarchy].[All Countries].[USA], [Products.ProductHeirarchy].[All Products])}) ON ROWS from [SALES]

and lets say, the DataBase doesn't have the USA member, i want to get a zero(0) or null value. is it possible to do that on mondrian.

i have been trying with this property in mondrian.property file

mondrian.rolap.ignoreInvalidMembersDuringQuery=true

but not lucky still now.

Thanks in advance.