Hi,

I have an MS Access table as fact data. Two of the fields
in this table which has to be created as dimensions have
more than 5000 distinct values. I want to create a Local
cube. I dont want to get all those 5000 distinct values
as memebers for those two dimensions into the local cube.
Rather have only the <All> level containing aggregated
value. Is this possible. If yes what is the syntax.

In short - I dont want all the members but only the "All"
level. So that I can minimize the local cube file.

Thanks,
VJ

Hi,

In the DIMENSION clause of the CREATE CUBE statement, the name given to a
level of TYPE ALL applies the specified name to the All member rather than
the (All) level; the (All) level always has the name (All), including the
parentheses. For example, the clause LEVEL [All Customers] TYPE ALL creates
a level named (All) containing a single member named [All Customers]. There
is no [All Customers] level.

You may refer to "A. Defining a Local Cube's Dimensions" in "Using the
CREATE CUBE Statement".
http://msdn.microsoft.com/library/en...clien_2zg4.asp


Bill Cheng
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------