Hi, I am trying to create a local cube for our sales team from an
existing sales sample cube we have on one of our web servers. Here's
one of the many many versions of the DDL statements I have tried. I
have attempted numerous MDX statements as well but not being overly
familiar with it's syntax yet I have leaned more towards the DDL
language for it's simplicity.

CREATE GLOBAL CUBE VendorDetail
STORAGE 'c:/VendorDetail.cub'
FROM [Vendor Detail]
(MEASURE [Vendor Detail].[Scan Units],
DIMENSION [Vendor Detail].[Vendor])

When run it errors saying; "Unable to open cellset Formula error -
invalid reference - the dimension "Vendor" does not exist." The funny
part is the vendor dimension does exist. When the OLAP cube is viewed
via analysis services it views the vendor dimension without errors,
however, it appears to be a hierarchical entity. An example for one of
our accounts ( customer # 665 ) the vendor dimension shows as
"Vendor.Number 665". I have tried numerous syntactical approaches due
to this like, "DIMENSION [Vendor Detail].[Vendor].[Number
665].[Vendor])" but this gives me an invalid parsing entity error on
that line.

Thank you to anyone who can point me to my error.
Rick

Hello Rick,

take a look at www.localcubetask.com

there is help

hth jörg