ssml:CT_PivotCacheDefinition
Complex type information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-pivotTable.xsd
Content
- Sequence [1..1]
- ssml:cacheSource [1..1] PivotCache Source Description
- ssml:cacheFields [1..1] PivotCache Fields
- ssml:cacheHierarchies [0..1] PivotCache Hierarchies
- ssml:kpis [0..1] OLAP KPIs
- ssml:tupleCache [0..1] Tuple Cache
- ssml:calculatedItems [0..1] Calculated Items
- ssml:calculatedMembers [0..1] Calculated Members
- ssml:dimensions [0..1] OLAP Dimensions
- ssml:measureGroups [0..1] OLAP Measure Groups
- ssml:maps [0..1] OLAP Measure Group
- ssml:extLst [0..1] Future Feature Storage Area
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| r:id | [0..1] | r:ST_RelationshipId | Relationship Identifier | |
| invalid | [0..1] | xsd:boolean | Invalid Cache | Default value is "false". |
| saveData | [0..1] | xsd:boolean | Save Pivot Records | Default value is "true". |
| refreshOnLoad | [0..1] | xsd:boolean | Refresh On Load | Default value is "false". |
| optimizeMemory | [0..1] | xsd:boolean | Optimize Cache for Memory | Default value is "false". |
| enableRefresh | [0..1] | xsd:boolean | Enable PivotCache Refresh | Default value is "true". |
| refreshedBy | [0..1] | ssml:ST_Xstring | Last Refreshed By | |
| refreshedDate | [0..1] | xsd:double | PivotCache Last Refreshed Date | |
| backgroundQuery | [0..1] | xsd:boolean | Background Query | Default value is "false". |
| missingItemsLimit | [0..1] | xsd:unsignedInt | Missing Items Limit | |
| createdVersion | [0..1] | xsd:unsignedByte | PivotCache Created Version | Default value is "0". |
| refreshedVersion | [0..1] | xsd:unsignedByte | PivotCache Last Refreshed Version | Default value is "0". |
| minRefreshableVersion | [0..1] | xsd:unsignedByte | Minimum Version Required for Refresh | Default value is "0". |
| recordCount | [0..1] | xsd:unsignedInt | PivotCache Record Count | |
| upgradeOnRefresh | [0..1] | xsd:boolean | Upgrade PivotCache on Refresh | Default value is "false". |
| tupleCache | [0..1] | xsd:boolean | Stores Cache for OLAP Functions | Default value is "false". |
| supportSubquery | [0..1] | xsd:boolean | Supports Subqueries | Default value is "false". |
| supportAdvancedDrill | [0..1] | xsd:boolean | Supports Attribute Drilldown | Default value is "false". |
Used by
- Element ssml:pivotCacheDefinition