[Mondrian] MDX query question

[Yiguang Hu]

I have a MDX query as the following. It works fine if
the database has all the data. 
But problem happens when the database get updated and
some data does not exist such as if "Grade" "1008"
does not exist in the table. Error msg showing sth
like "cube does not have data ...". I do not want to
change the MDX query every time when db is updated. Is
there any way that I can parse the mdx query that can
clean the non-existing columns and either return me
the cleaned mdx or just go ahead process and ignore
the non-existing columns?

Thanks

 <jp:mondrianQuery id="query01"
queryName="samplequery"
jdbcDriver="com.mysql.jdbc.Driver"
jdbcUrl="<%=JDBCURL%>"
                     
catalogUri="/WEB-INF/queries/mycubes.xml"
role="<%=role%>">
        <%=qry%>
    </jp:mondrianQuery>


select NON EMPTY {[Measures].[Stats Weight)]} ON
COLUMNS, NON EMPTY Crossjoin({[Grade].[All
Grades].[100], [Grade].[All Grades].[1008],
[Grade].[All Grades].[101]}, Crossjoin({[Spec].[All
Specs].[1547-M3602], [Spec].[All Specs].[1547-M3606]},
{[Form].[All Forms].[Hex], [Form].[All
Forms].[Rectangle], [Form].[All Forms].[Round]})) ON
ROWS
from [mycube] where ([Partner].[All Partner],
[Grade].[All Grade], [Vendor].[All Vendors])



      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ