internal SLCacheHierarchy Clone() { SLCacheHierarchy ch = new SLCacheHierarchy(); ch.UniqueName = this.UniqueName; ch.Caption = this.Caption; ch.Measure = this.Measure; ch.Set = this.Set; ch.ParentSet = this.ParentSet; ch.IconSet = this.IconSet; ch.Attribute = this.Attribute; ch.Time = this.Time; ch.KeyAttribute = this.KeyAttribute; ch.DefaultMemberUniqueName = this.DefaultMemberUniqueName; ch.AllUniqueName = this.AllUniqueName; ch.AllCaption = this.AllCaption; ch.DimensionUniqueName = this.DimensionUniqueName; ch.DisplayFolder = this.DisplayFolder; ch.MeasureGroup = this.MeasureGroup; ch.Measures = this.Measures; ch.Count = this.Count; ch.OneField = this.OneField; ch.MemberValueDatatype = this.MemberValueDatatype; ch.Unbalanced = this.Unbalanced; ch.UnbalancedGroup = this.UnbalancedGroup; ch.Hidden = this.Hidden; ch.FieldsUsage = new List <int>(); foreach (int i in this.FieldsUsage) { ch.FieldsUsage.Add(i); } ch.GroupLevels = new List <SLGroupLevel>(); foreach (SLGroupLevel gl in this.GroupLevels) { ch.GroupLevels.Add(gl.Clone()); } return(ch); }
internal void FromPivotCacheDefinition(PivotCacheDefinition pcd) { this.SetAllNull(); if (pcd.Id != null) this.Id = pcd.Id.Value; if (pcd.Invalid != null) this.Invalid = pcd.Invalid.Value; if (pcd.SaveData != null) this.SaveData = pcd.SaveData.Value; if (pcd.RefreshOnLoad != null) this.RefreshOnLoad = pcd.RefreshOnLoad.Value; if (pcd.OptimizeMemory != null) this.OptimizeMemory = pcd.OptimizeMemory.Value; if (pcd.EnableRefresh != null) this.EnableRefresh = pcd.EnableRefresh.Value; if (pcd.RefreshedBy != null) this.RefreshedBy = pcd.RefreshedBy.Value; if (pcd.RefreshedDate != null) this.RefreshedDate = pcd.RefreshedDate.Value; if (pcd.BackgroundQuery != null) this.BackgroundQuery = pcd.BackgroundQuery.Value; if (pcd.MissingItemsLimit != null) this.MissingItemsLimit = pcd.MissingItemsLimit.Value; if (pcd.CreatedVersion != null) this.CreatedVersion = pcd.CreatedVersion.Value; if (pcd.RefreshedVersion != null) this.RefreshedVersion = pcd.RefreshedVersion.Value; if (pcd.MinRefreshableVersion != null) this.MinRefreshableVersion = pcd.MinRefreshableVersion.Value; if (pcd.RecordCount != null) this.RecordCount = pcd.RecordCount.Value; if (pcd.UpgradeOnRefresh != null) this.UpgradeOnRefresh = pcd.UpgradeOnRefresh.Value; if (pcd.IsTupleCache != null) this.IsTupleCache = pcd.IsTupleCache.Value; if (pcd.SupportSubquery != null) this.SupportSubquery = pcd.SupportSubquery.Value; if (pcd.SupportAdvancedDrill != null) this.SupportAdvancedDrill = pcd.SupportAdvancedDrill.Value; if (pcd.CacheSource != null) this.CacheSource.FromCacheSource(pcd.CacheSource); // doing one by one because it's bloody hindering awkward complicated. if (pcd.CacheFields != null) { SLCacheField cf; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.CacheFields)) { while (oxr.Read()) { if (oxr.ElementType == typeof(CacheField)) { cf = new SLCacheField(); cf.FromCacheField((CacheField)oxr.LoadCurrentElement()); this.CacheFields.Add(cf); } } } } if (pcd.CacheHierarchies != null) { SLCacheHierarchy ch; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.CacheHierarchies)) { while (oxr.Read()) { if (oxr.ElementType == typeof(CacheHierarchy)) { ch = new SLCacheHierarchy(); ch.FromCacheHierarchy((CacheHierarchy)oxr.LoadCurrentElement()); this.CacheHierarchies.Add(ch); } } } } if (pcd.Kpis != null) { SLKpi k; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.Kpis)) { while (oxr.Read()) { if (oxr.ElementType == typeof(Kpi)) { k = new SLKpi(); k.FromKpi((Kpi)oxr.LoadCurrentElement()); this.Kpis.Add(k); } } } } if (pcd.TupleCache != null) { this.TupleCache.FromTupleCache(pcd.TupleCache); this.HasTupleCache = true; } if (pcd.CalculatedItems != null) { SLCalculatedItem ci; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.CalculatedItems)) { while (oxr.Read()) { if (oxr.ElementType == typeof(CalculatedItem)) { ci = new SLCalculatedItem(); ci.FromCalculatedItem((CalculatedItem)oxr.LoadCurrentElement()); this.CalculatedItems.Add(ci); } } } } if (pcd.CalculatedMembers != null) { SLCalculatedMember cm; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.CalculatedMembers)) { while (oxr.Read()) { if (oxr.ElementType == typeof(CalculatedMember)) { cm = new SLCalculatedMember(); cm.FromCalculatedMember((CalculatedMember)oxr.LoadCurrentElement()); this.CalculatedMembers.Add(cm); } } } } if (pcd.Dimensions != null) { SLDimension d; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.Dimensions)) { while (oxr.Read()) { if (oxr.ElementType == typeof(Dimension)) { d = new SLDimension(); d.FromDimension((Dimension)oxr.LoadCurrentElement()); this.Dimensions.Add(d); } } } } if (pcd.MeasureGroups != null) { SLMeasureGroup mg; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.MeasureGroups)) { while (oxr.Read()) { if (oxr.ElementType == typeof(MeasureGroup)) { mg = new SLMeasureGroup(); mg.FromMeasureGroup((MeasureGroup)oxr.LoadCurrentElement()); this.MeasureGroups.Add(mg); } } } } if (pcd.Maps != null) { SLMeasureDimensionMap mdm; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.Maps)) { while (oxr.Read()) { if (oxr.ElementType == typeof(MeasureDimensionMap)) { mdm = new SLMeasureDimensionMap(); mdm.FromMeasureDimensionMap((MeasureDimensionMap)oxr.LoadCurrentElement()); this.Maps.Add(mdm); } } } } }
internal SLCacheHierarchy Clone() { SLCacheHierarchy ch = new SLCacheHierarchy(); ch.UniqueName = this.UniqueName; ch.Caption = this.Caption; ch.Measure = this.Measure; ch.Set = this.Set; ch.ParentSet = this.ParentSet; ch.IconSet = this.IconSet; ch.Attribute = this.Attribute; ch.Time = this.Time; ch.KeyAttribute = this.KeyAttribute; ch.DefaultMemberUniqueName = this.DefaultMemberUniqueName; ch.AllUniqueName = this.AllUniqueName; ch.AllCaption = this.AllCaption; ch.DimensionUniqueName = this.DimensionUniqueName; ch.DisplayFolder = this.DisplayFolder; ch.MeasureGroup = this.MeasureGroup; ch.Measures = this.Measures; ch.Count = this.Count; ch.OneField = this.OneField; ch.MemberValueDatatype = this.MemberValueDatatype; ch.Unbalanced = this.Unbalanced; ch.UnbalancedGroup = this.UnbalancedGroup; ch.Hidden = this.Hidden; ch.FieldsUsage = new List<int>(); foreach (int i in this.FieldsUsage) { ch.FieldsUsage.Add(i); } ch.GroupLevels = new List<SLGroupLevel>(); foreach (SLGroupLevel gl in this.GroupLevels) { ch.GroupLevels.Add(gl.Clone()); } return ch; }
internal void FromPivotCacheDefinition(PivotCacheDefinition pcd) { this.SetAllNull(); if (pcd.Id != null) { this.Id = pcd.Id.Value; } if (pcd.Invalid != null) { this.Invalid = pcd.Invalid.Value; } if (pcd.SaveData != null) { this.SaveData = pcd.SaveData.Value; } if (pcd.RefreshOnLoad != null) { this.RefreshOnLoad = pcd.RefreshOnLoad.Value; } if (pcd.OptimizeMemory != null) { this.OptimizeMemory = pcd.OptimizeMemory.Value; } if (pcd.EnableRefresh != null) { this.EnableRefresh = pcd.EnableRefresh.Value; } if (pcd.RefreshedBy != null) { this.RefreshedBy = pcd.RefreshedBy.Value; } if (pcd.RefreshedDate != null) { this.RefreshedDate = pcd.RefreshedDate.Value; } if (pcd.BackgroundQuery != null) { this.BackgroundQuery = pcd.BackgroundQuery.Value; } if (pcd.MissingItemsLimit != null) { this.MissingItemsLimit = pcd.MissingItemsLimit.Value; } if (pcd.CreatedVersion != null) { this.CreatedVersion = pcd.CreatedVersion.Value; } if (pcd.RefreshedVersion != null) { this.RefreshedVersion = pcd.RefreshedVersion.Value; } if (pcd.MinRefreshableVersion != null) { this.MinRefreshableVersion = pcd.MinRefreshableVersion.Value; } if (pcd.RecordCount != null) { this.RecordCount = pcd.RecordCount.Value; } if (pcd.UpgradeOnRefresh != null) { this.UpgradeOnRefresh = pcd.UpgradeOnRefresh.Value; } if (pcd.IsTupleCache != null) { this.IsTupleCache = pcd.IsTupleCache.Value; } if (pcd.SupportSubquery != null) { this.SupportSubquery = pcd.SupportSubquery.Value; } if (pcd.SupportAdvancedDrill != null) { this.SupportAdvancedDrill = pcd.SupportAdvancedDrill.Value; } if (pcd.CacheSource != null) { this.CacheSource.FromCacheSource(pcd.CacheSource); } // doing one by one because it's bloody hindering awkward complicated. if (pcd.CacheFields != null) { SLCacheField cf; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.CacheFields)) { while (oxr.Read()) { if (oxr.ElementType == typeof(CacheField)) { cf = new SLCacheField(); cf.FromCacheField((CacheField)oxr.LoadCurrentElement()); this.CacheFields.Add(cf); } } } } if (pcd.CacheHierarchies != null) { SLCacheHierarchy ch; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.CacheHierarchies)) { while (oxr.Read()) { if (oxr.ElementType == typeof(CacheHierarchy)) { ch = new SLCacheHierarchy(); ch.FromCacheHierarchy((CacheHierarchy)oxr.LoadCurrentElement()); this.CacheHierarchies.Add(ch); } } } } if (pcd.Kpis != null) { SLKpi k; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.Kpis)) { while (oxr.Read()) { if (oxr.ElementType == typeof(Kpi)) { k = new SLKpi(); k.FromKpi((Kpi)oxr.LoadCurrentElement()); this.Kpis.Add(k); } } } } if (pcd.TupleCache != null) { this.TupleCache.FromTupleCache(pcd.TupleCache); this.HasTupleCache = true; } if (pcd.CalculatedItems != null) { SLCalculatedItem ci; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.CalculatedItems)) { while (oxr.Read()) { if (oxr.ElementType == typeof(CalculatedItem)) { ci = new SLCalculatedItem(); ci.FromCalculatedItem((CalculatedItem)oxr.LoadCurrentElement()); this.CalculatedItems.Add(ci); } } } } if (pcd.CalculatedMembers != null) { SLCalculatedMember cm; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.CalculatedMembers)) { while (oxr.Read()) { if (oxr.ElementType == typeof(CalculatedMember)) { cm = new SLCalculatedMember(); cm.FromCalculatedMember((CalculatedMember)oxr.LoadCurrentElement()); this.CalculatedMembers.Add(cm); } } } } if (pcd.Dimensions != null) { SLDimension d; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.Dimensions)) { while (oxr.Read()) { if (oxr.ElementType == typeof(Dimension)) { d = new SLDimension(); d.FromDimension((Dimension)oxr.LoadCurrentElement()); this.Dimensions.Add(d); } } } } if (pcd.MeasureGroups != null) { SLMeasureGroup mg; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.MeasureGroups)) { while (oxr.Read()) { if (oxr.ElementType == typeof(MeasureGroup)) { mg = new SLMeasureGroup(); mg.FromMeasureGroup((MeasureGroup)oxr.LoadCurrentElement()); this.MeasureGroups.Add(mg); } } } } if (pcd.Maps != null) { SLMeasureDimensionMap mdm; using (OpenXmlReader oxr = OpenXmlReader.Create(pcd.Maps)) { while (oxr.Read()) { if (oxr.ElementType == typeof(MeasureDimensionMap)) { mdm = new SLMeasureDimensionMap(); mdm.FromMeasureDimensionMap((MeasureDimensionMap)oxr.LoadCurrentElement()); this.Maps.Add(mdm); } } } } }