MDX object not found in cube

Question

I have districts with areas. and i'm trying to fetch data from my cube. the problem is:

i add new area to district in database.
the data in cube is recalculated only once a day. so rigth after i have added new area it will be not present in my cube.
and when i try to get info from cube i get the error 'MDX object '[ATD].[Area].&[6007d9a7-a137-4bba-9d72-0020ee5d2db0]' not found in cube' after the cube is recalculated everything is ok.

how can i fight this error?

with member [Measures].[District]   
     member [Measures].[Area]       
     member [Measures].[AreaID]                         
select
                    {
                         [Measures].[District],
                         [Measures].[Area], 
                         [Measures].[AreaID]

                    }  on columns,
                    {
                          {{[MyDimension].[Area].&[6007d9a7-a137-4bba-9d72-0020ee5d2db0]}}
                    } on rows
                    from SomeCube

Thanks in advance.

score 0 · Accepted Answer · answered Aug 30 '12 at 10:00

0

You should set the ignoreInvalidMembers property to true.

You can find more information on Mondrian's configuration page.

answered Aug 30 '12 at 10:00

Benoit

1,995
1
13
18

I use tomcat and I put a mondrian.properties file in bin directory of tomcat but it seems it's not being used. – user1178399 Sep 14 '12 at 17:10
i have solved the problem: just put the file in \mondrian\WEB-INF\classes\ – user1178399 Sep 24 '12 at 16:07

MDX object not found in cube

1 Answers1