Techbubbles

Posts Tagged ‘SQL Server 2008 Analysis Services’

SQL Server Reporting with Analysis Services

 
 

SQL Server Analysis Services is used to present the aggregated data to support analysis, ad-hoc reporting and decision making process. Technically CUBE is used in Analysis Services to build the aggregated data. Once it is build then you can easily navigate and produce reports for business analysis. This post discusses using analysis services in SQL […]

Installing AdventureWorks Analysis Services Database

 
 

This post discuss about configuring the AdventureWorks Analysis Services Database in SQL Server 2008 R2. You can download the sample databases from here. By default when you install the setup you would not see the analysis services database, you need to do some configurations to get it appear in analysis services database.

 
To deploy the analysis […]

Building a CUBE in SQL Server 2008

Creating the Project
To create a cube, we need to create a Analysis Services Project in Visual Studio. Start Visual Studio, select File, New Project. In project dialogue box, select Business Intelligence Projects from Project Types and select Analysis Services Project from right in the dialogue box.

Related Posts:Creating an Analysis Services Project in Visual […]