-
Archives
- February 2018
- December 2017
- February 2013
- January 2013
- December 2012
- March 2012
- August 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- November 2010
- October 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- August 2009
- July 2009
- May 2009
-
Meta
Author Archives: Tom Huguelet
DAX Duration Measure in Days, Hours, Minutes, Seconds
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
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
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
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
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
Backing up SSAS – Yes or No?
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
Agile and Business Intelligence
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
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
Join me for a Webinar: “Ad-hoc Scenario Analysis Using Existing Infrastructure”
Tom Huguelet Please join me Tuesday for “Ad-hoc Scenario Analysis Using Existing Infrastructure” April 19, 2011 12:00 p.m. ET / 9:00 a.m. PT http://bit.ly/gpyXpr Hosted by SQL Server Magazine, sponsored by Tableau Software. I really had fun creating this webinar. Gave … Continue reading