Very Computer

Any help greatly appreciated, and if you live near Nottingham in England,
I'll buy you a pint. Cheers.....

there are some other tools beside Excel which can create a local cube. There
is ProClarity (which uses VBA, so there might be a way to "remote control"
the creation of a local cube) or you can contact www.mediaconsulting.com,
they have a product called "Rubik" which uses VBA as well and can create
local cubes. I didn't try it but I saw a datasheet of it, sounds fine...

...and if you come over to Germany, we can talk about the beer again... ;-)

Thomas Pagel, Senior Consultant
-------------------------------------------------------------
MASP Business Consulting GmbH
Hauptstr. 35
33178 Borchen
Germany
Tel: +49 5251 54009 11
Fax: +49 5251 54009 99
Mobil: +49 172 5683361

Homepage: www.masp.de

Quote:> I have a cube set up on my analysis server, I would like to routinely
> reprocess this cube, preferably when triggered by a user visiting a
specific
> website (i.e. click here to receive latest cube file etc. Once the cube
has
> been processed, I would then like to create a local .cub file which can be
> picked up and e-mailed as attachment to the person initiating the
reprocess
> command. I know it sounds a bit ambitious, but I feel certain someone out
> there is clever enough to figure this out. The e-mail part is no problem,
I
> also suspect we are capable enough to set up a DTS package to reprocess
the
> cube, however, how do we create the local cube file by bypassing Excel
(can
> we manipulate the PivotTabel services with VB code).

> Any help greatly appreciated, and if you live near Nottingham in England,
> I'll buy you a pint. Cheers.....

You may want to check out the Localcubetask.com website which has a
custom DTS task to publish local cube. If there  can be a way to
launch DTS task off the web, that should do the trick.

rgds

Ganesh

You can do this with VB and Pivot Table.
I work with that and it works fine.
Use must use CreateCube DDL stattment in ADO connection to make local cube.
BOL have basic explanations !

Ivica

Quote:> I have a cube set up on my analysis server, I would like to routinely
> reprocess this cube, preferably when triggered by a user visiting a
specific
> website (i.e. click here to receive latest cube file etc. Once the cube
has
> been processed, I would then like to create a local .cub file which can be
> picked up and e-mailed as attachment to the person initiating the
reprocess
> command. I know it sounds a bit ambitious, but I feel certain someone out
> there is clever enough to figure this out. The e-mail part is no problem,
I
> also suspect we are capable enough to set up a DTS package to reprocess
the
> cube, however, how do we create the local cube file by bypassing Excel
(can
> we manipulate the PivotTabel services with VB code).

> Any help greatly appreciated, and if you live near Nottingham in England,
> I'll buy you a pint. Cheers.....

The code sample from the BOL is almost identical to that which I have
followed in a Wrox OLAP book.

I can publish my sample code if you have time to take a quick look?

Paul

If you have analysis server installed, check out the samples directory.
Especially VbAdoCreateCube might help you out.

good luck,

Ben

Quote:> I have a cube set up on my analysis server, I would like to routinely
> reprocess this cube, preferably when triggered by a user visiting a
specific
> website (i.e. click here to receive latest cube file etc. Once the cube
has
> been processed, I would then like to create a local .cub file which can be
> picked up and e-mailed as attachment to the person initiating the
reprocess
> command. I know it sounds a bit ambitious, but I feel certain someone out
> there is clever enough to figure this out. The e-mail part is no problem,
I
> also suspect we are capable enough to set up a DTS package to reprocess
the
> cube, however, how do we create the local cube file by bypassing Excel
(can
> we manipulate the PivotTabel services with VB code).

> Any help greatly appreciated, and if you live near Nottingham in England,
> I'll buy you a pint. Cheers.....

I've cracked it out, the errors I encountered were purely down to my SQL
syntax.

Paul

Here is some sample VB code to create a cub file from Foodmart 2000 Sales
cube

   Dim oCubeCreator As KCreateCube.KCubeCreator
   Dim oCube As KCreateCube.CCCube

   Set oCubeCreator = New KCreateCube.KCubeCreator

   oCubeCreator.CubFileName = "C:\Temp.cub"

   Dim oSource As KTMDLib.KSource
   Set oSource = New KTMDLib.KSource
   oSource.Login oSource.CurrentProvider, "Localhost"

   Dim oSession As KTMDLib.KSession
   Set oSession = oSource.Catalogs("Foodmart
2000").Cubes("[Sales]").CreateSession

   Set oCube = oCubeCreator.Cubes.Add(oSesion)

   Dim oDim As KCreateCube.CCDimension
   Dim oHier As KCreateCube.CCHierarchy
   Dim oLevel As KCreateCube.CCLevel

   For Each oDim In oCube.Dimensions
      oDim.Include = True

      For Each oHier In oDim.Hierarchies
         oHier.Include = True

         For Each oLevel In oHier.Levels
            oLevel.Include = True
         Next oLevel
      Next oHier
   Next oDim

   Dim oMeasure As KCreateCube.CCMeasure

   For Each oMeasure In oCube.Measures
      oMeasure.Include = True
   Next

   oCubeCreator.CreateCube

   Set oCubeCreator = Nothing
   Set oCube = Nothing
   Set oSource = Nothing
   Set oSession = Nothing