What bugs me very much about working with KPIs in PerformancePoint's Dashboard is that you cannot do simple calculations. For instance, I have a sales cube that has the measures unit cost and price the unit was sold for. I would like to say that a loss (price/cost < 1) makes the KPI red, a <20% margin makes it yellow and >=20% is green. ...

One of my main gripes with Microsoft SSIS is that there is no way to reuse logic. In my data integration task I needed to do the same lookup and translation tasks (typically convert to upper case, replace " with 'N/A', look up column in side table and use the IDs from that table instead) many times, in my case when importing data from an Axapta ...

In Scott Larsons blogpost referenced in my last post he gives a short but important note: his favourite MDX resource. And I agree: a 62 article series in learning MDX. Since I've worked with SQL ...

At work I'm looking at PerformancePoint, and being a newbie with this product I of course do all the newbie errors. That's why I was so happy when finding Nick Barclay's blogpost where he explains all about the way-to-common ...

Not quite happy with any of the programs I found to identify iTunes duplicates, I spent an hour making my own (beats tracking down duplicates. ) I thought I'd share it with you. It's my first attempt at using OS X' ScriptingBridge and written in Python. I have no ...