public Cube(CubeDef cubeDef)
        {
            Name          = cubeDef.Name;
            DimensionList = new List <Models.Dimension>();

            foreach (Microsoft.AnalysisServices.AdomdClient.Dimension dimension in cubeDef.Dimensions)
            {
                Models.Dimension currentDimension = new Models.Dimension(dimension);

                DimensionList.Add(currentDimension);
            }
        }
Example #2
0
        public string GetCubeDimensionById(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];

                List <string> dimensionList = new List <string>();

                Microsoft.AnalysisServices.AdomdClient.Dimension serverDimension = cubeDef.Dimensions[dimensionId];

                Models.Dimension dimension = new Models.Dimension(serverDimension);

                return(JsonConvert.SerializeObject(dimension, Formatting.Indented));
            }
        }