MDX # 39 – Find Default Measure using MDX Query

In Chapter 1 of our book, MDX with SSAS 2012, we’ve devoted a section “Setting a default member of a...

MDX # 40 – CROSS JOIN does not return Cartesian product of two hierarchies from the same dimension

Correction
4/25/2014
Thanks to Chris Webb’s comment (see the comment section). I am making a correction on this blog.
The title of this...

MDX+SSAS #38–CALL ASSP.DMV() to document cubes in SSAS 2005

While you are writing and testing MDX queries in Microsoft SQL Server management Studio (SSMS), how many times you find...

MDX+SSAS #37–Ignore unrelated dimension or not

In Adventure Works cube 2008 or 2012, in the Dimension Usage tab, you will see that many intercepts of measure...

SSIS #116–What is the variable value at runtime?

Using variables in SSIS packages can make your ETL process more dynamic and respond to different scenarios during runtime.
Not...

SSRS #73 – Marlon Ribunal and Mickey Stuewe’s New Book: Reporting Services 2012 Blueprints

The book’s link is here, SQL Server 2012 Reporting Services Blueprints.
This book is a step-by-step, task-driven tutorial that goes straight...

2013 in review

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:
The Louvre Museum has 8.5 million...

MDX #36 – Many thanks to the reviewers

In this blog, I’d like to give special thanks to the people below who have taken time to write reviews...

MDX #35 – Properties() function with TYPED flag

Reader Query
My publisher recently forwarded me a question from a reader about the “Using the PROPERTIES() function to retrieve data...

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