Q:

SSAS MDX returns null for simple query - Cube is Processed and Facttable has data

I have a cube with 3 partitions that relate to corresponding fact table from another database.  When I process the Cube the message says Read 63000 rows and when I look at the partition's  estimated rows its equal to 63000.  
However when I browse the cube or do a simple MDX query there is no data.  Furthermore the data estimated file size remains 0.  
I have the adventure works cube on the same server and it works as expected, its seems to be just this Cube

A:

There are a number of common causes for this sort of issue:
Removing the CALCULATE; statement from the MDX script can cause this, adding it back if it is missing should fix this.
Setting one or more attributes to IsAggregateable = false can cause this if the first member in the attribute does not have data and you have nto set an explicit default. Setting a more appropriate default member or turn IsAggregatable back on can fix this.
Setting the default member of an attribute to a member that has no values can also cause this. Removing the defaultmember setting or setting it to a more appropriate value can fix this.

