SQL Server Analysis Services - Creating Data Source Views: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
SQL Server Analysis Services - Creating Data Source Views

page 1 of 4

Published: 06 Oct 2008

Abstract
Now it is time to go practical in our business intelligence project as we have provided enough concepts. The first step in creating BI projects is to provide data sources to build your model out of. In this article, Nidal examines the different aspects of creating data source views using SQL Server 2008. After providing a short introduction, he outlines the procedure involved in a series of steps with the help of relevant screenshots.

by Nidal Arabi
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 2652/ 247

Article Contents:

Introduction

There are several ways to implement data sources and you can even build your databases from text files that are coming to your system. It is important to note here that you can use the SQL Server Integration Services (SSIS) provided to simplify your life by loading data from different databases and other data sources into one single database instance of SQL Server. It is also important to note that the text interface provides a great deal of flexibility if you are dealing with heterogeneous systems to get data out. Please remember that SSIS is outside the scope of this series. In our case, we are going to deal simply with an SQL Server database as our source.

View Entire Article

(Page 2) »

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 1 and 4 and type the answer here:

User Comments

Title: Thanks
Name: Pawan Kumar
Date: 10/17/2008 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: 10/13/2008 8:20:40 AM
Comment:
but how to fire dynamic inline query through .NET page on qube.