DDL of an existing cube

Hi!

Is there a way to get the DDL of a cube created with the AS wizard.

Thinks and regards.

You can get the DDL of any AS object, including a cube, very easily by connecting to your server in SQL Server Management Studio, right-clicking on the object and selecting one of the items under the 'Script <object> as' menu item.

HTH,

Chris

|||

Also, if you do not have the cube already deployed to AS2005, but you only have the BI project on which you created a cube with the wizard, you can right click on the cube item (in Visual Studio) and use 'View Code' option to see the XML.

Adrian Dumitrascu.

|||

Hi

I think i've to install a full version of SQL Server 2k to get access to SQL Server Management Studio.

Actually i've installed AS only and i'm using an Oracle DB as DWH.

TVM Chris for reply

Regards

|||

Hi

How Can i browse AS cubes within Visual Studio ( 6 ? .Net ? 2005?)

PS i'm using SQL2K AS

TVM for reply Adrian

Regards

|||

If you have Analysis Services 2000, then our suggestions won't work. Analysis Services 2000 doesn't have DDL scripts as Analysis Services 2005.

SQL Management Studio only works with AS2005, but not AS2000 (Analysis Manager remains the admin client for AS2000).

The same for BI projects (that you can create and edit in Visual Studio): they are a feature of AS2005 only. So there isn't a feature out of the box to browse AS2000 from Visual Studio.

Adrian Dumitrascu.

DDL Changes breaks cubes

Hi,

Lately I had to increase the size of a table varchar column.

This column is used in a cube dimension attribute.

After the change, cube processing ended-up in error.

I had to first refresh the dataview and then go manually change the KeyColumns Datasize property to increase it as well.

Is there a better way? I find this very dangerous.
As a minimum, a dependency check should include cubes using that metadata.

I notticed the same type of problems on the SSIS sides, metadata becomes out of synch. This is not a show stopper but these are missing link in the dependency food chain.

Sub-systems are not integrated, they are in a vacuum. A little less than with 2000 but still in a vacuum.

Philippe

Very valuable observation.

This is something we are going to take a look at for the next version :)

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.