William Pearson

This article focuses upon Pie charts, and extends the examination of Reporting Services charts for Analysis Services data sources that we began in an earlier article of my MSSQL Server Reporting Services series, Introducing Reporting Services Charts for Analysis Services. In that article we summarized the many different chart (or chart data region) types that […]

This article continues the overview of Attribute Relationships in Analysis Services begun in Introduction to Attribute Relationships in MSSQL Server Analysis Services. Both this article and its predecessor extend the examination of the dimensional model that we began in Dimensional Model Components: Dimensions Parts I and II. After taking up various additional components of the […]

This month, we will examine the DIMENSION_UNIQUE_NAME intrinsic member property. Once we have briefly introduced DIMENSION_UNIQUE_NAME, we will employ the member property, in a hands-on practice session, to meet example business needs for a hypothetical client. The primary focus of this article, like the other articles of this series, is to provide hands-on application of […]

This article focuses upon simple Bar charts, and extends the examination of Reporting Services charts for Analysis Services data sources that we began in Introducing Reporting Services Charts for Analysis Services. In that article we summarized the many different chart (or chart data region) types that are available, and looked ahead to individual articles surrounding […]

This article introduces Attribute Relationships in Analysis Services, and extends the examination of the dimensional model that we began in Dimensional Model Components: Dimensions Parts I and II. Here, we will focus upon the purpose of attribute relationships, which define the possible associations between attributes. Moreover, we will discuss why these relationships are important, and […]

This article focuses upon Column charts, and extends the examination of Reporting Services charts for Analysis Services data sources that we began in an earlier article of my MSSQL Server Reporting Services series, Introducing Reporting Services Charts for Analysis Services. In that article we summarized the many different chart (or chart data region) types that […]

This month, we will conclude the examination of the BottomCount() function that we began in the two previous articles of the MDX Essentials series, Basic Set Functions: The BottomCount() Function and Combine BottomCount() with Other MDX Functions to Add Sophistication. We will explore another somewhat more sophisticated use of BottomCount(), in combination with the Descendants(), […]

Discover, through a hands-on practice exercise, a more sophisticated business use for the MDX BottomCount() function, in combination with the Generate(), Descendants(), Ancestor() and other functions we have explored within our series. Join BI Architect Bill Pearson in this, the second part, of an extended examination of the MDX BottomCount() function. BottomCount, BottomCount, Generate, Descendant, […]

Synopsis: Learn how the appropriate use of attribute member Value can support the selection and delivery of enterprise data in a more focused and consumer-friendly manner. Join BI Architect Bill Pearson in a hands-on examination of the attribute member Value property and its underlying settings in Analysis Services. Introduction In Dimensional Model Components: Dimensions Parts […]

This month, I introduce a group of several articles surrounding Reporting Services charts (or chart data regions) based upon Analysis Services data sources. These related articles, interspersed among other topics within my MSSQL Server Reporting Services series over time, will demonstrate how to create chart reports of various types, focusing upon Analysis Services data sources, […]

About the Series … This article is a member of the series Introduction to MSSQL Server Analysis Services. The series is designed to provide hands-on application of the fundamentals of MS SQL Server Analysis Services (“Analysis Services”), with each installment progressively presenting features and techniques designed to meet specific real-world needs. For more information on […]

About the Series … This article is a member of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs. For more information about the series in general, as well as the […]