mdx query problem of with member

[alvin1_huang]

Hi all,

 

When i execute the following mdx query, i will get "Mondrian Error:MDX object '[service Type].[RANGE]' not found in cube 'TATHit'". anything wrong with that?

Thanks.

 

=====================================================

with member [service Type].[RANGE]

as 'aggregate {[service Type].[REPAIR], [service Type].[sWAP]})'

select NON EMPTY drilldownlevel({[Product Type].[All

Product Types]}) on columns

from [TATHit]

where [service Type].[RANGE]

=====================================================

 

Br,

Alvin

[biaggi]

I recommend u to attach the cube definition.

 

Best Reggards :)