SSAS FAQ Design FAQ During processing I can see that SSAS read x records, but all measures in the cube return 0
During processing I can see that SSAS read x records, but all measures in the cube return 0
User Rating: / 1
PoorBest 
Written by Vidas Matelis   
Wednesday, 25 April 2007 19:38

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?

 

< Prev   Next >
 
Tags: design, faq, process

Strategy Companion