Reporting with SSAS Tabular

Email this to someoneShare on LinkedInTweet about this on TwitterShare on FacebookShare on Google+
3-17 ssas
A unified way to report on archived and current data

What if it was possible to bring your legacy enterprise portfolio management (EPM) data into the same comprehensive reporting model as your current EPM platform? Wouldn’t it be great if you could gain insights and track metrics against all of your EPM data, past and present, in one location?

It is possible, of course, but it usually means executing costly and time-consuming data conversions and importing from your old EPM system to your new one.

My colleagues and I came up with an innovative approach to reap the benefits of a consolidated data model for reporting without the need to import the data into Project Server (this was submitted and accepted as a nominee for the 2014 Walberg innovation awards. You can read about another submission I was involved in this post).

We built an SSAS tabular model for EPM reporting and take advantage of table level partitioning to bring data from legacy repositories into one comprehensive model.

The advantages of this approach are numerous, including:

  • Analysts and management can analyze all EPM data as one unified model.
  • The new EPM system is not overly ‘bloated’ with historical data. Hence only current data that is actively managed is kept in the EPM system.
  • Resources that would have been needed for data migration and conversion can be utilized elsewhere.

Needless to say, the client that we implemented this approach for was very satisfied with the ability to analyze all of their data in one BI model!