Cube editer has locked cube for writing.
What has happened? I couldn't even open the cube, please help.Thanks

Stop and start the OLAP service on the Analysis Server.
"cwang" <cwang.nospamm. (AT) cemstone (DOT) com> wrote

Thanks , but how to stop ans restart?

"AshVsAOD" <.> wrote

Open the Services applet... RUN> Services.msc... Find MSSQL OLAP service...
Restart.
"cwang" <cwang.nospamm. (AT) cemstone (DOT) com> wrote

From a dos box:

C:\> net stop mssqlserverolapservice
C:\> net start mssqlserverolapservice

Or put the same two commands in a batch file and just double-click on it :-)

Enjoy.

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

"AshVsAOD" <.> wrote