Author Archives: Tom Huguelet

You have chosen wisely

Posted on August 12, 2020 by Tom Huguelet
Posted in Uncategorized | Leave a comment

DAX Duration Measure in Days, Hours, Minutes, Seconds

Posted on February 13, 2018 by Tom Huguelet

Credit where credit is due. This is an enhancement of the technique originally posted here by @konstantinos and @smoupre. A client needed a duration expressed in this format: 2 days, 05:03:52 In other words, Whenever the duration exceeds 86,400 seconds, … Continue reading →

Posted in Analysis Services, Business Intelligence, DAX, SQL Server | Leave a comment

Welcome (back) to my new (old) site

Posted on December 14, 2017 by Tom Huguelet

Somewhere around 2013 I was so awed by Microsoft’s Office 365 offering that I went “all-in” and moved my website to the then-nascent platform. Earlier this year the powers-that-be “sunsetted” the public-facing website portion of that product, so here we … Continue reading →

Posted in Community, Microsoft, Uncategorized | Leave a comment

MDX for Date Formatting

Posted on February 13, 2013 by Tom Huguelet

This is a simple MDX snippet, but it comes up often enough that I think it’s worth a blog entry. A frequent question that comes up is how to format dates for display in MDX, especially in the parameter boxes … Continue reading →

Posted in Uncategorized | Leave a comment

I am positive that measure is not negative – Weird Analysis Services Cube Behavior

Posted on January 10, 2013 by Tom Huguelet

I ran into a situation recently that had me stumped for a bit, and there didn’t seem to be any other posts about this when I searched. I was working with a cube containing a very straightforward measure. This was … Continue reading →

Posted in Analysis Services, Business Intelligence, MDX, OLAP, SQL Server | Leave a comment

Simple way to test connectivity or compose OLEDB connection strings

Posted on December 15, 2012 by Tom Huguelet

This tip has been around a while, but I still run into developers who don’t know it, so it’s worth a post. If you ever need to test connectivity or compose a valid OLEDB connection string, try this: Create an empty … Continue reading →

Posted in Business Intelligence, Microsoft, SQL Server | Leave a comment

Windows 8 Hot-Keys

Posted on March 12, 2012 by Tom Huguelet

One of the best things you can do to get comfortable with a new OS is take some time to learn the keyboard shortcuts. Here are the Windows 8 Hot-Keys Windows logo key+ C Opens Charms bar Windows logo key+, Temporarily … Continue reading →

Posted in Microsoft, Operating Systems, Software | Leave a comment

Backing up SSAS – Yes or No?

Posted on August 22, 2011 by Tom Huguelet

A question came up recently about how to back up SSAS. The vast majority of my clients do not back up SSAS. This isn’t appropropriate for all deployments, though. Here’s the thread: This runs contrary to customary SQL server practice, … Continue reading →

Posted in Analysis Services, Business Intelligence, Microsoft, SQL Server | Leave a comment

Agile and Business Intelligence

Posted on August 15, 2011 by Tom Huguelet

I had a client ask me about some of the techniques we are currently using, “Tom, Can you send me authors, book titles and/or links outlining agile development (Story conferences, sprints, scrums, etc…).” This was my response: Here is the … Continue reading →

Posted in Business Intelligence | Leave a comment

Microsoft on SSAS and BI Vision Roadmap

Posted on May 17, 2011 by Tom Huguelet

A lot of this has been floating around various blogs and press releases, but here’s a very succinct synopsis of where MS is planning to go with Microsoft BI and the BI Semantic Model.

Posted in Analysis Services, Business Intelligence, MDX, SQL Server | Leave a comment