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.
No comments:
Post a Comment