Tag: Dimension

SQL Server

Troubleshooting SQL Server 2014 Analysis Services problems (Part 3)

Troubleshooting SQL Server 2014 Analysis Services problems (Part 3) If you have problems with SQL Server 2014 Analysis Services (SSAS 2014), review this troubleshooting checklist to find potential solutions. 1. If you use SSAS 2014. When you run a Multidimensional Expressions (MDX) query against a Many-To-Many dimension, the memory consumption increases very quickly, and surpasses HardMemoryLimit after some time. In […]

SQL Server

Troubleshooting SQL Server 2014 Analysis Services problems (Part 2)

Troubleshooting SQL Server 2014 Analysis Services problems (Part 2) If you have problems with SQL Server 2014 Analysis Services (SSAS 2014), review this troubleshooting checklist to find potential solutions. 1. The error occurs when you process a partition in a measure group in SQL Server 2014 Analysis Services. This is the error message text: “Errors in the high-level relational engine. […]

SQL Server

Troubleshooting SQL Server 2014 Analysis Services problems (Part 1)

Troubleshooting SQL Server 2014 Analysis Services problems (Part 1) If you have problems with SQL Server 2014 Analysis Services (SSAS 2014), review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many SQL Server 2014 Analysis Services bugs were fixed in SQL Server service packs, you should install the latest SQL Server […]

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.
Register
Already a member? Log in here