Author: William Pearson

Pro Members SQL Server Standard Members

Attribute Discretization Part I: Introduction and Overview

Attribute Discretization Part I: Introduction and Overview This is the charter article of the SSWUG Elemental SQL Server Analysis Services Multidimensional 2012 series. – In this and subsequent parts of the article, we will introduce attribute discretization in SQL Server Analysis Services (“SSAS”) – Multidimensional, focusing upon the purpose and benefits of this capability, which, as we shall see, affords…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 4

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 4 After gaining an overview and performing the preparation for the four-parts of this article in Part 1, we introduced the COUNTROWS() function in Part 2. Then, in Part 3, we explored another DAX function, FILTER(). As we shall see in this, Part 4, of our…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 3

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 3 In the charter article of this series, DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, we introduced the powerful PowerPivot / DAX combination, noting that this add-on to Microsoft Office Excel 2010 (embedded, and only needing to be enabled,…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 2

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 2 In the charter article of this series, DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, we introduced the powerful PowerPivot / DAX combination, noting that this add-on to Microsoft Office Excel 2010 (embedded, and only needing to be enabled,…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 1

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 1 In the charter article of this series, DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, we introduced the powerful PowerPivot / DAX combination, noting that this add-on to Microsoft Office Excel 2010 (embedded, and only needing to be enabled,…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, Pt. 2

DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, Pt. 2 This is the second article of a new, SSWUG – exclusive series, DAX and PowerPivot Essentials. As we noted in Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, Pt. 1,the primary focus of this series will be an introduction to PowerPivot for…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, Pt. 1

DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, Pt. 1 This is the first article of a new, SSWUG – exclusive series, DAX and PowerPivot Essentials. The primary focus of this series will be an introduction to PowerPivot for Excel and the Data Analysis eXpressions (“DAX”) language. The series is designed to provide hands-on…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 2

Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 2 In this, the second of a three-part article focusing upon the PeriodsToDate() and OpeningPeriod() time series functions, we will continue to expose member and set functions that we can use to perform analysis within the context of time. As we discussed in Part 1, many business requirements revolve around…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Elemental MDX: MDX Time Series Functions: ClosingPeriod(), LastPeriods() and ParallelPeriod(), Pt. 1

Elemental MDX: MDX Time Series Functions: ClosingPeriod(), LastPeriods() and ParallelPeriod(), Pt. 1 In this three-part article, we will introduce the ClosingPeriod(), LastPeriods() and ParallelPeriod() time series functions, continuing our recent forays into functions that we can exploit to perform analysis within the context of time. This article follows an examination of a couple of other such time series functions in…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 3

Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 3 In this, the third of a three-part article focusing upon the PeriodsToDate() and OpeningPeriod() time series functions, we will continue to expose functions that we can use to perform analysis within the context of time. As we discussed in Part 1, many business requirements revolve around theperformance of analysis…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register