Hello,
I understood that creating a local cube by ADODB is
allowed only when specifying:
CREATE CUBE ...
INSERT INTO ...
SELECT ...

that means I have to load data on cube at crreation time.
It is no work arround to separate to two steps (or 3)?
Creation of cube, loading dimension members and loading
data (transactions)?
It's no way to append data on an existing local cube but
to re-create it?

And how I will specify if I want to create a ROLAP or
MOLAP local cube?

Thanks a lot

"Catalin" <catalin_nastac (AT) hotmail (DOT) com> wrote

Yes, local cubes are fully populated on creation. There is no incremental
processing for local cubes.

Look at the DEFER_ANALYSIS property. When it is true - it will be ROLAP,
when it is false - it will be MOLAP.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================