grab our rss feed

stevienova.com

Homepage of Steve Novoselac

Entries for February, 2009

Business Intelligence != Reporting

Last week I was in a heated discussion about Business Intelligence, and it came up that “Business Intelligence is just writing reports, what is the difference from just writing some reports?” I tend to disagree. Writing reports is, well, writing reports. You can write reports off of tons of data, and yeah, probably get some [...]

View Comments | 1,087 views

SSAS Cube Rule #1 – YOU NEED CALCULATE

Ok, I just spent a few hours debugging a cube that wasn’t bringing back any data. Checking all the relationships, the source data, the marts, etc, etc. And lo and behold, find out that a colleague commented out all the calculations, including the CALCULATE statement which says: The CALCULATE command controls the aggregation of leaf [...]

View Comments | 1,520 views

iLife 09 – iPhoto and Flickr Integration

I installed iLife 09 a few weeks ago and I have been organizing my photos using faces, places, Facebook, MobileMe and Flickr. One thing I noticed though, is the Flickr integration is OK, but really doesn’t fit my workflow. Why? Well first, it wants to create a Flickr Set out of everything, if I upload [...]

View Comments | 995 views

Random Things around the Net Week of 02/14/2009

Yammer iPhone app goes Open Source – Yammer is a kind of Twitter clone, but for your company. I believe it is made by the same people that created Geni.com. Pretty cool that it is open source, just another way to get a good idea on how to build iPhone apps. WordPress has their app [...]

View Comments | 709 views

Data Integrator Error 51005

If you run across this error number (51005) in Data Integrator ETL’s, it more than likely means that you are running two ETL’s over the same table at the same time of have some kind of double processing on a table going on.

View Comments | 797 views

Tracking a Newborn the iPhone Way

Now that Ella is home with us from the hospital, of course reality sets in, which means for her: eat, sleep, poop in no particular order. The thing is, tracking feedings and diapers and what is going on gets tough, and with so much going on and the tiredness of the parents, how do you [...]

View Comments | 766 views

Hello Ella!

Ella Jane Novoselac was born on Feb. 4th, 2009 at 1:41 PM. She weighed 6 lbs 9 oz and is 19 inches long. Mom, Dad, and Baby Ella are doing great! Ella is already an geek girl, she has her own website – http://ellanovoselac.com More pictures and videos and everything else will be coming soon!

View Comments | 959 views

Microsoft BI Client Tools: Creating PivotTables in Excel 2007 that work in Excel 2003

Recently I blogged about easing the transition to Excel 2007 from Excel 2003, by changing your PivotTable design and options. This post is going to be about creating PivotTables that connect to OLAP cubes (and PivotTables in general) that will work in either client, or sometimes called “Compatibility Mode“ If you create a PivotTable in [...]

View Comments | 1,443 views

DBA position at Trek Bicycle Corporation (Waterloo, WI)

I usually don’t mix in a ton of work blog posts here, but I will make a few exceptions. Some of you probably don’t know, but recently I became the Business Intelligence Manager at Trek Bicycle Corporation, and I need to add a person to the team. The position would be working out of the [...]

View Comments | 1,012 views

Microsoft BI Client Tools: Easing the Transition from Excel 2003 to Excel 2007 – PivotTable Layout and Design

Being that we are now in the year 2009, you would think that most people are currently using or have been using the Office 2007 suite for a couple of years now. The truth is that there are many businesses “in the wild” that are still standardizing on the Office 2003 suite. Why? Well there [...]

View Comments | 2,414 views