Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
3.1.4.3.2.1.1.1 ObjectReference Type

3.1.4.3.2.1.1.1 ObjectReference Type

Many of the commands require an element that is of type ObjectReference. An ObjectReference consists of a hierarchical list of references that, when concatenated, reference an object by its full path in the server object hierarchy.

Only a MajorObject (section 2.2.4.2.2.1) can be referenced by an ObjectReference.

  <xsd:complexType name="ObjectReference">
    <xsd:all>
      <xsd:element name="ServerID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="DatabaseID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="RoleID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="TraceID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="AssemblyID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="DimensionID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="DimensionPermissionID" type="xsd:string"
                   minOccurs="0"/>
      <xsd:element name="DataSourceID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="DataSourcePermissionID" type="xsd:string"
                   minOccurs="0"/>
      <xsd:element name="DatabasePermissionID" type="xsd:string"
                   minOccurs="0"/>
      <xsd:element name="DataSourceViewID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="CubeID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="MiningStructureID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="MeasureGroupID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="PerspectiveID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="CubePermissionID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="MdxScriptID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="PartitionID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="AggregationDesignID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="MiningModelID" type="xsd:string" minOccurs="0"/>
      <xsd:element name="MiningModelPermissionID" type="xsd:string"
                   minOccurs="0"/>
      <xsd:element name="MiningStructurePermissionID" type="xsd:string"
                   minOccurs="0"/>
    </xsd:all>
  </xsd:complexType>

The following table lists the elements that are needed to reference each of the major objects.

ServerID is always optional when referencing a major object, because the current server is used.

Major object to be referenced

Element to be used

Server

ServerID

Assembly (Server Assembly)

ServerID, AssemblyID

Assembly (Database Assembly)

ServerID, DatabaseID, AssemblyID

Trace

ServerID, TraceID

Database

ServerID, DatabaseID

DatabasePermission

ServerID, DatabaseID, DatabasePermissionID

Role (on Server)

ServerID, RoleID

Role (on Database)

ServerID, RoleID, DatabaseID

DataSource

ServerID, RoleID, DatabaseID, DataSourceID

DataSourcePermission

ServerID, RoleID, DatabaseID, DataSourceID, DataSourcePermissionID

DataSourceView

ServerID, RoleID, DatabaseID, DataSourceViewID

Dimension

ServerID, RoleID, DatabaseID, DimensionID

DimensionPermission

ServerID, RoleID, DatabaseID, DimensionID, DimensionPermissionID

MiningStructure

ServerID, RoleID, DatabaseID, MiningStructureID

MiningStructurePermission

ServerID, RoleID, DatabaseID, MiningStructureID, MiningStructurePermissionID

MiningModel

ServerID, RoleID, DatabaseID, MiningStructureID, MiningModelID

MiningModelPermission

ServerID, RoleID, DatabaseID, MiningStructureID, MiningModelID, MiningModelPermissionID

Cube

ServerID, RoleID, DatabaseID, CubeID

CubePermission

ServerID, RoleID, DatabaseID, CubeID, CubePermissionID

MeasureGroup

ServerID, RoleID, DatabaseID, CubeID, MeasureGroupID

AggregationDesign

ServerID, RoleID, DatabaseID, CubeID, MeasureGroupID, AggregationDesignID

Partition

ServerID, RoleID, DatabaseID, CubeID, MeasureGroupID, PartitionID

Perspective

ServerID, RoleID, DatabaseID, CubeID, PerspectiveID

MdxScript

ServerID, RoleID, DatabaseID, CubeID, MdxScriptID

Show:
© 2015 Microsoft