Analysis Services 2005 Browers Seems Slow

Hello,

I'm a new newbie, so I apologize in advance...

I have a fact table with about 1.3M rows and three dimension tables (one of
them is about 80,000 rows, the others only 1000). When I use the browser and
add a few hierarchies to it, it gets really, really slow to display. It may
take up to 2 minutes to refresh (I have a gig of ram with a 3.2 GHz P4,
Windows XP Pro).

I ran the Design Aggregation Wizard (I selected Molap), it makes one
partition with 70 aggregations (is that good?). When I change the percent
or use the "Run Until I Hit Stop" it still gives me the same results.

What can I do to improve the performance? Do I break it into additional
partitions? Am I missing a critical step (it sure feels that way)?

Thank you for the help.

-Gummy


.

Relevant Pages

  • Re: SSAS2005 - When do partitions need to be processed?
    ... dimensions are updated and a new partition is added to the cube. ... With AS2005 there is a proactive caching option at the dimension level, ... Duration: 0:00:03 ...
    (microsoft.public.sqlserver.olap)
  • SSAS2005 - When do partitions need to be processed?
    ... Every hour we update this cube adding a new partition to the measure ... however processing the Date dimension does not process all the partitions. ... Duration: 0:00:03 ... SQL queries 1 ...
    (microsoft.public.sqlserver.olap)
  • Re: SSAS2005 - When do partitions need to be processed?
    ... dimensions are updated and a new partition is added to the cube. ... With AS2005 there is a proactive caching option at the dimension level, ... Duration: 0:00:03 ...
    (microsoft.public.sqlserver.olap)
  • Re: Calculating Max Usage with OLAP
    ... cases where you are filtering on members from the majority of your dimensions. ... but a tool called 'Partition Manager' ... it will give you details of how to find which aggregations you ... > dimension with two levels and 24 members. ...
    (microsoft.public.sqlserver.olap)
  • RE: Processing error [Object does not exist]
    ... I learned processing partition will fail with error "object does not exist" ... Based on my experience, While doing a processing a dimension, ... relational data while performing dimension processing. ... Analyzer Manager, please provide the detailed steps / codes and sample so ...
    (microsoft.public.sqlserver.olap)