Hi,

I normally create the local cube using the MDX Sample
Application from the Analysis Services. The DDL statement
is something like this.

CREATE GLOBAL CUBE [CTVLocal] STORAGE 'c:\\CTVFDP.cub'
FROM [CTV]
(
MEASURE [CTV].[Sales Units],
MEASURE [CTV].[Sales Value],
MEASURE [CTV].[Value in USD],
DIMENSION [CTV].[Brands],
..
..
..

Recently, I have added an additional dimension in this
cube. I want to filter out some irelevant members. Hence,
I write the following

DIMENSION [CTV].[Grouped Screen Size]
(
LEVEL [(All)],
LEVEL [Screen Size Group],
MEMBER [Screen Size Group].[All Grouped Screen
Size].[> 34"],
MEMBER [Screen Size Group].[All Grouped Screen
Size].[11"-19"],
MEMBER [Screen Size Group].[All Grouped Screen
Size].[20"-25"],

However, there is an formula error here. The error msg is

"unable to open cellset. Formula error - invalid
references, the member MEMBER [Screen Size Group].[All
Grouped Screen Size].[> 34"] does not exist. In fact, all
the different grouped screen size are in the database and
cube.

Can someone advise. Thank you very much.