SQL Server Analysis Services - Creating Data Source Views
page 2 of 4
by Nidal Arabi
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 23787/ 415

Requirements

Before we can proceed, it is imperative to have Microsoft SQL Server 2005 or 2008 installed completely. Also note that we should install one of these editions:

·         SQL Server Standard Edition or Enterprise Editionà    you will need Windows Server as OS

·         SQL Server Developer Edition    à       You can use Windows XP as operating system.

If you do not want to buy one, you can simply get a trial edition. Please do not use the express edition because it does not work.

After installing the server, you need to download the two most famous databases for SQL server: Adventure Works and Adventure Works BI.

You can go to CodePlex (Microsoft Open Source Library) and download the SQL Server databases.

Please note that you have to respect two things to follow up the exercises:

·         You have to download the case insensitive database version.

·         You have to respect your SQL Server release you have installed.

·         Download the OLTP as well as the Data Warehouse database.

You can download the SQL Server 2005 version samples here:

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

You can download the SQL Server 2008 version sample here:

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=16040

After you download the databases please proceed with their installation by clicking the downloaded files.

Now we have to attach the databases installed. Proceed in starting the SQL Server Management studio from the start menu. Or, you can simply click Start à Run and type SQLWB if you are using version 2005 or SSMS if you are using SQL Server 2008.

In my article I will be using SQL Server 2008.


View Entire Article

User Comments

Title: Mr   
Name: Christopher Seewald
Date: 2008-12-03 5:19:14 AM
Comment:
Hi

I need to be able to access the datasource and datasource views outside of SSAS, via a .NET webservice, so that i can generate an XML file as a datasource for reporting (Silverlight, Infragistics etc)

Thanks

Chris
Title: Thanks   
Name: Pawan Kumar
Date: 2008-10-17 9:05:44 AM
Comment:
I really appreciate this site becuz i think it is most updated site according to newer technolozy.
Title: greate article   
Name: siddharth
Date: 2008-10-13 8:20:40 AM
Comment:
but how to fire dynamic inline query through .NET page on qube.






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2019 ASPAlliance.com  |  Page Processed at 2019-07-23 1:14:32 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search