Page dimension

[Scott Underhill]

Hi,

I have an mdx query with a page dimension on it. This is causeing me two
major headacks. The first is the values that are shown in the pivottable
dont seem to match the values I calculated for it ... has anyone used
the third axis with the pivottable successfully before. ?

The second, and probably the major one is that I have a chartspace object
data bound to the pivottable, what it shows seems to be totally diffrent
to what the pivottable is ... any suggestions ?

Thanks heaps/
Scott

 

[Scott Underhill]

Well I fixed the issue, by exposing the third axis of the mdx query
in the filter area of the pivottable it seems to sink up with the chartspace

It still makes no sence why I have to do this ... and why pivottable seems
to work in one way, and chartspace in another. Perhapse someone could
enlighten me ?

Scott