SYMPTOM:
Only one row is returned for an Intelligent Cube when the same attributes and metrics on a normal report return more rows of data. The Intelligent Cube file appears to be the necessary size to contain all the data but Intelligent Cube reports only return one row.
CAUSE:
This happens when one of the columns in the Intelligent Cube has the binary datatype since the binary datatype from SQL Server is not supported for Intelligent Cubes.
ACTION:
The solution is remove the Binary column from the Intelligent Cube report. Run the report manually or modify the column to be a base 10 number instead of a base 2 number.
