This document focuses on the technical concepts and techniques we used to implement reports with SQL Server 2008 Reporting Services, using an Analysis Services cube as the data source. Providing strong customer service has helped this customer become the largest commercial bank in Thailand. Always looking...
Proper cube design, efficient multidimensional expressions (MDX), and sufficient hardware resources are critical to optimal performance of MDX queries issued against a SQL Server 2005 Analysis Services instance. This article lists the ten most common best practices that the Microsoft SQL Server development...
This paper provides the information about the available MDX query troubleshooting tools and demonstrates how to use the most common of these tools to identify and resolve MDX query performance bottlenecks with individual MDX queries There are a variety of things that you can do to improve the performance...
This paper introduces Microsoft SQL Server 2005 Report Builder and demonstrates how to build an end-to-end ad hoc reporting solution for enterprise customers using Report Builder and Microsoft SQL Server 2005 Analysis Services OLAP. We also highlight a few product limitations, as well as enterprise considerations...
Posted to
White Papers
by
Ashish Gilhotra
on
07-20-2010
Filed under:
Filed under: BI, SSRS, BRH, Business Intelligence, whitepapers, SSAS, #WHITEPAPERS, #BI, OLAP, #SSRS, #SSAS
This whitepaper provides optimization techniques for Analysis Services Distinct Count. Distinct count (such as unique visitor counts on a Web site) calculations provide valuable information but come with a number of performance challenges. This white paper describes tests that were performed to determine...
This paper compares SQL Azure Database with SQL Server in terms of logical administration vs. physical administration, provisioning, Transact-SQL support, data storage, SSIS, along with other features and capabilities. SQL Azure Database is a cloud-based relational database service from Microsoft. SQL...
This article provides information about the organizational challenges of implementing a master data management solution. Data governance and data stewardship provide a central role in the success of master data management within an organization. The right combination of people, processes, and policies...
This article provides a technology-centric view of master data management concepts, including possible implementation techniques. After reading this paper, information technology professionals should be able to accurately define the master data management problem for their organizations and have a vision...
This article helps business stakeholders understand how to determine the master data management needs of their organization. After reading this article, business stakeholders should be empowered to define a high level vision for implementing a master data management solution within their organization...
With Master Data Services, you can use business rules to create basic workflow solutions. You can automatically update and validate data and have e-mail notifications sent based on conditions you specify. Business rules in Master Data Services are intended to manage the most common workflow scenarios...
This best practices white paper discusses three many-to-many query performance optimization techniques, including how to implement them, and the performance testing results for each technique. Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model...
SQL Server 2008 R2 introduces new management tools to help improve IT efficiency and productivity. Investments in application and multi-server management will help organizations proactively manage database environments efficiently at scale through centralized visibility into resource utilization. Such...