I have used the nice gui drag and drop tools to build up the proper
dimensions and cubes for our application. Everyone seems quite happy
with the result so far.

Now, this has the be converted so that the creation happens during
install. Just like we issue a bunch of ddl at install time to build
the schema for our OLTP, we need to do that for the OLAP model as
well.

I was hoping for a right-click create script feature, but don't see
one.

Anyone know how this is done ?

-- Thanks, ANdrew

There is a metadata scripter that comes with the SQL Server 2000 resource
kit whch may do the job. In terms of install you could just archive off the
database to a .cab file and restore it with the command line utility
msmdarch...

Hope that helps
Rob

"Andrew Taylor" <aktweb (AT) msn (DOT) com> wrote