This may be a funny one...
I want to write a program that creates a local cube but I only find
references to the
'CREATE GLOBAL/SESSION CUBE...' ddl statements syntax.
I don't understand to whom should I assign this statement??
My hunch is that it should be an instance of pivot table services?
Can you give some reference to its api??
Thanks alot
Rea

OK
I found the vbAdoCreateCube sample in the AS samples which uses
ADODB connection to an ole db for olap provider to run 'CREAT CUBE' +
'INSERT CUBE'
ddl statements.
I need now a way to replace these statements with the 'CREATE GLOBAL CUBE'
statement.
I tried replacing "CREATECUBE=CREATE CUBE Sample( ...)" with
I tried replacing "CREATEGLOBALCUBE=CREATE GLOBAL CUBE Sample( ...)"
but it did not work...
Any suggestions will be appriciated!
10X
Rea

"Rea Peleg" <reapeleg (AT) barak-online (DOT) net> wrote

Our product automates the generation of local cube files, for both the
CREATE LOCAL CUBE syntax and the CREATE GLOBAL CUBE syntax. It also will
create VB files that generate these local cube files. We offer a free 30-day
full-featured demo, so that you can see how the VB code that you can use
without purchasing anything.

Tim Peterson
www.localcubetask.com

"Rea Peleg" <reapeleg (AT) barak-online (DOT) net> wrote

does it include calc measures from the cube ?


"Tim Peterson" <tpeterson (AT) sdgcomputing (DOT) com> skrev i en meddelelse
news:uPjTvNpPEHA.3452 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

You can choose to include or exclude each calculated member when using
CREATE LOCAL CUBE syntax. When using CREATE GLOBAL CUBE syntax all the
calculated members are included automatically.

Thanks

1) when using global cube does it calculate all possible aggreations - also
for calc members ?
2) is your program a graphical tool for the end user which allows him/her to
choose dimensions and measures or a mdx tool ?

\Michael V.

"Tim Peterson" <tpeterson (AT) sdgcomputing (DOT) com> skrev i en meddelelse
news:uy0J6upPEHA.832 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

1) when using global cube does it calculate all possible aggregations - also
for calc members ?

RESPONSE: Local cubes, whether they are created with CREATE LOCAL CUBE or
CREATE GLOBAL CUBE, do not contain any aggregations. This is not a problem,
as long as the local cubes are not too large. Local cubes perform very well
when browsed. The browsing speed can be even faster than for server cubes
because server cube browsing speed is slowed by network traffic.

2) is your program a graphical tool for the end user which allows him/her to
choose dimensions and measures or a mdx tool ?

RESPONSE: Our program is primarily an administrator's tool for designing,
scheduling the creation of, and distributing local cube files. It generates
the code needed to create local cubes, based on the administrator's
decisions about which parts of the Analysis Server cube should be included.
We also include a simple OLAP client tool that uses the Microsoft Office Web
Components, so that local cubes can be distributed to users who don't have
any other OLAP client tools to use. Our tool also programmatically generates
a simple installation package that includes the simple OLAP client tool and
a local cube file. When this file (which we call a CubeSlice) is opened by
end users, the data in the local cube file is immediately displayed in our
simple OLAP client tool, if the end user's machine has the Microsoft Office
Web Components installed.

I would encourage you to try our free 30-day demo. Our installation program
installs a custom task to DTS and an add-in which appears as a menu choice
in the Analysis Manager. You can design local cubes in the Analysis Manager
and then automate their repeated creation in DTS.

Tim Peterson
www.localcubetask.com