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 Server Reporting with MDX query builder. |  |
To download and configure the AW analysis services database read my previous post.
Create a Data Source
1. Create a data source for the AW20082 Analysis Services database in Report Builder 3.0 and select the SQL Server Analysis Services data provider from the drop down list.
Related Posts:
1 commentInstalling 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 services database perform the following steps:
1. Ensure that Analysis Services service account has got the access to the AdentureWorksDW2008R2 database.
2. Start the Business Intelligence Development Studio
Related Posts:
3 commentsBuilding 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:
No commentsCreating an Analysis Services Project in Visual Studio 2008
Microsoft SQL Server Analysis Services allows the developers to provide a unified access of data for analytical analysis and reporting. Developers can manage and aggregate the queries from multiple subject areas. This can be achieved by creating a cube in Visual Studio 2008. This post defines and explains the terms used in creating an analysis project in VS 2008.
Related Posts:
No comments
