When you use the ALTER CUBE statement to insert a new member as a second generation descendant into a writeback-enabled parent-child dimension, the MSSQLServerOLAPService service restarts unexpectedly.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help