ADO MD Objects

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.

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 Position object.
      • The Member object.

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

2007-10-10 19:13:41Z