Hi,
Can ANYONE provide a create global cube statement that works against
adventure works in SQL 2005?

Trying to get this working is driving me insane!!!

Cheers,
Peter

yes peter , simply connect to AS2005 using excel and choose create offline
cube then select the dims and the measures and choose a place to save to ,
it'll create a file called SCliDLL.txt (or somthg like this) contains the
Complete Create Global Cube Statment for this cube

How to Connect to AS2005 using excel
data> pivot table> connection staff > and some nexts

Karim

"Peter" wrote:

Peter -

You have much more flexibility in creating local cubes with Analysis
Services 2005 by using ASSL (the Analysis Services Scripting Language).
Here's a paper I wrote that discusses the differences between using Create
Global Cube, Create Local Cube, and ASSL in creating Analysis Services 2005
local cubes:

http://www.cubeslice.com/UsingLocalC...Ser vices.doc

I hope you will find it helpful.

We have a new version of our software, CubeSlice 9 (now in beta) which now
supports local cube creation in Analysis Services 2005. There are far fewer
limitations on local cube creation in Analysis Services 2005 then there were
in Analysis Services 2000.

Here's a Create Global Cube statement that works on my computer with
Adventure Works:

CREATE GLOBAL CUBE [Adventure Works]
STORAGE 'c:\Program Files\CubeSlice 9\Data\Adventure Works DW_Adventure
Works3.cub' FROM [Adventure Works]
(
MEASURE [Adventure Works].[Amount],
DIMENSION [Adventure Works].[Account],
DIMENSION [Adventure Works].[Scenario]
)

Tim Peterson
www.cubeslice.com


"Peter" <peterr (AT) intellimaxsolutions (DOT) com> wrote