public string GetHierarchies(int cubeId, int dimensionId) { using (AdomdConnection mdConn = new AdomdConnection()) { mdConn.ConnectionString = "provider=msolap;Data Source=V1LGORPC\\ASMAIN;initial catalog=AdventureWorksDW2014Multidimensional-EE;"; mdConn.Open(); List <CubeDef> realCubeList = Utilities.Utilities.GetRealCubeList(mdConn.Cubes); CubeDef cubeDef = realCubeList[cubeId]; Microsoft.AnalysisServices.AdomdClient.Dimension dimension = cubeDef.Dimensions[dimensionId]; List <Models.Hierarchy> hierarchyList = new List <Models.Hierarchy>(); foreach (Microsoft.AnalysisServices.AdomdClient.Hierarchy hierarchy in dimension.Hierarchies) { Models.Hierarchy newHierarchy = new Models.Hierarchy(hierarchy); hierarchyList.Add(newHierarchy); } return(JsonConvert.SerializeObject(hierarchyList, Formatting.Indented)); } }
public Dimension(Microsoft.AnalysisServices.AdomdClient.Dimension serverDimension) { Name = serverDimension.Name; HierarchyList = new List <Models.Hierarchy>(); foreach (Microsoft.AnalysisServices.AdomdClient.Hierarchy hierarchy in serverDimension.Hierarchies) { Models.Hierarchy newHierarchy = new Models.Hierarchy(hierarchy); HierarchyList.Add(newHierarchy); } }