L.2.12.3 Pivot XML fragment
L.2.12.3 Pivot XML fragment
In this example, the PivotTable data cache records /cacheSource@connectionId=“2”, which associates this PivotTable to the connection whose id=“2” in the workbook connections part.
<pivotCacheDefinition … saveData="0" refreshedBy="Chad Rothschiller"
refreshedDateIso="2006-04-13T16:02:14" backgroundQuery="1"
createdVersion="3"
refreshedVersion="3" minRefreshableVersion="3" recordCount="0">
<cacheSource type="external" connectionId="2"/>
<cacheFields count="2">
<cacheField name="[Category].[Category Description]"
caption="Category
Description" numFmtId="0" hierarchy="1" level="1">
<sharedItems count="4">
<s v="[Category].[All Category].[Current Year's Actuals]"
c="Current Year's Actuals"/>
…
</cacheField>
</cacheFields>
</pivoCacheDefinition>Last updated on