My name is Jennifer and I am a Business Intelligence developer at Trek Bicycles.  I’ve been a BI developer for a little over a year and work with the Microsoft BI tools: SSIS, SSAS and SSRS.   The BI team at Trek consists of 4 analysts (2 in US, 1… Read more

I’ve decided that the best way to spend a day of 104 degree weather is to sit inside and write a blog post!  I’ve been working with MDX quite a bit recently and thought I’d share a few more bits of knowledge I’ve acquired….

I recently received a request to… Read more

I recently encountered a business scenario involving calculated members in a cube that I thought is worth sharing.

We have a cube with the following measures:  Shipped Quantity, Forecast Quantity, and ABS Variance to Forecast.

ABS Variance to Forecast is a calculated member in the cube, the MDX is pretty… Read more