Enhance PowerPivot Cube using Visual Studio 2008 R2
User Rating: / 1
PoorBest 
Written by Fendy Huang   
Thursday, 12 May 2011 22:08

PowerPivot is a self service BI tool that you may use it to prototype your work quickly. The SQL Server Analysis service that PowerPivot cube used is a VertiPaq storage mode which is different from the traditional MOLAP, ROLAP or HOLAP cube. It is a read only temporary cube that PowerPivot Service creates and manages. You may persist or enhance it using Visual Studio 2008 (SQL Server 2008 R2).

Read more...

  Tags: load, internal
 

Pyramid+PowerPivot