SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Salvo(z) SQL

Adam and Jennifer Salvo are IT professionals with over 10 years of diverse experience. Jennifer is a Business Intelligence developer focusing on the Microsoft BI stack (SSIS, SSAS and SSRS). Her prior work experience includes software development, systems analysis, end-user support, training, and SharePoint administration. Adam is a .NET technical lead with a current emphasis on Dev Ops and Windows Azure. His prior work experience includes .NET development, SQL Server administration, and BizTalk development. They also maintain a personal blog at salvoz.com.

Archives: July 2012

T-SQL Tuesday: A Day in the Life of a BI Developer

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

0 comments, 618 reads

Posted in Salvo(z) SQL on 17 July 2012

MDX ClosingPeriod and PeriodsToDate

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

0 comments, 1,156 reads

Posted in Salvo(z) SQL on 7 July 2012

MDX ‘Is’ Operator

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

0 comments, 813 reads

Posted in Salvo(z) SQL on 4 July 2012