Home > PowerPivot > PowerPivot’s limitation to SSAS

PowerPivot’s limitation to SSAS

 
Marco Russo just published “Using SSAS 2005/2008 as PowerPivot Data Source: Query Designer” on his blog. It is an excellent article solving various issues in PowerPivot.
 
It is obvious that the version 1 PowerPivot has limitations to use SSAS as data source. It requires some workarounds to make it fully work.
 
In my opinion, I would really prefer to feed data into PowerPivot from a data mart (relational database) instead of SSAS. And normally, the SSAS cube is get the data from the underlying data mart anyway. Compared to the SSAS cube, the data mart is flat and doesn’t have any problem e.g. hidden columns. SSAS is excellent for building corporate wide BI report while PowerPivot is great for individual to get data from the data mart to do data analysis.
About these ads
Categories: PowerPivot
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 61 other followers

%d bloggers like this: