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

MDX Implementing Logical AND On Members of the Same Hierarchy

Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli

In my prior blog post, I discussed implementing logical OR in MDX on members of different hierarchies.  As a follow-up to that post, I will now demonstrate how to implement logical AND on members of… Read more

0 comments, 1,779 reads

Posted in Salvo(z) SQL on 24 December 2013

MDX Implementing Logical OR On Members of Different Hierarchies

Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook  by Tomislav Piasevoli

In MDX, when two or more members of the same set are placed on a slicer, OR logic is automatically applied.  For example, if you have two members (e.g. sizes ‘Small’ and ‘Large’) on a slicer,… Read more

0 comments, 1,545 reads

Posted in Salvo(z) SQL on 15 December 2013

MDX Order by Multiple Criteria

The MDX language includes an ORDER function that orders members of a set in ascending or descending order based on a numeric (or string) expression.  The syntax of the Order function is displayed below:

Numeric expression syntax:

Order(Set_Expression, Numeric_Expression [ , { ASC | DESC | BASC | BDESC }… Read more

0 comments, 750 reads

Posted in Salvo(z) SQL on 8 December 2013

SQL Server Data Mining: Time Series Algorithm Tips

  • The Time Series algorithm has several parameters that may be adjusted if needed.  I have tried adjusting several of these parameter settings and determined that the following appear to have the most impact:
    • MISSING_VALUE_SUBSTITUTION:  If you have any blanks or gaps in your data and the MISSING_VALUE_SUBSTITUTION parameter is…

Read more

0 comments, 2,155 reads

Posted in Salvo(z) SQL on 4 December 2013