Thursday
Apr092009

Ongoing De-Evolution of Data Management

It's bad enough that we've had XML foisted on us. It's become a regular occurrence that Microsoft foists some new, lame data store, e.g. SharePoint lists. The final salt in the wound are the self-anointed experts who applaud these abysmal technologies.

Click to read more ...

Wednesday
Oct292008

Drillthrough

It's rare that a cube will contain transaction details. So once a user drills down to the bottom of a cube, it's common to want to see the transactions that comprise a given value. That's what drillthrough is for, or at least that was the case in the old days.

Click to read more ...

Saturday
Aug022008

MDX Class Schedule Fall '08

Public classes offered through SQLSoft:

  • Sept 25  Portland, OR

  • Nov 6     Portland, OR

To arrange for private deliveries, contact me here.

Monday
May052008

MDX Class Schedule Summer '08

Public classes offered through SQLSoft:

  • June 12  Seattle, WA

  • July 24   Seattle, WA

  • July 31   Portland, OR

  • Sept 11  Seattle, WA

To arrange for private deliveries, contact me here

Friday
Dec282007

Reporting Services 2008 Beta Status

The status of the latest Reporting Services beta is explained here by Brian Welker from Microsoft.

Click to read more ...

Friday
Dec142007

Public MDX Classes

I'm pleased to announce that the Mastering MDX course is now available as a public delivery via SQLSoft+.

Tuesday
Jul312007

OLAP Front-Ends and MDX SELECT

Somehow it has come to be that most of the popular off-the-shelf OLAP clients are fundamentally crippled compared to their relational brethren. And this despite the fact that OLAP is supposed to be enabling technology.

Click to read more ...

Tuesday
Jun052007

Tableau Software

I've been recommending Tableau Software to clients for several years now. It's an outstanding tool that front-ends both OLAP and relational. The improvements in version 3 are substantial.

I used to think of Tableau as a highly specialized front-end, but that's no longer the case. Because of the broadened display capabilities, it should be widely applicable. 

Two shortcomings remain: lack of programmability and inability to deliver via web interface. [no longer true]