Hello:
I'd like to ask 2 questions:
1.How to normalize data cube in sense of statistical normalization, not
relational?
2.How to create a data cube without using Analysis Services Manager but
using DTS
packages based on MDX and SQL statements?

Thanks,
GB

For #2, Unfortunately you cannot. The RDBMS uses the SQL language for both
DDL and DMO operations. With Analysis Serivces we use MDX for DMO and a
different API called DSO (Decisions Support Objects) for admnistration.

A complete discussion of DSO is pretty extensive (see BOL). In SQL Server
2005 there is a new scripting language for Analysis Services which provides
a complete DDL lnaguage, but the best we have for SQL Server 2000 is an
unsupported utility called DSO/XML available from the Microsoft download
site at:
http://www.microsoft.com/downloads/d...DisplayLang=en
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"GB" <v7v1k3 (AT) hotmail (DOT) com> wrote

Can you explain what are your requirements for the question 1?

Lookat the Create cube statement in the BOL
You can create file based OLAP cubes using the create cube command.
To create OLAP Server cubes, you have to create some scripts and use the DSO
object model.

"GB" <v7v1k3 (AT) hotmail (DOT) com> wrote