Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

CellInfo Element (XMLA)


Applies To: SQL Server 2016 Preview

Represents the cell metadata contained by the parent OlapInfo element.

      <!-- One or more cell property definitions -->  

Data type and lengthNone
Default valueNone
Cardinality1-1: Required element that occurs once and only once.
Parent elementsOlapInfo
Child elementsOne or more cell property definitions

The CellInfo element contains a collection of cell properties for the cells included within the multidimensional dataset returned by a root element using the MDDataSet data type. Each cell property in the CellInfo element is defined by a separate XML element, each with a name attribute and a type attribute. The name attribute of the cell property corresponds to the name of the OLE DB for the OLAP cell property represented by the XML element, and the type attribute represents the XML data type of the cell property. The name of the XML element is used to identify the value of the cell property for cells contained in the CellData element of the root element.

The following syntax describes a cell property definition:

<CellPropertyDefinition name="string" type"string" />  

The available properties and their values can be obtained by using the DISCOVER_PROPERTIES request type with the Discover method. There is no required order for the properties listed in the PropertyList element.

A provider can optionally specify default values for individual member or cell properties in the AxisInfo or CellInfo section. Default values can provide a smaller result if the property always or almost always has the same value. To indicate a default value for a property, theDefault element can optionally be specified as a child element of one of the cell property definition elements. Therefore, the absence of a member or cell property in the result indicates that the stated default is the value for the cell property.

The following example demonstrates how the VALUE, FORMATTED_VALUE, and FORMAT_STRING cell properties are represented in the CellInfo element.

         <Value name="VALUE"></Value>  
         <FmtValue name="FORMATTED_VALUE"></FmtValue>  
         <FormatString name="FORMAT_STRING"></FormatString>  

Properties (XMLA)

Community Additions

© 2016 Microsoft