Report Portal

Why are there less data in the cube than the fact table?

Sereral customer have asked me why they have less data in their cube than they have in the fact table. Essentially, when they view the cube Measures.NetSales does not equal Sum(NetSales) from the fact table. So here are the some possible causes, that I would investigate in such circumstances.

Read more...

Tags: design

 

2007-2015 VidasSoft Systems Inc.