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

PerformancePoint ‘Named Set’ Filter

PerformancePoint provides several options to create filters.  One of the options available is ‘Named Set’.  Within SSAS cubes we can define ‘Named Sets’, which are MDX expressions that return a set of dimension members.  These ‘Named Sets’ can be used to populate filters within PerformancePoint. 

Defining a named set within… Read more

0 comments, 2,102 reads

Posted in Salvo(z) SQL on 25 February 2013

Configuring PerformancePoint Data Source for Time Intelligence

PerformancePoint provides functionality to map several time dimensions across multiple data sources to a ‘Master Time Dimension’.  Data sources that are mapped to a ‘Master Time Dimension’ can be referenced in Time Intelligence filters within PerformancePoint. 

As a first step, you will need to launch ‘Performance Point Dashboard Designer’ and… Read more

0 comments, 1,820 reads

Posted in Salvo(z) SQL on 18 February 2013

Adding PerformancePoint Dashboard Content to SharePoint

Microsoft SharePoint Server 2010 provides several options for creating Dashboards using PerformancePoint content. 

The first option is to implement the dashboard in PerformancePoint Dashboard Designer.  In PerformancePoint Dashboard Designer, you create components such as Filters, Analytics Charts, Analytics Grids, Scorecards and KPIs.  Once you’ve built the individual components, you can… Read more

0 comments, 3,544 reads

Posted in Salvo(z) SQL on 11 February 2013

SQL Server Analysis Services Tabular KPIs

A few weeks ago, I wrote a blog post that discusses implementing KPIs in SQL Server Analysis Services Multidimensional.  For those of you who are unfamiliar with the KPI functionality in the Multidimensional model, the blog post can be found here.  I’m now going to discuss the KPI functionality… Read more

0 comments, 2,496 reads

Posted in Salvo(z) SQL on 4 February 2013