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 |