Post reply

OWC and accessing the PivotTable MDX code?

  • 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

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply