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,
MikeIn 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.
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:013901c3c58c$86ab1c40$a301280a@.phx.gbl...
quote:
> 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,
> Mike
