// Generates content of timeLineCachePart5. private void GenerateTimeLineCachePart5Content(TimeLineCachePart timeLineCachePart5) { X15.TimelineCacheDefinition timelineCacheDefinition5 = new X15.TimelineCacheDefinition(){ Name = "NativeTimeline_DeliveryDate5", SourceName = "DeliveryDate" }; timelineCacheDefinition5.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"); X15.TimelineCachePivotTables timelineCachePivotTables5 = new X15.TimelineCachePivotTables(); X15.TimelineCachePivotTable timelineCachePivotTable5 = new X15.TimelineCachePivotTable(){ TabId = (UInt32Value)9U, Name = "PivotTable1" }; timelineCachePivotTables5.Append(timelineCachePivotTable5); X15.TimelineState timelineState5 = new X15.TimelineState(){ MinimalRefreshVersion = (UInt32Value)6U, LastRefreshVersion = (UInt32Value)6U, PivotCacheId = (UInt32Value)2U, FilterType = PivotFilterValues.DateBetween }; X15.SelectionTimelineRange selectionTimelineRange1 = new X15.SelectionTimelineRange(){ StartDate = System.Xml.XmlConvert.ToDateTime("2000-01-01T00:00:00Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind), EndDate = System.Xml.XmlConvert.ToDateTime("2003-12-31T00:00:00Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) }; X15.BoundsTimelineRange boundsTimelineRange5 = new X15.BoundsTimelineRange(){ StartDate = System.Xml.XmlConvert.ToDateTime("2000-01-01T00:00:00Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind), EndDate = System.Xml.XmlConvert.ToDateTime("2004-01-01T00:00:00Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) }; timelineState5.Append(selectionTimelineRange1); timelineState5.Append(boundsTimelineRange5); timelineCacheDefinition5.Append(timelineCachePivotTables5); timelineCacheDefinition5.Append(timelineState5); timeLineCachePart5.TimelineCacheDefinition = timelineCacheDefinition5; }
// Generates content of timeLineCachePart8. private void GenerateTimeLineCachePart8Content(TimeLineCachePart timeLineCachePart8) { X15.TimelineCacheDefinition timelineCacheDefinition8 = new X15.TimelineCacheDefinition(){ Name = "NativeTimeline_Date", SourceName = "Date" }; timelineCacheDefinition8.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"); X15.TimelineCachePivotTables timelineCachePivotTables8 = new X15.TimelineCachePivotTables(); X15.TimelineCachePivotTable timelineCachePivotTable8 = new X15.TimelineCachePivotTable(){ TabId = (UInt32Value)4U, Name = "PivotTable1" }; timelineCachePivotTables8.Append(timelineCachePivotTable8); X15.TimelineState timelineState8 = new X15.TimelineState(){ MinimalRefreshVersion = (UInt32Value)6U, LastRefreshVersion = (UInt32Value)6U, PivotCacheId = (UInt32Value)1U, FilterType = PivotFilterValues.Unknown }; X15.BoundsTimelineRange boundsTimelineRange8 = new X15.BoundsTimelineRange(){ StartDate = System.Xml.XmlConvert.ToDateTime("2000-01-01T00:00:00Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind), EndDate = System.Xml.XmlConvert.ToDateTime("2003-01-01T00:00:00Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) }; timelineState8.Append(boundsTimelineRange8); timelineCacheDefinition8.Append(timelineCachePivotTables8); timelineCacheDefinition8.Append(timelineState8); timeLineCachePart8.TimelineCacheDefinition = timelineCacheDefinition8; }