InitializeDesign (clsPartitionAnalyzer)

Analysis Services Programming

Analysis Services Programming

InitializeDesign (clsPartitionAnalyzer)

The InitializeDesign method of an object of ClassType clsPartitionAnalyzer checks the partition structure to ensure that clsPartitionAnalyzer can be run on it and initializes the objects necessary for performing the analysis.

Syntax

object. InitializeDesign([ByVal OlapMode])

object

The object of ClassType clsPartitionAnalyzer used to perform the analysis.

OlapMode

An optional Variant value representing an OlapStorageModes constant. If no value is supplied, the value supplied by the AggregationsOLAPMode property of the parent object is used.

Remarks

The InitializeDesign method does not work on partitions associated with linked cubes, because no aggregations are allowed for linked cubes.

Example

Use the following code to create an object of ClassType clsPartitionAnalyzer and initialize its design.

Note  This example will fail if the first cube in the server's collection is a linked cube, because you cannot design aggregations for linked cubes.

Dim dsoServer         As DSO.Server
Dim dsoDB             As DSO.MDStore
Dim dsoCube           As DSO.MDStore
Dim dsoPart           As DSO.MDStore
Dim dsoAgg            As DSO.MDStore
Dim dsoPartAnalyzer   As DSO.PartitionAnalyzer
Dim strErr            As String

' Initialize server
' LocalHost defaults to your Windows 2000 or Windows NT 4.0 computer
' name.
Set dsoServer = New DSO.Server
dsoServer.Connect("LocalHost")

Set dsoDB = Server.MDStores(1)  ' Get first database on server.
Debug.Print " Database Opened: " & dsoDB.Name
Set dsoCube = dsoDB.MDStores(1)  ' Get first cube in database.
Debug.Print "  Cube Opened: " & dsoCube.Name
Set dsoPart = dsoCube.MDStores(1)  ' Get first partition in cube.
Debug.Print "   Partition Opened: " & dsoPart.Name
Set dsoPartAnalyzer = dsoPart.Analyzer  ' Instantiate an analyzer object.

dsoPartAnalyzer.InitializeDesign 

See Also

clsAggregation

clsPartition

clsPartitionAnalyzer