Category Archives: Business Intelligence

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

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

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

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

Posted in Business Intelligence, Community, Modeling/Architecture | Leave a comment

April 2011 ITA BI Roundtable – So what can I do with this “BI” stuff anyway?

April 2011 ITA BI Roundtable  – So what can I do with this “BI” stuff anyway? Here are the slides from today’s session.  

Posted in Business Intelligence, Community, Modeling/Architecture | Leave a comment

Creating Dashboards WITHOUT SharePoint

As a business intelligence consultant, a frequent request I receive is to “create a dashboard”. One of the first things I do is verify that I understand what the client is actually asking for. Many times by “dashboard”, what they … Continue reading

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

Microsoft SQL Server 2008 R2 Update for Developers Training Course “Dependency Check Exception” “AuthorizationManager check failed”

Like many of us, it’s a constant struggle, er, — opportunity — for me to keep up-to-date on the latest and greatest techniques. One of the things that Microsoft and its partner ecosystem do particularly well is make plenty of … Continue reading

Posted in Business Intelligence, Microsoft | Leave a comment