Removing Aggregations

#1

Hi All,

Once I have added aggregations using the storage design wizard, how do I
remove them from my cube so that my cube has no aggregations.

Thanks
K

#2

You have only to redesign the cube with zero aggregation. At "Set
aggregation options", select "Until I click Stop" and click next.

But you also have to reprocess the cube to reflect the new design finally.

Ohjoo Kwon

"Kathy" <roo (AT) roo (DOT) com> wrote

Quote:

Hi All,

Once I have added aggregations using the storage design wizard, how do I
remove them from my cube so that my cube has no aggregations.

Thanks
K

#3

Use Partition Manager from sql 2k RK.

Ramunas

"Kathy" <roo (AT) roo (DOT) com> wrote

Quote:

Hi All,

Once I have added aggregations using the storage design wizard, how do I
remove them from my cube so that my cube has no aggregations.

Thanks
K

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Removing Aggregations

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Removing Aggregations - 03-08-2005 , 03:20 AM

Re: Removing Aggregations - 03-08-2005 , 03:39 AM

Re: Removing Aggregations - 03-08-2005 , 04:58 AM