Archives: July 2012
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