Author : Vince Napoli

To MDM or not to MDM, that is the question…or is it?

Oct 8, 2018 | Vince Napoli

To MDM or not to MDM, that is the question. Well, actually it’s not the question. And really, it’s not a question at all. Rather, it’s a statement. And that statement is: “Pay me now,…

Using Computed Column as a Primary Key

Jul 18, 2018 | Vince Napoli

Challenge As data-platform professionals, we are challenged to come up with unique answers to technical situations on a regular basis. So, keeping a backlog of techniques, tips and tricks to address these situations is a…

The Important Role of Metadata in Business Intelligence

Apr 4, 2018 | Vince Napoli

Ever try to put something together without reading the instructions? We’ve all done it, and then we had to pull the thing apart and read the instructions to figure out where we went wrong before putting it back together. Metadata is a piece of the overall instruction set of a BI…

Creating query aliases in TSQL and MDX

Aug 13, 2015 | Vince Napoli

I recently went through an activity for a project where I needed to create aliases for MDX queries I was building.   The driver was the requirement for parameter selection in an SSRS report that required different…

Connecting to SQL Server Analysis Services (SSAS) through Windows firewall

Jul 16, 2015 | Vince Napoli

Connecting to SQL Server Analysis Services (SSAS) through Windows firewall.     I found myself installing and setting up a SSAS multidimensional default instance on a Windows 2012 R2 Server and created a test project…

Gotcha on named instance migration for SSRS

Mar 31, 2015 | Vince Napoli

Gotcha on named instance migration for SSRS  You have to migrate a SSRS named instance to a new server in parallel with the existing SSRS Server.    Not an uncommon scenario when in production and bringing…

Fix to SSRS Export to Excel error

Mar 14, 2014 | Vince Napoli

A recent client was troubled by an error message from Excel 2013, stating the file contained unreadable content, when trying to open Excel files that were exported directly from SSRS 2012 reports.   The reports were built off…

.NET related issue with DQS Client for 2012

Mar 4, 2014 | Vince Napoli

In pursuing an error a colleague of mine was having with installing Data Quality Services for SQL Server 2012,  I decided to test out my own installation of DQS which had not been used in…

Apply a SET as an exclusion filter to a MDX query in SSRS

Feb 20, 2014 | Vince Napoli

Ever have to remove a set of data from an MDX query when running a report?    Ever have SSRS and SSMS then reject its use, after getting the set defined in the cube to allow…

Group_Concat functionality for SQL Server

Dec 27, 2013 | Vince Napoli

An interesting request came in a couple weeks ago in querying data from a SQL Server 2012 database for a SSRS report.   How to roll up data to a single row, but, for a given column…