A cube is not modified when you process the cube by using the ProcessDefault option in SQL Server 2005 Analysis Services

Article translations Article translations
Article ID: 941742 - View products that this article applies to.
Expand all | Collapse all


When you process a cube by using the ProcessDefault option in Microsoft SQL Server 2005 Analysis Services (SSAS), the cube is not modified.


This problem occurs because SSAS discards the ProcessDefault option on cubes.


To work around this problem, use the ProcessDefault option to process each measure group of the cube. The following Analysis Management Objects (AMO) script shows an example of how to do this. You can run this AMO script in a Script task in SQL Server 2005 Integration Services.
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.AnalysisServices

Public Class ScriptMain
    Public Sub Main()
        Dim taskResult As Integer
        Dim server As New Server
        Dim db As Database
        Dim cube As Cube
        Dim measuregroup As MeasureGroup

        ' Set by default the task result to a failure
        taskResult = Dts.Results.Failure

            ' Connect to SSAS Server

            ' Find the specified DB
            db = server.Databases("DatabaseName")

            ' Find the specified Cube
            cube = db.Cubes("CubeName")

            ' For each MG of the cube, do a ProcessDefault
            For Each measuregroup In cube.MeasureGroups

            ' Now the task can be considered as sucessfull
            taskResult = Dts.Results.Success
            If server.Connected Then server.Disconnect()
        End Try
        Dts.TaskResult = taskResult
    End Sub
End Class


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


For more information about the ProcessDefault option, visit the following Microsoft Web sites:


Article ID: 941742 - Last Review: October 30, 2007 - Revision: 1.1
  • Microsoft SQL Server 2005 Analysis Services
kbsql2005bi kbsql2005as kbprb kbexpertiseadvanced kbtshoot KB941742

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com