OWC and accessing the PivotTable MDX code?

• peterzeke

  SSCrazy Eights

  Points: 9003

  More actions

  August 20, 2004 at 11:47 am

  #109386

  I am using the OWC pivot table for a potential web based report. I want to capture the MDX that the pivot table is generating. Is there a way to get the MDX from the OWC?

  --Pete

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  August 21, 2004 at 5:34 am

  #520088

  You could always turn the logging on whilse you build your report.  Find the *.oqy file and set the log file property.

  The oqy's are normally found in your documents and settings dirs e.g. --> C:\Documents and Settings\steven\Application Data\Microsoft\Queries

  The log file setting is just added to the connection property e.g. --> Connection=Provider=MSOLAP.2;Data Source=localhost;Initial Catalog=FoodMart 2000;Client Cache Size=25;Auto Synch Period=10000;Log File=C:\MyMDXLog.txt;

  Steve.