How can we create cubs in sql server 2005 BI

How can we create cubs in sql server 2005 BI

Start the BI-Developer Studio (Programs/SQL Server 2005).

Choose File/New Project

Choose Analysis Services 9 project.

After these steps you normally start with the dimensions.

Books On Line have tutorials for this.

This link can also help you:

http://www.databasejournal.com/features/mssql/article.php/3553971

HTH

Thomas Ivarsson

|||

Can you send me the notes on this.

this link http://www.databasejournal.com/features/mssql/article.php/3553971 shows in SQL Server 2000 Analysis Services but i need SQL Server 2005 Analysis Services

Can you help me on this........PLZ.....

|||

The link is correct. Data source views are a feature only in Analysis Services 2005.

Here is the link to all articles about Analysis Services.

http://www.databasejournal.com/features/article.php/3593466

Look for the writer William E. Pearson

Here is the link to Books On Line Analysis Services 2005 tutorials:

http://msdn2.microsoft.com/en-us/library/ms170208.aspx

Regards

Thomas Ivarsson