PowerPivot: improve the performances by sorting tables

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

While it is well know that in UDM data should be loaded sorted, to get better file compression and map structures. The world of PowerPivot (and BISM) is yet not explored. Working with a 50 millions rows table, I tested various scenarios to check if sorting affects BISM data structures too.

The fact table structure is very simple:

Read more...

Tags: performance, tip, load, excel

 

2007-2015 VidasSoft Systems Inc.