Re: Analysis Services 2005 Browers Seems Slow

Jéjé,

Thanks for all the great information. I will start looking at these options
right away.

Part of the problem is that I need to give a quick demo to my department and
they like to see lots of data on which you can drill-down. Right now, the
demo is just on my machine, I'm not showing anything over the web.

Do you think when I link this to Reporting Services, it will still be so
slow?

Thank you for all the help.

-Gummy


"Jéjé" <willgart_A_@xxxxxxxxxxxxxx> wrote in message
news:eaivOZXOHHA.1252@xxxxxxxxxxxxxxxxxxxxxxx
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: Analysis Services 2005 Browers Seems Slow
    ... (there is other optimizations option around dimensions, ... and try to not select few members from a dimension and display them in ... > I ran the Design Aggregation Wizard, ... > partition with 70 aggregations. ...
    (microsoft.public.sqlserver.olap)
  • Re: ID3DXSprite::Draw screen image doesnt match texture???
    ... If you're using D3DX for loading the texture, ... function that stretched the dimensions to powers of two. ... > I am displaying a sprite from a .tga file thats 32 bit with alpha channel ... My laptop display runs 1400x1050. ...
    (microsoft.public.win32.programmer.directx.graphics)
  • Re: How to retrieve the image file dimension?
    ... display the Dimensions, File Type and Size. ... Microsoft MVP [Windows XP Shell/User] ... How do I retrieve the dimensions of any file of type .dds or .bmp etc? ...
    (microsoft.public.windowsxp.general)
  • Re: Do I understand how Word deals with graphics?
    ... >> What Jezebel is referring to is the resolution at which Word _stores_ the ... >> content - you can stretch it back again with the Cropping Tool to display ... >> Digital Cameras don't set the print dimensions as a part of the image ... >> A per above, the number of pixels remain the same, but the print ...
    (microsoft.public.word.drawing.graphics)
  • Re: Analysis Services 2005 Browers Seems Slow
    ... generally the problem is not the cube, ... 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. ... I ran the Design Aggregation Wizard, it makes one partition with 70 aggregations. ...
    (microsoft.public.sqlserver.olap)
Loading