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: January 2013

Currency Conversion in Tabular Model Using DAX

Roughly a year ago, I implemented currency conversion logic in multidimensional cubes using measure expressions (as well as using the Leaves function in MDX).  I documented the implementation in a few blog posts:

I have now also implemented currency… Read more

0 comments, 2,948 reads

Posted in Salvo(z) SQL on 28 January 2013

Re-writing MDX calculated members as DAX measures

I have been working on re-creating some logic in a tabular cube that was originally implemented in multidimensional.  This involved creating some DAX measures that return the same results as the MDX calculated member counterparts in the multidimensional cube.  I thought that some individuals who are familiar with MDX in… Read more

0 comments, 1,333 reads

Posted in Salvo(z) SQL on 21 January 2013

SQL Server Analysis Services KPIs

Key Performance Indicators (KPIs) are measurements used to gauge business performance against quantifiable goals.  SQL Server Analysis Services provides functionality to define KPI calculations and associate KPIs to measure groups in a multidimensional cube.

SQL Server Analysis Services KPIs consist of the following properties:

  • Value Expression: An MDX expression that…

Read more

0 comments, 6,295 reads

Posted in Salvo(z) SQL on 14 January 2013

Querying and Optimizing DAX

Over the past few weeks, I’ve been watching some videos from this year’s PASS Summit.  One of the presentations I watched is ‘Querying and Optimizing DAX’ (BIA-321-S) by Alberto Ferrari.  I took some notes during this presentation and am sharing them here.

DAX as a Query Language

  • DAX queries can…

Read more

1 comments, 2,787 reads

Posted in Salvo(z) SQL on 2 January 2013