Is there a way to tell how many aggregates are assigned to a cube?

I just did a full process on a cube, and it spent a good 20 minutes creating
aggregates, but once it finished, and I checked the data folder, there were
no aggregates in there! Just the fact files.

Sure. You can download the Partition Aggregation Utility that comes with
the SQL Server Accelerator for BI at www.microsoft.com/solutions/bi. Once
you install it, it'll be in a folder on your hard drive called tools. You
should be able to point it at a partition and see what aggregates are
defined.

One reason you might not be seeing aggregates immediately is if you have
lazy processing going on. This would be the case for flex aggs
(particularly seen with slowly changing dimensions).


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"PCH" <pch12 (AT) hotmail (DOT) com> wrote