Are there any plans for extending the functionality of create cube statement
to global cubes?

Thanks,
Cagdas Ucar (Chadash Uchar)

Exametric, Inc.

Software Engineer

"Cagdas Ucar" <cagdas.ucar (AT) exametric (DOT) com> wrote

Can you please explain what extensions do you have in mind ?

--
==================================================
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.
==================================================

I only want to use the MDX create cube statement to create global cubes, not
only local ones.

"Mosha Pasumansky [MS]" <moshap (AT) microsoft (DOT) com> wrote

"Cagdas Ucar" <cagdas.ucar (AT) exametric (DOT) com> wrote

If by global cubes you mean server cubes, then it is not possible in
Analysis Services 2000. We will look into it for the next release.
Hopefully there is no confusion with CREATE GLOBAL CUBE syntax which allows
creation of session cubes.

--
==================================================
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.
==================================================

Yes, I mean the server cubes. I know about create cube and create global
cube statements. What I want to do is just create a server cube from
scratch. Of course dimensions, measures and aggregations should be created
with MDX, too. When do you think approximately this feature can be
implemented? Because right now, because there is no DDL in MDX for creating
a server cube from scratch, we had to use XML files and process them with a
program using DSO, which we're not very happy with because it's not standard
and we might have to change this in future releases due to changes in
Analysis Services. I just wish that we could create cubes just like we
create tables on SQL Server, with a create cube statement and I believe many
people would wish that.

Thanks,

"Mosha Pasumansky [MS]" <moshap (AT) microsoft (DOT) com> wrote

"Cagdas Ucar" <cagdas.ucar (AT) exametric (DOT) com> wrote

You are correct that this is on the wish list of many people. I cannot
comment neither on the feature set of the next release, nor on its
timelines.
The only thing I can tell, is that we are aware of this feature request.

Thanks,
Mosha.

--
==================================================
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.
==================================================