William Pearson

This article continues my exploration of attribute discretization, a capability in Analysis Services that allows us to group members of an attribute into a number of member groups. Our concentration here will be to get some exposure to the pre-defined “Clustered” discretization method, one of three such pre-defined methods supported by Analysis Services, through hands-on […]

This article focuses upon Stacked 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 continues my exploration of attribute discretization, a capability in Analysis Services that allows us to group members of an attribute into a number of member groups. Our concentration here will be to get some exposure to the pre-defined “Equal Areas” discretization method, one of three such pre-defined methods supported by Analysis Services, through […]

This article focuses upon Line 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 Discretization in Analysis Services begun in Introduction to Attribute Discretization. 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 dimensional model in subsequent articles, […]

This month, we will examine the LEVEL_NUMBER intrinsic member property. Once we have briefly introduced LEVEL_NUMBER, 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 Stacked 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 […]

This article introduces attribute discretization 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 introduce attribute discretization, focusing upon the purpose and benefits of this capability, which, as we shall see, affords us a means of creating a […]

This article examines additional capabilities we can employ in creating advanced Pie charts with Reporting Services. It extends the examination of simple Pie charts that we undertook in Simple Pie Chart for Analysis Services Data, and focuses on the creation of a somewhat more sophisticated Pie chart than we created in the earlier article, using […]

This month, we will examine the LEVEL_UNIQUE_NAME intrinsic member property. Once we have briefly introduced LEVEL_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 continues the overview of Attribute Relationships in Analysis Services, which we began in Introduction to Attribute Relationships in MSSQL Server Analysis Services, and continued in Attribute Relationships: Settings and Properties. Both this article and its predecessor extend the examination of the dimensional model that we began in Dimensional Model Components: Dimensions Parts I […]

This month, we will examine the HIERARCHY_UNIQUE_NAME intrinsic member property. Once we have briefly introduced HIERARCHY_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 […]