Hello Everyone:

I have a cube with several partitions and each partition
has very different number of records in the table.

How do I set the Fact Table Size in the Cube Editor for
each partition? I do not see a way to do this.

Thank and regards,
Mario

Hi Mario,

From the Analysis Services Performance Guide
(http://www.microsoft.com/technet/pro...nsvcspg.mspx):

When you define a cube, Analysis Services counts the current rows in the
fact table for the initial partition and stores this value in the Fact Table
Size property for the cube. Thereafter, Analysis Services never recalculates
the row count for any partition. Furthermore, because aggregations are
designed on a per partition basis, it is the row count for the partition that
is important and that must be set properly for each partition. If you have a
growing fact level, you should update the row count manually for a partition
before you design the aggregations for that partition. You can query the
relational tables to determine the actual number, or you can enter the number
of rows you anticipate will be in the partition when it is fully populated.
If your cube has only one partition, you can update the row count for this
partition by using the Cube Editor in Analysis Manager. This value will
automatically be copied to the only partition in the cube. If you have
multiple partitions, you must use the Partition Aggregation utility to set
the row count for each partition (Cube Editor will not update this value
across all partitions). You can use the Partition Aggregation utility to set
the row counts for all partitions at once. You can also set the row count for
each partition using the DSO API. See "Aggregation Size Limited to 30 Percent
of Fact-Level Size" later in this section for a discussion regarding when to
increase the row count above the actual number of rows at the fact level for
a partition.

HTH,

Chris

"MT" wrote:

Thanks Chris. I'll download it from the accelerator kit.



"Chris Webb" wrote:

Chris:

Is there any way to get the Partition Aggregation Utility without installing
the whole
BI accelerator kit?

Also: does it run on 64-bit? Or, do I have to connect via a 32-bit box?

Regards,
Mario


"Chris Webb" wrote:

An earlier version, which still works pretty well, was included in the SQL
2000 Resource Kit. I'm not sure you can download it directly, though, which
is a pain - I know for those of us who aren't on Office XP or whatever the
requirement is for the BI Accelerator, it makes life difficult.

As for 64-bit, I'm almost certain you would have to connect from a 32-bit
box to use it.

"MT" wrote:

Thanks Chris.

Boy, talk about secretive...

In any case here is a solution I figured out for others that might want the
Partition Aggregation Utility and do not want to install the accelerator.

0)
Download the ssabi.msi file from the MSFT website for the accelerator for BI.

1)
Do a network install by using msiexec.exe /a ssabi.exe.
This will expand the .msi file to a directory of your choice.
This is the only way of getting at the single files in the accelerator...

2)
Go to the tools subfolder of where you extracted the contents and
copy the file PartAggUtil.exe to wherever you want to keep it afterwards.

3)
I also suggest you nab the docs (docs subfolder) as they contain some
good info on AS and partioning as well as how the utility works.

4)
Delete the folder where you expanded the accelerator.

Done.

Greetings,
Mario


"Chris Webb" wrote:

I really appologize about that. We've just never got the time to post it
separately. Thanks for working out a solution.

BTW: Chris: the older version on the SQL Server 2000 Resource Kit is lacking
the functionality to change the fact table and partition counts. That was
the one feature added in the SSABI version.

--
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.

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

x):