I am building a cube with Analysis Management Objects.
My version of AS2005 is 9.0.852.0 ( SQLServer.2005 Beta 2, 20 July 2004 )
I'm able to create a database, a datasource, a datasourceview and
dimensions.
The dimensions are all parent-child.
When I try to create a cube, the Update method throws an Exception:
"error in the metadata manager. The MYCUBE cube has no measure groups".
I don't know why.
Follows my code.
Thanks
Valter

Cube mycube = mydb.Cubes.Add("MYCUBE");

mycube.Source = new DataSourceViewBinding(mydsv.Name);

CubeDimension cdim = mycube.Dimensions.Add("PRODUCTS");
cdim.DimensionID = "PRODUCTS"; //My parent-child dimension

MeasureGroup mg = mycube.MeasureGroups.Add("MeasureGroup1");

Measure m = mg.Measures.Add("Price");
m.AggregateFunction = AggregationFunction.AverageOfChildren;
m.DataType = MeasureDataType.Inherited;
m.Source = new DataItem( new ColumnBinding("Prezzi", "MEASURE_VALUE"),
OleDbType.Double ) ; // Database binding

RegularMeasureGroupDimension rmgd = mg.Dimensions.Add("PRODUCTS");
MeasureGroupAttribute mga = rmgd.Attributes.Add("PRODUCTS");
mga.KeyColumns.Add("Prezzi", "B_ENTITY_CODE", OleDbType.Integer);
mga.Type = MeasureGroupAttributeType.Granularity;

MeasureGroupAttribute mga2 = rmgd.Attributes.Add("PARENTKEY");
mga2.KeyColumns.Add( new DataItem( new InheritedBinding(),
OleDbType.Integer ));
mga2.Type = MeasureGroupAttributeType.Granularity;


mycube.Update();

--
Message posted via http://www.sqlmonster.com