MDX+SSRS #33 – Retrieve manager’s key and fully-qualified member name

A co-worker recently worked on a SSRS report and wanted to use a specific manager’s team for testing. The Manager...

MDX #32 – Vincent Rainardi’s blog

I came across Vincent Rainardi’s blog, and thought I’d share it with the readers.
Sherry Li and Tomislav’s 2012 MDX Cook...

SQL #52 – set statistics xml on

When tuning SQL queries, I find that I use the following three SET options quite often. 

set showplan_xml on
When showplan_xml...

SQL #51 – Timeout when updating a big table

A co-worker recently asked me why she would get timeout when updating a column in a big table. This column...

MDX+SSRS #31– Query Designer in SSRS only allows the Measures dimension in the first axis

In Chapter 1 of the book MDX with SSAS 2012 Cookbook, in the first recipe “Putting data on x and...

MDX #30 – Get The Book: MDX with SSAS 2012 Cookbook

MDX with SSAS 2012 Cookbook
by Sherry Li and Tomislav Piasevoli
Packt Publishing 2013
The book is now available in both paperback...

SQL #50–Deleting or updating data from a table of 20+ GB

I don’t have a definition of what is considered a large SQL table. I am pretty sure, however, that a...

MDX #29–Co-authored MDX with SSAS 2012 Cookbook

I have been absent from this blog for the last few months. For those who have noticed, I’d like to...

MDX #28– Time functions will not work with subquery

I had a post last month, MDX #25 – Slicer or Sub-Cube?, verifying that the query context did not change with...

MDX #27–Who are Ascendants?

Many function names in MDX are very family-friendly. Children, parent, ancestors, descendants, ascendants, are all terms we often use in...