After four days of tinkering with getting this damn data mining tools setup from Microsoft I got it to work! Well, work as in worked for their 'AdventureWorks' demo database, but work none the less.

Sure, part of the time was burned when I decided to try and use MSSQL Express 2012.. it turns out the express edition won't let you create data cubes.. so I had to pull out of that (as much as possible), jacked up my local DB instance so install a new one.. found out I didn't install the 'Analysis Services', installed that, and bet my head on how to get my SQL Server Data Tools 2012 to talk to my local db...

After trying permutations of who the 'SQL Server Analysis Services' was setup under as (Local System Account), and the impersonation for the dataset ('use the service account'), shit clicked, the cube installed, and data over flowth my cup.

Seriously some real gnarly set of rad ass models, visuals, and insightful relationships.

It blew my freak'n mind man!