GGKK

Sorry for delay in replying, but I was away on holiday.

No .... I have not resolved this issue yet. I have currently restricted the data held in the cubes...

Hi Timothy

"Descendants([<Dim Name>],[<Dim Name>].[Month]).count" should do what you want.

On the Foodmart Sales cube it would be "Descendants([Time],[Time].[Month]).count"

I have added an "(All)" level to the Time Dim...

Hi Howard

Thanks for the reply.

When it first happened there was nothing going on on the server, just me starting to work on the restored cube.

The application event log is showing...

Hi Steve

They were both on SP3a when all this started.  Test is still on 3a but Live is now on 4 since the re-installation.  I'm a bit dubious to apply...

Hi Peter

I am archiving on one server and restoring on the problem server.

Data source is the same on both as they are both getting the data directly from Oracle Data...

Looks like I spoke too soon!

On re-installing  working with Foodmart was OK, but the restored cube still gave errors so I deleted it and restored from archive again.  Then everything...

Hi Steve

I have been installing both SP's and the repository is in MSSQL.

This morning I uninstalled everything then reinstalled, and all appears to be working OK, it's processing a cube...

Thanks Steve.

I downloaded SSABI, but we are running SP2 on all our servers so I couldn't install.  I cannot upgrade to SP3 as the client software has not been tested...

Hi Steve

Thanks for the reply.

I am just going by what the storage design wizard says, all it will go to is the 2 aggs.

Even though the cube only has a...

Thanks for the clarification Jamie, now I understand what you mean.  Also thanks to others that have replied.

But .... I have still not managed to create a cube with aggregations...

Thanks for the reply Jamie.

Sorry if I am being a bit thick, but please could you expand on:

"You can only create aggregations in a p-c dimension if non-leaf data is...