ProClarity's local cube creator is an ActiveX object called KCreateCube.
You can include it into a Visual Basic project and run it straight from
there. The object is fully documented and should be able to do anything you
Here is some sample VB code to create a cub file from Foodmart 2000 Sales
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
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
Dim oMeasure As KCreateCube.CCMeasure
For Each oMeasure In oCube.Measures
oMeasure.Include = True
Set oCubeCreator = Nothing
Set oCube = Nothing
Set oSource = Nothing
Set oSession = Nothing
> there are some other tools beside Excel which can create a local cube.
> 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
> Tel: +49 5251 54009 11
> Fax: +49 5251 54009 99
> Mobil: +49 172 5683361
> Homepage: www.masp.de
> > 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
> > website (i.e. click here to receive latest cube file etc. Once the cube
> > been processed, I would then like to create a local .cub file which can
> > picked up and e-mailed as attachment to the person initiating the
> > command. I know it sounds a bit ambitious, but I feel certain someone
> > there is clever enough to figure this out. The e-mail part is no
> > also suspect we are capable enough to set up a DTS package to reprocess
> > cube, however, how do we create the local cube file by bypassing Excel
> > we manipulate the PivotTabel services with VB code).
> > Any help greatly appreciated, and if you live near Nottingham in
> > I'll buy you a pint. Cheers.....