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

SYMPTOMS

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

CAUSE

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

WORKAROUND

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

STATUS

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

REFERENCES

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

Properties

Article ID: 941742 - Last Review: October 30, 2007 - Revision: 1.1
APPLIES TO
  • Microsoft SQL Server 2005 Analysis Services
Keywords: 
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