Generate a cube in Standard Edition

I would like to know if there are some example of how to generate a cube by c#. I am using MS SQL Standard Edition. The AMOAdventureWorks example, just run in Enterprise edition, because of Semi-Additive measures.

Tks!!

Hello! In tools and samples you also have a standard edition version of the Adventure Works cube project

You can probably find it here: c:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project

HTH

Thomas Ivarsson

|||

Ok, i found it, but I want another thing...

I am working on a project that require me to build cubes programmatically i.e., using AMO object and C#. I am trying to find a sample that builds cubes using C# in Standard Edition.

Tks!!!

|||

I do not know if there is a difference in programatically creating a cube between Standard and Enterprise, but look here:

http://technet.microsoft.com/en-us/library/ms345091.aspx

|||

This example is perfect, I am using it, but when I try to execute it, or another example in SQL Standard Edition, the same error occurred in this line, problemas wuth the Semi-Additive Measures :

//--

cube.Update (UpdateOptions.ExpandFull);

//--

The Semi-Additive Measures feature of MS SQL Server 2005 is not supported in its Standard Edition SKU. How do solve this issue? Will I have to by Enterprise Edition SKU ?

This is documented here: http://www.microsoft.com/sql/editions/enterprise/comparison.mspx
Tks!

|||

I just figured this out.

Comment out this stuff in CreateCurrencyRatesMeasureGroup()

//average of children is not allowed.

//meas.AggregateFunction = AggregationFunction.AverageOfChildren;

//last non empty is not allowed.

//meas.AggregateFunction = AggregationFunction.LastNonEmpty;