Archive of ‘SQL server’ category

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 […]

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.   […]

Filtering Techniques for SQL Server 2008 R2 Reports

It is important to consider to filter report data based on user’s selection criteria as many databases contain large amounts of data. This post discusses different techniques to filter report data using report parameter concepts. By using the filters on reports, it greatly reduces the network traffic and helps the report to render efficiently.   […]

Importance of Data Warehousing and its Design

This post explains about what Data warehousing is and why we should care about it and then speaks about importance of using in enterprises and its design. It is important to understand the what data warehousing is all about, As a database developer you are likely to be involved with Data warehousing in one way […]