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 CubeDef Find(string index) { if (_obj != null) { AsAdomdClient.CubeDef obj = _obj.Find(index); return(obj == null ? null : new CubeDef(obj)); } else { ExcelAdoMdConnections.ReturnDelegate <CubeDef> f = delegate { ExcelAdomdClient.CubeDef obj = _objExcel.Find(index); return(obj == null ? null : new CubeDef(obj)); }; return(f()); } }
internal Dimension(AdomdConnection connection, DataRow dimensionRow, CubeDef parentCube, string catalog, string sessionId) { this.baseData = new BaseObjectData(connection, true, null, dimensionRow, parentCube, null, catalog, sessionId); }
internal MeasureCollection(AdomdConnection connection, CubeDef parentCube) { this.measureCollectionInternal = new MeasureCollectionInternal(connection, parentCube); }
internal NamedSetCollection(AdomdConnection connection, CubeDef parentCube) { this.namedSetCollectionInternal = new NamedSetCollectionInternal(connection, parentCube); }
internal static Dimension GetDimensionByRow(AdomdConnection connection, DataRow row, CubeDef parentCube, string catalog, string sessionId) { Dimension dimension; if (row[0] is DBNull) { dimension = new Dimension(connection, row, parentCube, catalog, sessionId); row[0] = dimension; } else { dimension = (Dimension)row[0]; } return(dimension); }
internal DimensionCollectionInternal(AdomdConnection connection, CubeDef parentCube) : base(connection, InternalObjectType.InternalTypeDimension, parentCube.metadataCache) { this.parentCube = parentCube; }
internal DimensionCollection(AdomdConnection connection, CubeDef parentCube) { this.dimensionCollectionInternal = new DimensionCollectionInternal(connection, parentCube); }
internal KpiCollection(AdomdConnection connection, CubeDef parentCube) { this.kpiCollectionInternal = new KpiCollectionInternal(connection, parentCube); }
internal static Measure GetMeasureByRow(AdomdConnection connection, DataRow row, CubeDef parentCube, string catalog, string sessionId) { Measure measure; if (row[0] is DBNull) { measure = new Measure(connection, row, parentCube, catalog, sessionId); row[0] = measure; } else { measure = (Measure)row[0]; } return(measure); }
internal MeasureCollectionInternal(AdomdConnection connection, CubeDef parentCube) : base(connection, InternalObjectType.InternalTypeMeasure, parentCube.metadataCache) { this.parentCube = parentCube; }
public CubeDef(AsAdomdClient.CubeDef obj) { _obj = obj; }
internal static NamedSet GetNamedSetByRow(AdomdConnection connection, DataRow row, CubeDef parentCube, string catalog, string sessionId) { NamedSet namedSet; if (row[0] is DBNull) { namedSet = new NamedSet(connection, row, parentCube, catalog, sessionId); row[0] = namedSet; } else { namedSet = (NamedSet)row[0]; } return(namedSet); }
internal NamedSetCollectionInternal(AdomdConnection connection, CubeDef parentCube) : base(connection, InternalObjectType.InternalTypeNamedSet, parentCube.metadataCache) { this.parentCube = parentCube; }
public static string GetMemberQuery(string memberSet, string dimensionPropertiesClause, CubeDef cube) { string text = AdomdUtils.Enquote(cube.Name, "[", "]"); return(string.Format(CultureInfo.InvariantCulture, "SELECT {0} {1} ON 0, {{}} ON 1 FROM {2}", new object[] { memberSet, dimensionPropertiesClause, text })); }