Facebook Twitter LinkedIn YouTube E-mail RSS
Home Microsoft SQL Server 2012 Archive for category "SSAS"
formats

Automate Bus Matrix Documentation Using DMV Queries from a Microsoft BI Tabular Solution for Project Management Scope Verification – Part 2

Share

This is Part Two, the final of two blog posts about automating the creation of a Bus Matrix in Power Pivot for Excel using DMV queries from an SSAS Tabular Model. In the first part of this blog post series, which can be found at this link, I discussed the benefits of a Business (Bus)

(More)…

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

Automate Bus Matrix Documentation Using DMV Queries from a Microsoft BI Tabular Solution for Project Management Scope Verification – Part 1

Share

This is Part One of two blog posts about automating the creation of a Bus Matrix in Power Pivot for Excel using DMV queries from an SSAS Tabular Model.  UPDATE: Part 2 is now published and can be viewed at this link. Have you ever spent several hours making a Business (Bus) Matrix for an

(More)…

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

Video: Forecasting using Regression Analysis in Microsoft OLAP Cubes

Share

A few weeks ago I published a couple of articles that walk through the process of creating a linear regression line using MDX in a Microsoft OLAP cube.  The articles can be found at the links below: Create a Regression Line in an SSAS OLAP Cube with the LinRegPoint MDX Function Forecasting with an MDX

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Video: Forecasting using Regression Analysis in Microsoft OLAP Cubes  comments 
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