 Print
 Add To Favorites
 Email To Friend
 Rate This Article
|
SQL Server Analysis Services - Creating Data Source Views
|
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):
21452/
31
|
|
|
|
| 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.
|
|
|
|
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.
|
|
|
|
|
|
