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.