Re: Analysis Services 2005 Browers Seems Slow

generally the problem is not the cube, its the OWC / Pivottable.
this tool create bad queries specially if you use a lot of attributes and dimensions and you use the multiselect feature or the order by feature.

also verify that your attributes are set to the rigid option instead of flexible.
(there is other optimizations option around dimensions, search on SSAS/BI blogs on the web to learn more)

also verify if the problem come from the client side or the cube side (see which application takes the CPU time)
do you have calculated measures ?

the best way to play with the pivottable is to filter a lot and use only few attributes in rows or columns
personally I try to never put more then 2 attributes in rows and only 1 in columns.
and try to not select few members from a dimension and display them in rows or columns; or disable the visual total option of the pivottable.

"Gummy" <gumbatman@xxxxxxxxxxx> wrote in message news:12qonk16ua9iqd1@xxxxxxxxxxxxxxxxxxxxx
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: Drilling down brings back incorrect numbers
    ... I suffer the same issue with partitionned cube where, in fact, I have a "conflict" between 2 dimensions. ... SSAS auto assign the slice of the cube for a partition, in my case I have 2 years level in 2 different dimensions, so SSAS detect correctly the partition at this level. ...
    (microsoft.public.sqlserver.olap)
  • Re: Cube very slow to querying when in the middle of a process
    ... Well, when incrementally updating dimensions, AS2k will automatically ... refresh the cube partitions below it which may have an impact on this. ... where you may want to have reporting OLAP cubes and processing OLAP cubes ... > Every hour we add a new partition to ...
    (microsoft.public.sqlserver.olap)
  • RE: Incrementally updated dimensions and lazy processing
    ... I would not triplicate your shared dimensions just so you can have unshared ... we have a cube containing historic ... processing the newly added month partition. ... lazy aggregation of all the cube partitions in the background. ...
    (microsoft.public.sqlserver.olap)
  • Re: Fairly Large Cube-Performance Improvement recommendations
    ... move) if the cube has large number of dimensions. ... We have 30 dims in the cube and the storage design wizard taked about 45 ... > 1) execute a fairly long query, let's say one that runs for 20 seconds. ...
    (microsoft.public.sqlserver.olap)
  • Re: Analysis Manager Operations extremely slow
    ... Each of the cubes have 12 partitions with monthly slices. ... Counting multiple hierarchies as dimensions, we 10 regular dimensions and 6 ... The first time we bring up the cube edit it take 1 min 20 secs, ...
    (microsoft.public.sqlserver.olap)