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

View products that this article applies to.

Expand all | Collapse all

SYMPTOMS

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

Back to the top

CAUSE

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

Back to the top

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

        Try
            ' Connect to SSAS Server
            server.Connect("ServerName")

            ' 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
                measuregroup.Process(ProcessType.ProcessDefault)
            Next

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

Back to the top