Re: HELP: Getting MDX from OWC

#1

Hey RE BT,

I really wish that there was a way to get MDX from OWC! People have
suggested the logfile approach but it doesn't write the correct MDX
queries (unless I did it wrong, please post the code how to do it).

I saw some techniques in converting to the XML to MDX but it only
worked on simple queries! If you have code that works please post!

If I can only get the MDX so I can feed it to the chartFX charts!
The strange thing is that you can import a MDX into OWC but you can't
export it! Maybe one day we'll be able to get MDX from OWC!

Either way, if anybody can post some techniques to get MDX from OWC it
would be greatly appreciated!

l8r,

Phin

bti (AT) ementor (DOT) no (Bj?rn Tingstadengen) wrote in message news:<f07399d2.0403311225.4ee6ac7f (AT) posting (DOT) google.com>...

Quote:

mrwoopey (AT) yahoo (DOT) com (mrwoopey) wrote in message news:<e48ab325.0403260914.57b08625 (AT) posting (DOT) google.com>...
Hi,

Does anybody know how to get MDX from OWC? I need MDX so chartFX can
create OLAP charts (unless you know of another way to generate chartFX
charts with OWC).

I posted a similar question a few months ago and I was hoping somebody
now had a solution:

http://groups.google.com/groups?hl=e...3DN%26tab%3Dwg

Can you get MDX from OWC11 (I'm using 10 right now)?

I believe you can't write MDX dirctly in OWC XML code however you can
try
iterpret a few lines of XML code to see how the XML tags are designed
and then try witing it as XML/MDX.

Unfortenately there is no new enhancements in OWC 11, however
Microsoft has
fixed a few unpeasent bugs that appear in Office 10 (at lest in OWC
10.4109)

RE BT

Thanks!

Phin

#2

Be forewarned: As you interact with OWC it issues incremental queries.
Suppose you are viewing {USA, Canada} then you drilldown on USA. OWC issues
a new query to get USA.Children and then inserts the results into the view.
(I understand this is the reason the query string is not exposed as a
readable property -- because it might confuse.)

public @ the domain below
www.tomchester.net

"mrwoopey" <mrwoopey (AT) yahoo (DOT) com> wrote

Quote:

Hey RE BT,

I really wish that there was a way to get MDX from OWC! People have
suggested the logfile approach but it doesn't write the correct MDX
queries (unless I did it wrong, please post the code how to do it).

I saw some techniques in converting to the XML to MDX but it only
worked on simple queries! If you have code that works please post!

If I can only get the MDX so I can feed it to the chartFX charts!
The strange thing is that you can import a MDX into OWC but you can't
export it! Maybe one day we'll be able to get MDX from OWC!

Either way, if anybody can post some techniques to get MDX from OWC it
would be greatly appreciated!

l8r,

Phin

bti (AT) ementor (DOT) no (Bj?rn Tingstadengen) wrote in message
news:<f07399d2.0403311225.4ee6ac7f (AT) posting (DOT) google.com>...
mrwoopey (AT) yahoo (DOT) com (mrwoopey) wrote in message
news:<e48ab325.0403260914.57b08625 (AT) posting (DOT) google.com>...
Hi,

Does anybody know how to get MDX from OWC? I need MDX so chartFX can
create OLAP charts (unless you know of another way to generate chartFX
charts with OWC).

I posted a similar question a few months ago and I was hoping somebody
now had a solution:

http://groups.google.com/groups?hl=e...3DN%26tab%3Dwg

Can you get MDX from OWC11 (I'm using 10 right now)?

I believe you can't write MDX dirctly in OWC XML code however you can
try
iterpret a few lines of XML code to see how the XML tags are designed
and then try witing it as XML/MDX.

Unfortenately there is no new enhancements in OWC 11, however
Microsoft has
fixed a few unpeasent bugs that appear in Office 10 (at lest in OWC
10.4109)

RE BT

Thanks!

Phin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: HELP: Getting MDX from OWC

comp.databases.olap comp.databases.olap

Re: HELP: Getting MDX from OWC - 04-01-2004 , 05:39 PM

Re: HELP: Getting MDX from OWC - 04-02-2004 , 12:38 PM