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>...

What do you mean by the correct MDX queries
If your connection string looks like this, it should work

pt.ConnectionString = "Provider=MSOLAP.2;Data Source=localhost;log file=c:\\your folder\\mdx.log;Initial Catalog=Foodmart 2000";

(I'm using \\ because of JScript, don't need them in VBScript). Be aware this is a Unicode file, some text editors may not display it correctly

Of course OWC makes heavy use of session members and sets, and names won't be very mnemonic, but you can still recover the MDX query

BTW, when you import MDX into OWC, the internal representation of OWC doesn't keep the original query. So, if you saved the xmldata property and recovered it later it would return a different cellset than the original query. For example, if you feed OWC an MDX query that filters products with sales greater than 2000, OWC would only keep the specific members and it would not reapply the filter to the current cube data

HTH
Bria
www.geocities.com/brianaltmann/olap.htm

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