Databases Reference
In-Depth Information
MDSCHEMA_ACTIONS
retrieves the
actions defined on the member
object specified in the
COORDINATE
restriction.
.
MDACTION_COORDINATE_
MEMBER
MDSCHEMA_ACTIONS
interprets the
COORDINATE
restriction as a subcube
specification and retrieves all the
actions applicable to the cell speci-
fied by the subcube.
.
MDACTION_COORDINATE_
CELL
The name of the cube in whose context all other restrictions are
resolved.
CUBE_NAME
TABLE 15.8
Optional Restrictions for the
MDSCHEMA_ACTIONS
Schema Rowset
Name
Description
The name of the action.
ACTION_NAME
The type of the action. If the client application supports only actions of
specific types, it might provide the type in
ACTION_TYPE
restriction. If
client application doesn't provide this restriction, Analysis Services by
default returns actions of all types except
Proprietary
.
ACTION_TYPE
The name of the database. If this restriction is not specified, the default
database will be used. If this restriction specifies a database other than
the default, Analysis Services will return an empty result.
CATALOG_NAME
Type of invocation. The current version of Analysis Services supports
only actions of
INTERACTIVE
invocation type.
INVOCATION
LISTING 15.10
XML/A Discover Request That Retrieves the List of Actions
<Envelope xmlns = “http://schemas.xmlsoap.org/soap/envelope/”>
<Body>
<Discover xmlns = “urn:schemas-microsoft-com:xml-analysis”>
<RequestType>MDSCHEMA_ACTIONS</RequestType>
<Restrictions>
<RestrictionList>
<CATALOG_NAME>FoodMart 2008</CATALOG_NAME>
<CUBE_NAME>Warehouse And Sales</CUBE_NAME>
<COORDINATE>
[Store].[Stores].[Store City].[Victoria]
</COORDINATE>
<COORDINATE_TYPE>4</COORDINATE_TYPE>
</RestrictionList>
</Restrictions>
<Properties>
<PropertyList>
<Catalog>FoodMart 2008</Catalog>
</PropertyList>
Search WWH ::
Custom Search