Is there any way to retreive the MDX bieng generated in the background by
excel OWC when I drag and drop fields ?
I've written a simple query with a crossjoin of three dimensions and OWC is
having a very hard time displaying everything!!!! It works fine though, if
I just keep dragging and dropping using the OWC UI
Anyone got any ideas what's going on ? Is the OWC not cross joining
dimensions when I drag them in ?

Omer

Add LOG FILE property in the Connection String as shown in
the following example.

PivotTable1.ConnectionString = "Provider=MSOLAP.2;Data
Source=SERVERNAME;Initial Catalog=FoodMart 2000;log
file=c:\MDXQUERY.txt;"
PivotTable1.DataMember = "sales"

The MDX Queries used by the OWC will get appended in the
C:\MDXQUERY.txt file.

HTH.

Cheers,
Sanka

Hi Sanka
I've already done this and the query comming out is very VERY daunting!! Is
there an easier way ?
Are there any guidelines which can be followed when writing the MDX which
will keep the performance reasonable ?
Omer


"Sanka" <loonysan (AT) mailcity (DOT) com> wrote