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 void CreateAdomdMining()
{
string sConnString = "Data Source=" + sServer + "; Initial Catalog=" + sCatalog;
Microsoft.AnalysisServices.AdomdClient.AdomdConnection olapConn = new AdomdConnection(sConnString);
try
{
olapConn.Open();
}
catch (Exception e)
{
Console.WriteLine(e.StackTrace);
}
Microsoft.AnalysisServices.AdomdClient.CubeDef objCube = olapConn.Cubes["Adventure Works"];
Microsoft.AnalysisServices.AdomdClient.Dimension myDim = objCube.Dimensions["Customer"];
//Microsoft.AnalysisServices.MiningStructure myStructure = db.MiningStructures.Add("MarketBasket", "MarketBasket");
//myStructure.Source = new CubeDimensionBinding(".", objCube.Name, myDim.Name);
Microsoft.AnalysisServices.AdomdClient.Hierarchy basketAttribute;
Microsoft.AnalysisServices.AdomdClient.Hierarchy itemAttribute;
basketAttribute = objCube.Dimensions["Customer"].AttributeHierarchies["Customer"];
itemAttribute = objCube.Dimensions["Product"].AttributeHierarchies["Product"];
/* DEMO CODE
*
* MiningStructure ms = db.MiningStructures.Add("CubeStruct");
*
* string dataSourceId = ".";
* string cubeId = "Adventure Works";
* string dimensionId = "Customer";
* ms.Source = new CubeDimensionBinding(dataSourceId, cubeId, dimensionId);
*
* // Add a key column
* ScalarMiningStructureColumn keyColumn = ms.Columns.Add("Customer", "Customer");
* keyColumn.IsKey = true;
* keyColumn.Type = MiningStructureColumnTypes.Text;
* keyColumn.Content = MiningStructureColumnContents.Key;
* string keyAttributeId = "Customer";
* keyColumn.Source = new CubeAttributeBinding(myCube.ID, myDimension.ID, keyAttributeId, AttributeBindingType.All);
*
* // Add two scalar columns
* ScalarMiningStructureColumn column = ms.Columns.Add("Commute Distance", "Commute Distance");
* column.Type = MiningStructureColumnTypes.Text;
* column.Content = MiningStructureColumnContents.Discrete;
* string attributeId = "Commute Distance";
* column.Source = new CubeAttributeBinding(myCube.ID, myDimension.ID, attributeId, AttributeBindingType.All);
*
* column = ms.Columns.Add("Home Owner", "Home Owner");
* column.Type = MiningStructureColumnTypes.Text;
* column.Content = MiningStructureColumnContents.Discrete;
* attributeId = "Home Owner";
* column.Source = new CubeAttributeBinding(myCube.ID, myDimension.ID, attributeId, AttributeBindingType.All);
* ms.Update();
*
*/
}
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);
}
}
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));
}
}
public Dimension(AsAdomdClient.Dimension obj)
{
_obj = obj;
}
