The ADO MD Dimension object represents a dimension in a cube and contains one or more hierarchies of members.

Basic Usage

This VBS code gets properties of the Dimensions collection

Response.Write "<ul>"
For intDim = 0 To cdf1.Dimensions.Count - 1
    Set dim1 = cdf1.Dimensions(intDim)
    Response.Write "<li>Dimension: " & dim1.Name
    Response.Write "<ul>"
    Response.Write "<li>" & "Description: " & dim1.Description & "</li>"
    Response.Write "<li>" & "Name: " & dim1.Name & "</li>"
    Response.Write "<li>" & "UniqueName: " & dim1.UniqueName & "</li>"
    For i = 0 To dim1.Properties.Count - 1
        Response.Write _ 
            "<li>" & _
            dim1.Properties(i).Name & ": " & _
            dim1.Properties(i).Value & "</li>"
    Next
    Response.Write "</ul></li>"
Next
Response.Write "</ul>"

 

Object Members

Properties Collections Methods Events
  1. Description
  2. Name
  3. UniqueName
  1. Hierarchies
  2. Properties
  1. (None)
  1. (None)

Here are some of the properties available through the Properties collection:

Name Description
CatalogName The name of the catalog to which this cube belongs.
CubeName The name of the cube.
DefaultHierarchy The unique name of the default hierarchy.
DimensionCaption A label or caption associated with the dimension.
DimensionCardinality The number of members in the dimension.
DimensionGUID The GUID of the dimension.
DimensionName The name of the dimension.
DimensionOrdinal The ordinal number of the dimension among the group of dimensions that form the cube.
DimensionType The dimension type.
DimensionUniqueName The unambiguous name of the dimension.
SchemaName The name of the schema to which this cube belongs.

Page Modified: (Hand noted: 2007-10-10 20:00:39Z) (Auto noted: 2007-11-17 06:47:29Z)