Identify Shared Dimensions among all Dimensions in a Database 1

[philipose]

Hi Gurus,
I am trying to process all shared dimensions, only in a database. This is the piece of code I am using

Dim oDSODimension As New DSO.Dimension
Dim oDSODB As New DSO.MDStore

For Each oDSODimension In oDSODB.Dimensions
oDSODimension.Process(ProcessTypes.processFull)
Next

Is there a way to check if oDSODimension is a shared dimension or not?? Currently I am processing all the shared and unshared dimensions in the database. Any pointers in this direction will be appreciated.

Philipose

 

[MDXer]

Straight from SQL BOL

Shared and Private Dimensions
DSO dimensions can be either shared or private. A shared dimension is one that can be used in multiple cubes, but a private dimension can only be used in a single cube. For more information about shared and private dimensions, see Shared and Private Dimensions.

Private dimensions use a special naming convention to identify the cubes to which they belong. In all other aspects, private dimensions are identical to shared dimensions. The name of a private dimension is constructed by using the cube name, followed by the caret character (^), followed by the dimension name. To create a private dimension in DSO, name the dimension according to this convention. This naming convention allows private dimensions in different cubes to have the same name, and the cube name prefix ensures uniqueness within the dimension collection of the database. For example, NorthWestSales^Stores represents a private dimension of stores created for use in the NorthWestSales cube.

You can programmatically determine whether a dimension is shared or private by reading its IsShared property. DSO determines the value of this property by examining the name of the dimension. All cubes, partitions, and aggregations that use the dimension inherit its IsShared property.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck