Dear all,

After I read "SQL Server 2000 Analysis Services Performance Guide", I have a
question about fact table count.

According to the article, AS does not recalculate the row count after the
initial partition (I have only one partition). For a growing fact level, we
should update the row count. However, if I do full process every time when
the fact table size is increased, then do I need to do the update mannually
again?

Also, if I have a growing fact level, then the Storage Design Wizard use the
old or the new row count of fact table (I only do full process and do not
update fact table Size property for the cube)?

Hope somebody can help me. Thanks!

Best wishes,
Polly

If your fact table count changes significantly and if you are redesign
aggregates as part of that change -- then you need to update the count. You
do it manually or have the system do it for you.

If you are not redesigning aggregates, then there is no need to update the
count until you do.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Polly" <Polly (AT) discussions (DOT) microsoft.com> wrote

Dave,

Thanks for your reply.

You said that I can have the system do it for me. Do you mean that if I want
to redesign aggregation, the AS will have a new row count automatically to
determine which aggregation to be generated.

Best Wishes,
Polly


"Dave Wickert [MSFT]" wrote:

What I meant was that if you run Analysis Manager, and you select the
estimated count property, there is a small "..." next to input field and if
you select that, the system will count it for you.

Another option is to use the Partition Aggregation Utility which is included
with the SQL Server BI Accelerator.
http://www.microsoft.com/sql/ssabi/default.asp

After installing it, look in the tools folder. Source is included with the
program, if you want to automate it yourself, you can look to see how it
does the updating.

Hope that helps.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Polly" <Polly (AT) discussions (DOT) microsoft.com> wrote

Thanks! Dave.

"Dave Wickert [MSFT]" wrote: