ADO MD (ActiveX Data Objects Multidimensional) provides objects that deal with MD data such as cubes via an OLE DB provider that is also an MDP (MD Data Provider). If you are unfamiliar with MD data, see my section on MD Data.

Here are two basic arrangements of the ADO MD Object Model.

ADO MD Object Tree 10 Classes and 7 Collections
  • Catalog
    • CubeDef in CubeDefs
      • Property in Properties
      • Dimension in Dimensions
        • Property in Properties
        • Hierarchy in Hierarchies
          • Property in Properties
          • Level in Levels
            • Property in Properties
            • Member in Members
              • Property in Properties
  • Cellset
    • Property in Properties
    • Axis in Axes
      • Property in Properties
      • Position in Positions
        • Member in Members
          • Property in Properties
    • Cell
      • Property in Properties
      • Position in Positions
        • Member in Members
          • Property in Properties

Here is an elaboration of the ADO MD object tree:

  • The Catalog object contains the MD schema and to connect to the MD data source.
    • The CubeDef object represents a cube.
      • The Dimension object represents a dimension in a cube and contains one or more hierarchies of members.
        • The Hierarchy object represents the way by which the members of a dimension can be structured (aggregated or rolled up) .
          • The Level object contains a set of members, each of which has the same rank within a hierarchy.
            • The Member object represents a member of a level in a cube or the children of a member of a level.
  • The Cellset object contains the results of an MD query.
    • The Axis object represents a positional or filter axis of a cellset and contains selected members of one or more dimensions.
      • The Position object represents a set of one or more members of one or more dimensions that defines a point along an axis.
        • The Member object represents a member of a position along an axis of a cellset.
    • The Cell represents the data at the intersection of axis positions (coordinates) contained in a cellset.

The Property object represents information pertaining to an object that can be read or set.



GeorgeHernandez.comSome rights reserved