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,...
Tag: OLAP
Troubleshooting SQL Server 2012 Analysis Services problems
Troubleshooting SQL Server 2012 Analysis Services problems If you have problems with SQL Server 2012 Analysis Services, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 Analysis Services bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...
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,...
Learning SSAS: Part VI – Creating Hierarchies
Learning SSAS: Part VI – Creating Hierarchies Hello and welcome to the latest article in the Learning SQL Server Analysis Services series. Till now you must be familiar with a lot of things in SQL Server Analysis Services. In the previous articles of this series I have shown you how to create dimensions, facts and more importantly a cube using...
Learning SSAS: Part V – Creating Dimensions
Learning SSAS: Part V – Creating Dimensions Hello and welcome to the fifth part of the series. In the previous articles I showed you how to create an SSAS cube and build and deploy it to a target Analysis Server. In the process you should have learnt how to create Data Sources, Data Source Views, Diagrams and Calculated Columns etc....
Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 1)
Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 1) Author: Basit A. Farooq Editor’s Note: This is the two part article series on designing and implementing online analytical processing (OLAP) architecture. In this article series, I will first discuss how to design and implement logical multidimensional solution architecture. After that, I will explain the design considerations for online...
Learning SSAS: Part III- Building Cubes
Learning SSAS: Part III- Building Cubes Hello and welcome to the third part of this series dedicated to learning SQL Server Analysis Services. In the first article I talked about the basics of dimensional modeling and business intelligence. Also, the reader was acquainted with the jargon associated with data warehousing. In the second article the reader learnt few things about...
Troubleshooting problems with Analysis Services in SQL Server 2008 R2
Troubleshooting problems with Analysis Services in SQL Server 2008 R2 If you have problems with Analysis Services in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 Analysis Services bugs were fixed in SQL Server service packs, you should install the...