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): 20975/ 33

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

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-2024 ASPAlliance.com  |  Page Processed at 2024-03-19 2:42:59 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search