Hi,

I am using pivottables from OWC10 and I was wondering how you can get
the MDX from it. I know you can set the MDX but don't know how to
retrieve the MDX.

There is a long winded solution but I get a "script out of range
error" on ".RowAxis.InsertFieldSet .FieldSets("[RowFs]")" in the
window_onload sub:

http://groups.google.com/groups?q=.R... le.com&rnum=1

Please post your technique on how to get the MDX from a pivottable, or
if you know how to fix the script out of range error" for the above
example.

Also, can OWC11 get MDX from a pivottable?

Thank you in advance!

P

You can use the logfile property of the connection string
to set up a text file that will record the MDX generated
by OWC.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html


&hl=en&lr=&ie=UTF-8&oe=UTF-
8&selm=110bef3d.0106141018.2d5b0d5c%
40posting.google.com&rnum=1

Brian,

Thank you for your response.
I tried it and yes it wrote a MDX statement to the logfile but when I
ran the MDX statement in the MDX Sample Application, I received the
following error:

"Unable to open cellset. Formula error - cannot find dimension member
("member_caption") - in a name binding function"

Here is the MDX that I tried to run:

select filter([Measures].members,
[Measures].currentmember.member_caption <>
[Measures].currentmember.member_caption) on columns from [MyCube]

What do I need to do so it writes the correct MDX query to the log
file?

--------------------------------------
The MDX statement in the logfile does not look like what the view that
I created.

I basically need to get the MDX statement to create 3D charts (via
chart fx object).

Please post any other techniques to get MDX from OWC!

Also, please Microsoft, read the numerous amount of posts of people
wanting to get MDX from a OWC pivot tables! Please add this feature,
it is needed badly!


Thanks!

Phin

"Brian Altmann" <anonymous (AT) discussions (DOT) microsoft.com> wrote