Tag: MDX

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

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…...

This content is for Pro, Pro Member, Standard and Standard Member 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, Standard and Standard Member 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, Standard and Standard Member members only.
Log In Register