On the right pane within the Solution Explorer windows, click on the Data Sources node. The first thing to do in a MS SQL Server Analysis Services database project is to create data source objects.
#Sql server 2008 r2 business intelligence development studio how to
How to Create Data Source in OLAP Database Here are the steps to create Analysis Services OLAP database project in Microsoft SQL Server 2008 R2 instance using the SQL Server Business Intelligence Development Studio (BIDS). Please note that the basic steps of creating a Analysis Services project, creating dimensions and OLAP cubes within the SSAS projects are all same in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2. In this OLAP tutorial, I want to demonstrate how to create OLAP cubes in SQL Server Analysis Services 2008 R2. With each new SQL Server version, the Business Intelligence platform for BI developers has developed much in order to provide mature solutions to the requirements of customers.Īlthough it was possible to create OLAP cubes in SQL Server 2000, with the new CTP version release of SQL Server 2011, creating OLAP cubes, Data Mining analysis, serving Analysis Services data using Reporting Services reports is much more easier. SQL Server Business Intelligence developers can create Analysis Services and Integration Services projects as well as Reporting Services projects using SQL Server Business Intelligence Development Studio aka BIDS. How to Create OLAP Cube using Business Intelligence Development Studio
0 kommentar(er)
