Hello, I have a relational database that I would like to build a local cube
..cub file
from. Is it possible to do this programmically everytime the user opens up
the
application and then use that local cube with OWC? Or in other words, can
you create
a .cub file similar to the way you could create a .txt file etc?

If yes, any pointers to information? Books? Simple sample vb application?

Thanks in advance,

Hi Juan,

Have a look at localcube.exe

FILE: New Syntax Available to Create Local Cubes
http://support.microsoft.com/default...b;en-us;319641

SUMMARY
The Localcube.exe file is a sample file that is available for download.
Microsoft SQL Server 2000 Analysis Services Service Pack 1 (SP1) provides
expanded capabilities. At the same time, it simplifies the data definition
language (DDL) that is used to provide local online analytical processing
(OLAP) functionality. This downloadable file provides a working Microsoft
Visual Basic sample application with illustrative code that you can use to
create Local, Global, and Session cubes. Localcube.exe runs on Intel-based
computers, and on computers that are running the following operating
systems:

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."