Hi

I like to rename the cube.

Is there anyway I can do this?
(without SAVE AS method or COPY and PASTE method)

Thanks,
rpr

You can't change it rhough Analysis Manager. You could try
editing it directly within the Analysis Services
repository - but be careful.

The Analysis Services repository is caled msmdrep.mdb so
you'll need MS Access to run it. If I were you I'd take a
copy of it first and test it on that before messing
directly with the proper repository.

Regards
Jamie

In article <431101c37c62$3a1ca1a0$a501280a (AT) phx (DOT) gbl>, Jamie Thomson
<jamie.thomson (AT) int21 (DOT) com> writes
There is a tool in the SQL 2K resource it that allows you to script a
cube out to VB or VBScript I forget which. You could then edit the
script before executing t to re-create the cube with the new name. Might
be safer than hacking the repository.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org