Problem processing new cube -- sql server data warehouse

Mike
12/18/2003 9:29:44 AM

All,

When I try to "Design Storage" for a new cube, I get
a "Fact table size can not be 0" message. (I am in the
Cube Editor...) If I focus on the fact table and
select "Browse Data", the data is displayed as it should
be. So, the fact table size clearly is not "0".

From Query Analyzer, I can select rows. The table has over
one million rows in it.

I can't see anything obvious, such as "Refresh connection"
that would seemingly rectify this problem.

Any help appreciated.

TIA,

Matt Carroll [MS]
1/12/2004 9:58:17 AM

In the cube editor, set a value for the Fact Table Size property in the
Advanced tab of the property panel. This value along with the sizes of
dimensions is used during the aggregation design process.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

sql server data warehouse : Problem processing new cube