Cube PutProperties

Sets the XML properties for the specified OLAP cube.

Custom properties can be added as direct child elements of <Alea:Properties>.

Request

All properties in this example are system properties.

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="001" Class="Cube" Method="PutProperties">
    <Alea:Cube Name="CubeName">
      <Alea:Properties>
        <Alea:MDACList>
          <Alea:MDAC Name="MDAC1"/>
          <Alea:MDAC Name="MDAC2"/>
        </Alea:MDACList>
        <Alea:RACList>
          <Alea:RAC Name="RAC1"/>
          <Alea:RAC Name="RAC2"/>
        </Alea:RACList>
        <Alea:MeasureDimension Name="DimensionName"/>
        <Alea:FormatDimension Name="DimensionName"/>
        <Alea:TRS Enabled="true"/>
        <Alea:ErrorSuppression Enabled="true"/>
        <Alea:AccessCube Enabled="true"/>
        <Alea:DefaultPermission>None</Alea:DefaultPermission><!-- only for MDAC and RAC cubes -->
        <Alea:Translation LocaleIdentifier="locale">
          <Alea:Description>Description</Alea:Description>
          <Alea:Caption>Caption</Alea:Caption>
        </Alea:Translation>
        <Alea:CachePartitionDimension Name="DimensionName"/>
      </Alea:Properties>
    </Alea:Cube>
  </Alea:Request>
</Alea:Document>

This table describes the system properties:

Property Description
Alea:MDACList This is the list of assigned MDAC cube names.
Alea:RACList This is the list of assigned RAC cube names.
Alea:Rules Number This is information about rules, read-only. Currently only the number of rules is returned.
Alea:MeasureDimension Name The name of the explicitly defined Measure dimension.
Alea:TRS Enabled Indicates if transaction logging is switched on or off.
Alea:ErrorSuppression Enabled Indicates if an error is returned when attempting to write to a consolidated cell.
Alea:AccessCube Enabled Indicates if cube access control is active or not.
Alea:DefaultPermission Only for MDAC and RAC cubes: the permission to use as default for this cube.

The possible values are None, Read, Write.

Alea:CachePartitionDimension Name This is the name of the dimension used for cache partitioning.
Alea:Translation LocaleIdentifier This is information about translation locale identifiers. The information is returned in the Alea:Caption and Alea:Description attributes.
Alea:FormatDimension This is the name of the dimension to use for cell formats. If the format dimension is empty, the Measure dimension is used. If the format dimension does not contain format strings, the default format string is used. Once a format dimension is set in the XML properties of a cube, it cannot be removed. You can set it to an empty string to reset the format dimension.

The attribute field that holds the format strings of the elements on that dimension is called FORMAT_STRING. This name is case-insensitive.

Alea:DynamicAttributes Property of a fact cube. For the syntax and a description, see "Data storage" under Related topics.
Alea:DynamicAttributeConfiguration Property of a dynamic attribute cube. For the syntax and a description see "Data storage" under Related topics.

Answer

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="001">
    <Alea:Return/>
  </Alea:Request>
</Alea:Document>

Error

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="001">
    <Alea:Error ErrorID="error_code"/>
  </Alea:Request>
</Alea:Document>

Example for user-defined properties

This request uses two user-defined (Plato, Sokrates) properties and one system property (TRS):

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="001" Class="Cube" Method="PutProperties">
    <Alea:Cube Name="COST">
      <Alea:Properties xmlns:Alea="http://www.misag.com">
        <Alea:Plato Enabled="true" />
        <Alea:Sokrates Enabled="false"/>
        <Alea:TRS Enabled="true"/>
      </Alea:Properties>
    </Alea:Cube>
  </Alea:Request>
</Alea:Document>