MDX Script Performance Analyserhttp://mdxscriptperf.codeplex.com/project/feeds/rssReviewed: Release 0.2 (Sep 16, 2015)https://mdxscriptperf.codeplex.com/releases/view/17233#ReviewBy-jakubkRated 4 Stars &#40;out of 5&#41; - Good once you figure out how to use it &#40;could use some doco and use case examples&#41;&#10;&#10;Eg when testing a particular calculated measure it obviously jumps to 100&#37; of elapsed time once the definition for that calc is reached in the script&#10;So say you&#39;ve got a calc member that does an iif test for null then multiplies 3 other measures and your definition is &#10;currentcube.measuretotest &#61; iif&#40;nulltest,null,measure.a&#42;measure.b&#42;measure.c&#41;&#59;&#10;&#10;One trick to use is&#10;scope&#40;measure.measuretotest&#41;&#59;&#10;this &#61; iif&#40;nulltest,null,1&#41;&#59;&#10;this &#61; measuretotest &#42; measure.a&#59;&#10;this &#61; measuretotest &#42; measure.b&#59;&#10;this &#61; measuretotest &#42; measure.c&#59;&#10;end scope&#59;&#10;&#10;this way as this app iterates through each line you&#39;ll see the effects of each separate operation at a more granular level&#10;jakubkThu, 17 Sep 2015 02:48:45 GMTReviewed: Release 0.2 (Sep 16, 2015) 20150917024845ASource code checked in, #94877http://mdxscriptperf.codeplex.com/SourceControl/changeset/changes/94877Upgrade&#58; New Version of LabDefaultTemplate.xaml. To upgrade your build definitions, please visit the following link&#58; http&#58;&#47;&#47;go.microsoft.com&#47;fwlink&#47;&#63;LinkId&#61;254563Project Collection Service AccountsMon, 01 Oct 2012 22:38:35 GMTSource code checked in, #94877 20121001103835PSource code checked in, #94876http://mdxscriptperf.codeplex.com/SourceControl/changeset/changes/94876Checked in by server upgradeProject Collection Service AccountsMon, 01 Oct 2012 22:31:06 GMTSource code checked in, #94876 20121001103106PUpdated Release: Release 0.2 (Sep 11, 2008)http://mdxscriptperf.codeplex.com/releases/view/17233<div class="wikidoc">Release 0.2 is the first release that supports Analysis Services 2008. There is a separate EXE for AS2005 and AS2008.<br /><br />The only other change in this release is running queries in a background thread so that the UI is more responsive to cancelling the execution midstream.<br /><br />Update 4/8/2012: Analysis Services 2012 build has been added.</div><div class="ClearBoth"></div>furmanggSun, 08 Apr 2012 19:51:38 GMTUpdated Release: Release 0.2 (Sep 11, 2008) 20120408075138PReleased: Release 0.2 (Sep 11, 2008)http://mdxscriptperf.codeplex.com/releases/view/17233
<div class="wikidoc">Release 0.2 is the first release that supports Analysis Services 2008. There is a separate EXE for AS2005 and AS2008.<br>
<br>
The only other change in this release is running queries in a background thread so that the UI is more responsive to cancelling the execution midstream.<br>
<br>
Update 4/8/2012: Analysis Services 2012 build has been added.</div>
<div></div>
Sun, 08 Apr 2012 19:51:38 GMTReleased: Release 0.2 (Sep 11, 2008) 20120408075138PUpdated Release: Release 0.2 (Sep 11, 2008)http://mdxscriptperf.codeplex.com/releases/view/17233<div class="wikidoc">Release 0.2 is the first release that supports Analysis Services 2008. There is a separate EXE for AS2005 and AS2008.<br /><br />The only other change in this release is running queries in a background thread so that the UI is more responsive to cancelling the execution midstream.</div><div class="ClearBoth"></div>furmanggSun, 08 Apr 2012 19:50:59 GMTUpdated Release: Release 0.2 (Sep 11, 2008) 20120408075059PUpdated Release: Release 0.2 (Sep 11, 2008)http://mdxscriptperf.codeplex.com/releases/view/17233<div class="wikidoc">Release 0.2 is the first release that supports Analysis Services 2008. There is a separate EXE for AS2005 and AS2008.<br /><br />The only other change in this release is running queries in a background thread so that the UI is more responsive to cancelling the execution midstream.</div><div class="ClearBoth"></div>furmanggSun, 08 Apr 2012 19:50:33 GMTUpdated Release: Release 0.2 (Sep 11, 2008) 20120408075033PSource code checked in, #88993http://mdxscriptperf.codeplex.com/SourceControl/changeset/changes/88993build for AS2012furmanggSun, 08 Apr 2012 19:49:16 GMTSource code checked in, #88993 20120408074916PNew Post: error on ssas r2http://mdxscriptperf.codeplex.com/discussions/284327<div style="line-height: normal;"><p>Good day.<br />Yes... this is my mistake thank you very much for help with.</p></div>dedyyshkaThu, 29 Dec 2011 05:36:08 GMTNew Post: error on ssas r2 20111229053608ANew Post: error on ssas r2http://mdxscriptperf.codeplex.com/discussions/284327<div style="line-height: normal;"><p>Go to the Downloads tab and make sure you're downloading the 2008 version, not the 2005 version.</p></div>furmanggWed, 28 Dec 2011 16:18:13 GMTNew Post: error on ssas r2 20111228041813PNew Post: error on ssas r2http://mdxscriptperf.codeplex.com/discussions/284327<div style="line-height: normal;"><p>Good day.</p>
<p>When trying to connect to the server get error:</p>
<p>System.IO.FileNotFoundException: Could not load file or assembly "Microsoft.AnalysisServices, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" Can not find the file specified.<br /> "Microsoft.AnalysisServices, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"<br /> &nbsp;MDXScriptPerformance.frmMDXScript.btnConnect_Click(Object sender, EventArgs e)<br /> &nbsp;System.Windows.Forms.Control.OnClick(EventArgs e)<br /> &nbsp;System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)<br /> &nbsp;System.Windows.Forms.Control.WmMouseUp(Message&amp; m, MouseButtons button, Int32 clicks)<br /> &nbsp;System.Windows.Forms.Control.WndProc(Message&amp; m)<br /> &nbsp;System.Windows.Forms.ButtonBase.WndProc(Message&amp; m)<br /> &nbsp;System.Windows.Forms.Button.WndProc(Message&amp; m)<br /> &nbsp;System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp; m)<br /> &nbsp;System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)</p>
<p>
<hr />
</p>
<p>&nbsp;Ssas 10.50.2789.0(X64) on Windows NT 6.0 &lt;X64&gt; (Build 6002: Service Pack 2)</p>
<p>&nbsp;</p></div>dedyyshkaWed, 28 Dec 2011 08:40:46 GMTNew Post: error on ssas r2 20111228084046ACommented Issue: MDX Performance Tool for SQL 2008 R2 [16597]http://mdxscriptperf.codeplex.com/workitem/16597Hello&#58;<br /><br />I am running this MDX for SQL Server&#92;Analysis Server 2008 R2 version. When i run MDX query in script window, i am getting no results. i run like 4 to 5 small ones &#38; large ones. same response, no results.<br /><br />I have attached trace file with this, for further investigation.<br /><br />Any help is greatly appreciated, Thanking in advance.<br /><br />Thanks<br />Comments: ** Comment from web user: aaditya2000 ** <p>Hello&#58;</p><p>The query is running fine when ran in SSMS. it takes 17 mins to complete. but runs with no errors &#38; returns result set with some 2000 rows.</p><p>So i am not sure where the problem is. it works fine in SSMS but doesn&#39;t works from your tool &#38; give timeout message in less than 1 min.</p><p>Thanks<br />Regards</p>aaditya2000Thu, 29 Sep 2011 03:59:15 GMTCommented Issue: MDX Performance Tool for SQL 2008 R2 [16597] 20110929035915ACommented Issue: MDX Performance Tool for SQL 2008 R2 [16597]http://mdxscriptperf.codeplex.com/workitem/16597Hello&#58;<br /><br />I am running this MDX for SQL Server&#92;Analysis Server 2008 R2 version. When i run MDX query in script window, i am getting no results. i run like 4 to 5 small ones &#38; large ones. same response, no results.<br /><br />I have attached trace file with this, for further investigation.<br /><br />Any help is greatly appreciated, Thanking in advance.<br /><br />Thanks<br />Comments: ** Comment from web user: furmangg ** <p>You&#39;re making progress. It doesn&#39;t look like the cube is processing while you&#39;re running the test. </p><p>But it looks like you&#39;re still getting that same error when running the query&#58; The set in the WHERE clause cannot contain multiple measures.</p><p>When you run that query from Management Studio do you get the same error&#63;</p><p>Again, I would recommend you try commenting out large parts of the MDX script and test the query. If I&#39;m seeing the full MDX script in the profiler trace, your MDX script isn&#39;t very long, so it shouldn&#39;t be too bad to manually comment out and deploy the MDX script to test.</p>furmanggTue, 27 Sep 2011 22:22:55 GMTCommented Issue: MDX Performance Tool for SQL 2008 R2 [16597] 20110927102255PCommented Issue: MDX Performance Tool for SQL 2008 R2 [16597]http://mdxscriptperf.codeplex.com/workitem/16597Hello&#58;<br /><br />I am running this MDX for SQL Server&#92;Analysis Server 2008 R2 version. When i run MDX query in script window, i am getting no results. i run like 4 to 5 small ones &#38; large ones. same response, no results.<br /><br />I have attached trace file with this, for further investigation.<br /><br />Any help is greatly appreciated, Thanking in advance.<br /><br />Thanks<br />Comments: ** Comment from web user: aaditya2000 ** <p>Hello&#58;</p><p>Thank you for your kind help on this issue. i restore database to my test server &#38; run the tool &#38; again, it didn&#39;t dispaly any result.<br />When i run same query in SSMS, it return resultset.</p><p>But the problem is with this tool, which doesn&#39;t dispaly anything on report. &#40;blank report&#41;</p><p>I have attached profiler trace.</p><p>Any help will be great,.</p><p>thanks<br />regards</p>aaditya2000Mon, 26 Sep 2011 21:18:20 GMTCommented Issue: MDX Performance Tool for SQL 2008 R2 [16597] 20110926091820PCommented Issue: MDX Performance Tool for SQL 2008 R2 [16597]http://mdxscriptperf.codeplex.com/workitem/16597Hello&#58;<br /><br />I am running this MDX for SQL Server&#92;Analysis Server 2008 R2 version. When i run MDX query in script window, i am getting no results. i run like 4 to 5 small ones &#38; large ones. same response, no results.<br /><br />I have attached trace file with this, for further investigation.<br /><br />Any help is greatly appreciated, Thanking in advance.<br /><br />Thanks<br />Comments: ** Comment from web user: furmangg ** <p>Thanks for supplying more information. I see several problems&#58;</p><p>1. I see the following trace event hundreds of thousands of times. I believe that indicates that the cube in question is currently being processed. First, I would run MDX Script Performance against a dev environment that&#39;s not currently processing the cube and not currently being queried by other users. It&#39;s not that MDX Script Performance will hurt processing or hurt other users... it&#39;s that you can&#39;t trust the results if other things are happening on that box. And with the cube being processed, depending on how that&#39;s done, the cube may not be queryable at that moment. Anyway, the event I mentioned was&#58;</p><p>Errors in the OLAP storage engine&#58; The attribute key cannot be found when processing&#58; Table&#58; &#39;PANAMA_NRDB_RISK_FACT&#39;, Column&#58; &#39;ID_VALUE_DATE&#39;, Value&#58; &#39;780&#39;. The attribute is &#39;valueDate&#39;. Errors in the OLAP storage engine&#58; The record was skipped because the attribute key was not found. Attribute&#58; valueDate of Dimension&#58; Value Date from Database&#58; Trade_Global, Cube&#58; Trade_Global, Measure Group&#58; Risk Fact, Partition&#58; APC MX, Record&#58; 1393468.</p><p><br />2. You are receiving the following error message when you run your query, &#34;The set in the WHERE clause cannot contain multiple measures.&#34; I don&#39;t see multiple measures in the where clause of your query. The where clause is&#58;<br />WHERE &#40;&#91;ProcessSource&#93;.&#91;scenarioName&#93;.&#38;&#91;EOD&#93;, &#123;&#91;Book&#93;.&#91;region&#93;.&#91;region&#93;.&#38;&#91;NA&#93;&#125;,&#123;&#91;Product Type&#93;.&#91;productGroup&#93;.&#91;productGroup&#93;.&#38;&#91;CDS&#93;,&#91;Product Type&#93;.&#91;productGroup&#93;.&#91;productGroup&#93;.&#38;&#91;INDEX&#93;,&#91;Product Type&#93;.&#91;productGroup&#93;.&#91;productGroup&#93;.&#38;&#91;RATES&#93;&#125;,&#123;&#91;Book&#93;.&#91;bookTrader&#93;.&#91;bookTrader&#93;.&#38;&#91;JASON WEN&#93;&#125;,&#123;&#91;Trade&#93;.&#91;ccy&#93;.&#91;ccy&#93;.&#38;&#91;USD&#93;&#125;,&#123;&#91;Trade&#93;.&#91;tradeStatusDaily&#93;.&#91;tradeStatusDaily&#93;.&#38;&#91;CLOSED&#93;,&#91;Trade&#93;.&#91;tradeStatusDaily&#93;.&#91;tradeStatusDaily&#93;.&#38;&#91;NEW&#93;,&#91;Trade&#93;.&#91;tradeStatusDaily&#93;.&#91;tradeStatusDaily&#93;.&#38;&#91;UPDATED&#93;&#125;, &#91;Value Date&#93;.&#91;valueDate&#93;.&#38;&#91;777&#93;, &#91;Measures&#93;.&#91;ChgOnDayUSD&#93;&#41; <br />In researching this error message, I noticed this KB article&#58; http&#58;&#47;&#47;support.microsoft.com&#47;kb&#47;947511<br />I couldn&#39;t reproduce that error against Adventure Works on AS2008 R2 version 10.50.1600. When you connect Object Explorer in SSMS to Analysis Services, what version number does it say on the server node&#63;<br />Can you double check that MDX query succeeds when run from Management Studio. If it doesn&#39;t even succeed from Management Studio, there&#39;s no point using MDX Script Performance. If it does succeed in Management Studio, is there a calculated dimension member in the where clause that&#39;s causing the error&#63;</p><p>Hopefully the above information helps you troubleshoot what&#39;s going on. If all else fails and your query uses a calculated dimension member that&#39;s defined near the bottom of the MDX script, you might just have to manually troubleshoot the query by deploying the MDX script to a dev environment with large parts of it commented out.</p>furmanggSat, 24 Sep 2011 14:11:10 GMTCommented Issue: MDX Performance Tool for SQL 2008 R2 [16597] 20110924021110PNew Post: MDXScriptPerformance2008.exehttp://mdxscriptperf.codeplex.com/discussions/273119<div style="line-height: normal;"><p>Hello:</p>
<p>Any reply on issue tracker is greatly appreciated.</p>
<p>Thanks</p></div>aaditya2000Thu, 22 Sep 2011 22:36:23 GMTNew Post: MDXScriptPerformance2008.exe 20110922103623PNew Post: MDXScriptPerformance2008.exehttp://mdxscriptperf.codeplex.com/discussions/273119<div style="line-height: normal;"><p>Hello:</p>
<p>new issue started at tracker &amp; uploaded profile trace. Thank you for your help.</p>
<p>Thanks</p>
<p>Regards</p></div>aaditya2000Tue, 20 Sep 2011 15:47:09 GMTNew Post: MDXScriptPerformance2008.exe 20110920034709PCreated Issue: MDX Performance Tool for SQL 2008 R2 [16597]http://mdxscriptperf.codeplex.com/workitem/16597Hello&#58;<br /><br />I am running this MDX for SQL Server&#92;Analysis Server 2008 R2 version. When i run MDX query in script window, i am getting no results. i run like 4 to 5 small ones &#38; large ones. same response, no results.<br /><br />I have attached trace file with this, for further investigation.<br /><br />Any help is greatly appreciated, Thanking in advance.<br /><br />Thanks<br />aaditya2000Mon, 19 Sep 2011 22:52:00 GMTCreated Issue: MDX Performance Tool for SQL 2008 R2 [16597] 20110919105200PNew Post: MDXScriptPerformance2008.exehttp://mdxscriptperf.codeplex.com/discussions/273119<div style="line-height: normal;"><p>It should work with R2. Can you run Profiler, connect to SSAS, then run the MDXScriptPerformance tool. After that's done, if you could save the profiler output to a file, start a new issue on the Issue Tracker tab and attach the profiler file, hopefully we can help you get to the bottom of this problem.</p>
<p>&nbsp;</p></div>furmanggMon, 19 Sep 2011 21:24:21 GMTNew Post: MDXScriptPerformance2008.exe 20110919092421PNew Post: MDXScriptPerformance2008.exehttp://mdxscriptperf.codeplex.com/discussions/273119<div style="line-height: normal;">
<p>Hello:</p>
<p>I am running this MSX for SQL Server\Analysis Server 2008 R2 version. When i run MDX query in script window, i am getting no results. i run like 4 to 5 small ones &amp; large ones. same response, no results.</p>
<p>Is this MDX works for SQL 2008 R2?</p>
<p>Any help is greatly appreciated, Thanking in advance.</p>
<p>Thanks</p>
</div>aaditya2000Mon, 19 Sep 2011 20:04:54 GMTNew Post: MDXScriptPerformance2008.exe 20110919080454P