Dear All,

Does anybody know how to create offline cube files with Ms. Excel
Pivot Table automatically through coding or something. Please could you
give me some direction or maybe white paper that should I refer.
Thanks anyway

Do a search for the CREATE GLOBAL CUBE statement this allows you to create
offline cubes.

Mark Hill

"Resant" <resant_v (AT) yahoo (DOT) com> wrote

As far as I know, it is not possible to script the functionality of the
off-line cube creation wizard in Microsoft Excel.

It is possible to automate the creation of local cube files. Microsoft
provides two commands for creating local cubes:

1. CREATE LOCAL CUBE, which creates a local cube from an Analysis Server
cube or from a relational database query.

2. CREATE GLOBAL CUBE, which creates a local cube only from an Analysis
Server cube.

Our company has created a product which implements these two commands, both
with an Add-In in the Analysis Manager and with a DTS custom task. With the
Analysis Manager Add-In, you can create local cubes as you are working with
your server cubes. With the DTS custom task, you can schedule the
re-creation of your local cubes when the Analysis Server cube data changes.

Our product also has a Save To VB function, so that you can see the code
that is needed for implementing both CREATE LOCAL CUBE and CREATE GLOBAL
CUBE. We would love to have you buy our product for your local cube creation
needs, but you are also welcome to download our 30-day free demo,
automatically generate the VB code that creates your local cubes and use
that code wherever you want.

Local cubes are very useful, but they have some limitations. Make sure you
see if your cubes will work as local cubes before you commit to depending on
them.

Good luck!

Tim Peterson
www.localcubetask.com

----- Original Message -----
From: "Resant" <resant_v (AT) yahoo (DOT) com>
Newsgroups: microsoft.public.sqlserver.olap
Sent: Wednesday, March 02, 2005 11:42 PM
Subject: How to Create Offline Cube Automatically

In a dts package you can actually make a connection to an AS base and in a
Executel SQL Task you can write the create cube statement....

No need for excel and you can automate it using sql server agent.

"Resant" <resant_v (AT) yahoo (DOT) com> wrote