I am attempting to define a cube that processes tables in a Teradata
database. The cube seemed to work nicely with about 5 months of data.
But now that I've loaded another 11 months (total 5+ million rows in
the fact table), I can no longer count the fact table from analysis
services. The following message occurs:

"Unable to count the members of the style level.
Unable to open the record set.
Error: [NCR][TDATADLL] Query Timeout Expired."

If I substitute any other column from the fact table in my level
definition the same problem occurs.

If I perform SQL directly on the fact table in the database
environment everything still seems to work fine.

I tried playing with the timeout parameters in the data source
definition with no apparent effect.

If anyone knows whats going on, their insight would be gratefully
appreciated. Thanks.