Facebook Twitter LinkedIn YouTube E-mail
Home Posts tagged "performancepoint"
formats

Forecasting with an MDX Linear Regression in an SSAS OLAP Cube

Share

A few days ago I published an article detailing a method to create regression line calculations in an Analysis Services OLAP cube using MDX.  The article can be found by clicking here.  It is the starting point for this article.  My instructional video detailing the entire regression line and forecasting process can also be found

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
formats

Create a Regression Line in an SSAS OLAP Cube with the LinRegPoint MDX Function

Share

During a discussion about OLAP cubes for Business Intelligence data visualization and analysis, I was asked if regression lines could be added to cubes as calculations within Analysis Services.  I had previously browsed the MSDN pages for the MDX functions LinRegPoint and LinRegSlope, but since I had never used them I replied “You should be

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
2 Comments  comments 
formats

Dynamic MDX for when the Last Day of Data isn’t Always “Day-1”

Share

When building a report or a dashboard, have you ever encountered a situation where the last day of data in a cube isn’t a consistent distance from the current day?  For example, what if “Yesterday” is sometimes “Two Days Ago”?  When building a KPI that displays the last day of data for a scorecard on

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Dynamic MDX for when the Last Day of Data isn’t Always “Day-1”  comments 
formats

Create a Dynamic Median MDX Calculation on a PerformancePoint KPI Scorecard

Share

Have you ever been asked to add a new KPI to a scorecard, only to find that there is not a corresponding calculation or measure in the cube?  With PerformancePoint 2010 KPIs for SharePoint 2010 scorecards, custom MDX expressions can be created as actual and target values without requiring modifications to be made to the

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Create a Dynamic Median MDX Calculation on a PerformancePoint KPI Scorecard  comments 
formats

Video: The GNet Group SightN2 for Healthcare BI Solution

Share

GNet Group’s SightN2TM for Healthcare is a Business Intelligence solution that provides a standardized foundation for the integration of healthcare information into a data warehouse for interactive, intuitive dashboards and reports that can become the foundation for unified data within a Business Intelligence solution.  The solution is designed to integrate data that most hospitals already report

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Video: The GNet Group SightN2 for Healthcare BI Solution  comments