During processing I can see that SSAS read x records, but all measures in the cube return 0

Written by Vidas Matelis. Posted in Design FAQ

Q: During processing I can see that SSAS read x records, but all measures in the cube return 0. What else can I check?

A: Things to check:

Have you specified default member on any dimension and/or attribute? Maybe this default member does not have any data.
Is there any attributes that have "IsAggregatable" property set to false? If so, change setting to true and check if data reappeard.
If you loaded many records and each measure value is 0 or NULL, at the end your result will allways be 0/NULL.
Did you bind your measures to correct source fields?