Several Partitions vs Several Cubes

Tech-Archive recommends: Fix windows errors by optimizing your registry

I am looking for someone who can give some advice on creating
partitions/cubes.

Here is my situation:
I have a fact table with 80 million rows (results for kids in a state). I
create a giant cube with all the results and it takes too long to process.
(I have the need to process this data a couple times a day)

I am researching creating several cubes (450, one per district)
VS
creating several partitions (450, one per district) for the same cube.

It is my understanding that I can process partitions separate from one
another which would allow me to do more of a selective update on the cube.

Anyone out there have any advice or resources they could point me to which
would assist me in making this decision?

tx,
tim


.

Relevant Pages

  • Re: Several Partitions vs Several Cubes
    ... understanding how changing dimensions work and require processing(the cube ... With the partition option you must reprocess all partitions, ... >>> I am researching creating several cubes (450, one per district) ...
    (microsoft.public.sqlserver.olap)
  • Re: Several Partitions vs Several Cubes
    ... also, with a virtual cube in top of your cubes, you can have a problem if 1 ... (Well only 1 district accessible at this time, ... > creating several partitions for the same cube. ...
    (microsoft.public.sqlserver.olap)
  • Re: Multiple Cubes Sharing mdx Calculations?
    ... "I still see only 1 Fact table in the Cube browser. ... Different Fact Tables for Partitions ... view, from different data source views, or from different data sources. ... Cube partitions each have a slice for each attribute. ...
    (microsoft.public.sqlserver.olap)
  • Re: Ghosting (Think thats what it is called)
    ... Can anyone give me some advice about ... Conceptually, you create 3 primary* partitions, say, drive C, D, and E. ... Boot into C as normal. ... extended partitions as there are remaining single alphabets -- for naming ...
    (uk.comp.homebuilt)
  • Re: SSAS 2005 perform worse performance that 2000
    ... The slicer parameter is recommended but optionnal for your partitions ... recomend change memory settings. ... Our cube files takes about 35 GB, but database Estimated Size from cube ... queries from cache filtered 500000, Total queries from cache direct 30000. ...
    (microsoft.public.sqlserver.olap)