A simple conceit vs. questions left unasked

Here’s a fun mental exercise – on the one hand, we have the “everyone is lost but me” syndrome, where someone will charge off on a course of action, despite many many warnings about the perilous nature of his quest, until he runs smack dab into that windmill. And yet we have “there is no…

1

Dimension Security in SQL Server Analysis Services

I know, the mind boggles – a developer writing about security… While I was doing the research for this, I was startled by the number of articles on this topic that immediately talk about using MDX queries for dimension security. While MDX queries offer powerful fine-tuning capabilities for restricting access to data in Analysis Services,…

0

This year’s hammer – voice prompts

“When all you have is a hammer, everything looks like a nail” I use this quote a lot to warn against the tendency we have to overimplement new technologies and solutions. Even as I go through InfoPath and BI solutions, I will warn that while InfoPath is a forms solution, it’s not the solution to…

1

Scorecards – SharePoint, SQL Server, or PerformancePoint?

A few years ago, if you asked Microsoft how to build a scorecard, they may have shrugged. Then we released the “Business Scorecard Accelerator” – a free technology mainly designed to showcase SQL Server Analysis Services. It was so popular that Microsoft made a product out of it – Business Scorecard Manager 2005. While BSM…

5