r (PivotCache Record)

Represents a single record of data in the PivotCache.

[Example:

<r>
<s v="3550"/>
<s v="Road-150 Red, 62"/>
<s v="This bike is ridden by race winners. Developed with the Adventure Works
Cycles professional race team, it has a extremely light heat-treated
aluminum frame, and steering that allows precision control."/>

<s v="No Discount"/>
<x v="0"/>
<s v="Australian Dollar"/>
<n v="1"/>
<n v="3578.27"/>

<n v="0"/>
<n v="2171.2941999999998"/>
<n v="3578.27"/>
<n v="89.456800000000001"/>
</r>

end example]

Parent Elements

pivotCacheRecords (§3.10.1.68)

 

Child Elements	Subclause
b (Boolean)	§3.10.1.2
d (Date Time)	§3.10.1.21
e (Error Value)	§3.10.1.27
m (No Value)	§3.10.1.50
n (Numeric)	§3.10.1.60
s (Character Value)	§3.10.1.85
x (Shared Items Index)	§3.10.1.97

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Record">

   <choice maxOccurs="unbounded">

   <element name="m" type="CT_Missing"/>

   <element name="n" type="CT_Number"/>

   <element name="b" type="CT_Boolean"/>

   <element name="e" type="CT_Error"/>

   <element name="s" type="CT_String"/>

   <element name="d" type="CT_DateTime"/>

   <element name="x" type="CT_Index"/>

   </choice>

</complexType>