PTS Performance

Hi All.
I have a pretty simple cube with 2 measures (quantities and amounts) for
which I'm showing totals using 8 different dimensions.
When I add calculated members for YearToData values the performance in
PivotTableServices is extremely poor.
In my pivot table I have 5 dimensions in the page section and 3 in the rows.
Changing the value of one of the page dimensions takes over 3 minutes to
update with a message "Runing OLAP query...".
Is there anything I can do to improve performance???

Thanks a million in advance.
.

Relevant Pages

  • MDX Expression question
    ... I am trying to build a cube which analyzes the impact of exchange ... rates on costs. ... The amounts have about 5-6 dimensions. ...
    (microsoft.public.sqlserver.olap)
  • Re: room layout / floor plan / CAD software?
    ... > enter the dimensions of the various items in the room, ... and am given an overhead view in which I can ... something that requires large amounts of ... > documentation to be read, or has an undocumented or unattainable set ...
    (comp.os.linux.misc)
  • Re: room layout / floor plan / CAD software?
    ... > enter the dimensions of the various items in the room, ... and am given an overhead view in which I can ... something that requires large amounts of ... > documentation to be read, or has an undocumented or unattainable set ...
    (comp.os.linux.misc)
  • room layout / floor plan / CAD software?
    ... I am looking for software that helps me lay out a room. ... enter the dimensions of the various items in the room, ... something that requires large amounts of ... documentation to be read, or has an undocumented or unattainable set ...
    (comp.os.linux.misc)
  • Re: Using Excel Pivot table as front viewer
    ... Be especially careful with calculated members on dimensions other than ... There is no equivalent property like "Non Empty Behavior" ... For a sparse cube (and let's face it, all cubes are sparse), as you ...
    (microsoft.public.sqlserver.olap)