MS SQL Server OLAP - Can't create aggregations!

Author

Can't create aggregations!

Paul

2005-12-20, 11:24 am

Hi,
I have AS2000, SP3 on WinServ2000 std. I can't seem to create any
aggregations for any cubes.

When I use the Storage wizard, it happily goes through and estimates the
calcs it is going to create (say 119, using roughly 118MB), and then saves
the cube and processes it but no aggregations are actually created? If I
look at the data files there are no rigid agg files despite all of the
dimensions being regular.

I've experimented with custom and noncustom aggregations and different cubes
and three different AS Servers and they are all the same - the wizard does
it's thing - then no aggregations. I'm doing exactly the same as I've done
at other companies so I really don't know what I'm doing wrong.

Any ideas?
Ta
Paul

Dave Wickert [MSFT]

2005-12-21, 3:24 am

Have you created attribute relationships to indicate that the user-defined
hierarchies you have in place are natural hierarchies?
--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Paul" <Paul@discussions.microsoft.com> wrote in message
news:898CC8E3-DF96-4223-AFB1- F25260D813A2@microso
ft.com...
> Hi,
> I have AS2000, SP3 on WinServ2000 std. I can't seem to create any
> aggregations for any cubes.
>
> When I use the Storage wizard, it happily goes through and estimates the
> calcs it is going to create (say 119, using roughly 118MB), and then saves
> the cube and processes it but no aggregations are actually created? If I
> look at the data files there are no rigid agg files despite all of the
> dimensions being regular.
>
> I've experimented with custom and noncustom aggregations and different
> cubes
> and three different AS Servers and they are all the same - the wizard does
> it's thing - then no aggregations. I'm doing exactly the same as I've
> done
> at other companies so I really don't know what I'm doing wrong.
>
> Any ideas?
> Ta
> Paul

Paul

2005-12-21, 7:23 am

Your comment means absolutely nothing to me, but thanks anyway.
Anybody else....

"Dave Wickert [MSFT]" wrote:

> Have you created attribute relationships to indicate that the user-defined
> hierarchies you have in place are natural hierarchies?
> --
> Dave Wickert [MSFT]
> dwickert@online.microsoft.com
> Program Manager
> BI Systems Team
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "Paul" <Paul@discussions.microsoft.com> wrote in message
> news:898CC8E3-DF96-4223-AFB1- F25260D813A2@microso
ft.com...
>
>
>

Deepak Puri

2005-12-21, 1:23 pm

Dave was referring to AS 2005-specific considerations, which you might
not yet be familar with. Anyway, when you manually process a cube or
partition, does the Analysis Manager dialog go through the "creating
aggregations.." phase? Any useful info in the Processing Log?

http://www.microsoft.com/technet/pr...ntain/anservog.
mspx[color=darkred]
Microsoft SQL Server 2000 Analysis Services Operations Guide
...
Processing Log File

Analysis Services does not record a processing log by default; you must
enable the recording of a processing log file. The processing log file
is a system-wide text file containing all of the processing information
you see displayed in the Process dialog box in Analysis Manager when you
process a partition, dimension, or mining model.
...[color=darkred]

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.droptable.com ***

Ramunas Balukonis

2005-12-22, 3:24 am

Paul,
I had the same error. In my case "Fact Table Size" was "0". After entering
fact table size, aggregations creation succeded.

Ramuans Balukonis

"Paul" <Paul@discussions.microsoft.com> wrote in message
news:898CC8E3-DF96-4223-AFB1- F25260D813A2@microso
ft.com...
> Hi,
> I have AS2000, SP3 on WinServ2000 std. I can't seem to create any
> aggregations for any cubes.
>
> When I use the Storage wizard, it happily goes through and estimates the
> calcs it is going to create (say 119, using roughly 118MB), and then saves
> the cube and processes it but no aggregations are actually created? If I
> look at the data files there are no rigid agg files despite all of the
> dimensions being regular.
>
> I've experimented with custom and noncustom aggregations and different
cubes

> and three different AS Servers and they are all the same - the wizard does
> it's thing - then no aggregations. I'm doing exactly the same as I've
done
> at other companies so I really don't know what I'm doing wrong.
>
> Any ideas?
> Ta
> Paul

Darren Gosbell

2005-12-23, 8:24 pm

Paul,

Mark Hill did an excellent post on setting up aggregations in AS 2005
that sounds like the same issue that your are hitting.

http://markiehillas.blogspot.com/20...05-aggregation-
confusion.html

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <uALzl7lBGHA.740@TK2MSFTNGP12.phx.gbl>,
deepak_puri@progress
ive.com says...
> Dave was referring to AS 2005-specific considerations, which you might
> not yet be familar with. Anyway, when you manually process a cube or
> partition, does the Analysis Manager dialog go through the "creating
> aggregations.." phase? Any useful info in the Processing Log?
>
> http://www.microsoft.com/technet/pr...ntain/anservog.
> mspx
> Microsoft SQL Server 2000 Analysis Services Operations Guide
> ..
> Processing Log File
>
> Analysis Services does not record a processing log by default; you must
> enable the recording of a processing log file. The processing log file
> is a system-wide text file containing all of the processing information
> you see displayed in the Process dialog box in Analysis Manager when you
> process a partition, dimension, or mining model.
> ..
>
>
> - Deepak
>
> Deepak Puri
> Microsoft MVP - SQL Server
>
> *** Sent via Developersdex http://www.droptable.com ***
>

Sponsored Links