Microsoft Dynamics AX Technical Support Blog : Reporting, OLAPhttp://blogs.msdn.com/b/emeadaxsupport/archive/tags/Reporting/OLAP/Tags: Reporting, OLAPen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)Opening a Report on AX 2012 raises infolog error: The default Report Server Configuration ID could not be found in the SRSServers table.http://blogs.msdn.com/b/emeadaxsupport/archive/2011/12/01/opening-a-report-on-ax-2012-raises-infolog-error-the-default-report-server-configuration-id-could-not-be-found-in-the-srsservers-table.aspxThu, 01 Dec 2011 18:13:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10243437EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10243437http://blogs.msdn.com/b/emeadaxsupport/archive/2011/12/01/opening-a-report-on-ax-2012-raises-infolog-error-the-default-report-server-configuration-id-could-not-be-found-in-the-srsservers-table.aspx#comments<p>Consider the following scenario:</p>
<p>- You have one Microsoft Dynamics AX 2012 AOS instance fully configured, and users are able to open reports from the AX client connecting to this instance.</p>
<p>- You now add an additional AOS instance.</p>
<p>- Users connecting to the additional/new AOS instance get the following infolog error when trying to open an SSRS report:</p>
<div style="color: red; margin-right: 40px; margin-left: 40px;">The default Report Server Configuration ID could not be found in the SRSServers table<span style="color: #ff0000;">.</span></div>
<div style="color: red; margin-right: 40px; margin-left: 40px;"><br /><a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-13-88/6607.ConfigID_5F00_Error_5F00_SRSServers_5F00_table2.png"><img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-13-88/6607.ConfigID_5F00_Error_5F00_SRSServers_5F00_table2.png" /></a></div>
<p></p>
<p>The error occurs because you need to add the new AOS server instance to the Report Servers form.</p>
<p>&nbsp;</p>
<p>(1) Create a new report Server Configuration, with a new ID</p>
<p>(2( Follow through the steps given at <a href="http://technet.microsoft.com/en-us/library/hh389773.aspx">http://technet.microsoft.com/en-us/library/hh389773.aspx</a> and ensure under the <strong>Application Object Server information</strong> drop-down box, you select the new AOS instance.</p>
<p>&nbsp;<a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-13-88/0456.ConfigID_5F00_Error_5F00_SRSServers_5F00_table.png"><img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-13-88/0456.ConfigID_5F00_Error_5F00_SRSServers_5F00_table.png" /></a></p>
<p>&nbsp;</p>
<table border="0">
<tbody>
<tr>
<td>--author:</td>
<td>Anup Shah</td>
</tr>
<tr>
<td>--editor:</td>
<td>Anup Shah</td>
</tr>
<tr>
<td>--date:</td>
<td>01/Dec/2011</td>
</tr>
</tbody>
</table><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10243437" width="1" height="1">ReportingAX2012SRSServersConfiguration IDMicrosoft Dynamics AX 2012 Reporting Services – Scale-out deploymentshttp://blogs.msdn.com/b/emeadaxsupport/archive/2011/11/27/microsoft-dynamics-ax-2012-reporting-services-scale-out-deployments.aspxSun, 27 Nov 2011 14:53:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10241795EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10241795http://blogs.msdn.com/b/emeadaxsupport/archive/2011/11/27/microsoft-dynamics-ax-2012-reporting-services-scale-out-deployments.aspx#comments<p>As mentioned in this blog&nbsp; <a href="http://technet.microsoft.com/en-us/library/hh389760.aspx">http://technet.microsoft.com/en-us/library/hh389760.aspx</a> it is possible to have multiple instances of Reporting Services on the same computer. This is meant in situations to support development and production installations of Microsoft Dynamics AX, or to support multiple production installations of Microsoft Dynamics AX.</p>
<p>When there are different instances of Reporting Services for AX2012 the load is not spread over these instances therefore not allowing for high availability or scaled out deployments. We have seen recently some questions on how this should be done when there is a high load of SSRS activity and one SSRS instance is not enough. <br />&nbsp;<br /><strong>The answer to this to cope with a high load is to use SQL Reporting Scale-out deployments. As described here:</strong><br /><strong><a href="http://technet.microsoft.com/en-us/library/dd309577.aspx">http://technet.microsoft.com/en-us/library/dd309577.aspx</a>&nbsp;</strong><br />&nbsp;<br /><br />&nbsp;<br /><span style="text-decoration: underline;">In Summary here are the steps you need to use scaled out deployments with AX2012:</span><br />&nbsp;</p>
<p>For SQL Reporting Scale-out deployment you will need Enterprise edition instead of Standard. Full details on configuring SQL reporting Services is detailed on TechNet: <a title="How to: Configure a Report Server Scale-Out Deployment (Reporting Services Configuration)" href="http://technet.microsoft.com/en-us/library/ms159114.aspx" target="_blank">How to: Configure a Report Server Scale-Out Deployment (Reporting Services Configuration)</a></p>
<p><br />&bull;&nbsp;First you need to set up your Report server in Scaled out deployment. Basically the means you are connecting multiple SSRS Reports servers against the same SSRS database. When you deploy reports in a scaled out environment the reports will appear on all SSRS servers that are installed in this scaled out deployment, after you have deployed them on only one SSRS server</p>
<p>&bull;&nbsp;Be careful that your reports does not require any other components installed on the server. If so, you must make sure that this external component is properly installed on all servers.</p>
<p>&bull;&nbsp;Now you need to create an Network load Balanced (NLB) cluster in front of these servers. You can do this with Windows NLB or with a hardware NLB switch. You must configure your AX report server to point to this NLB address. Know when a client, EP, Role center or anyone else enters the URL for the NLB cluster the load balance will happen according to the rules for the NLB cluster</p>
<p>&bull;&nbsp;By now you have created a NLB cluster that will load balance your reports, but be aware that you also need to do this for the AOS servers. The AOS Cluster load balance mechanism will work when you access using RPC on port 2712..2811. But reports are executing using services that uses WSDL on ports 8101&hellip;8200. <strong>The WSDL ports are NOT part of the AOS cluster,</strong>&nbsp; a similar NLB cluster must be created in front of the AOS in order for these server to respond as load balance. See <a title="Configuring network load balancing for services [AX 2012]" href="http://technet.microsoft.com/en-us/library/hh397322.aspx" target="_blank">Configuring network load balancing for services [AX 2012]</a> for more details</p>
<p><br />&nbsp;</p>
<p><a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-13-88/8738.ScaledOutReportDeployment.jpg"><img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-13-88/8738.ScaledOutReportDeployment.jpg" /></a></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<table border="0">
<tbody>
<tr>
<td>--author:</td>
<td>Charlotte Rowe</td>
</tr>
<tr>
<td>--editor:</td>
<td>Anup Shah</td>
</tr>
<tr>
<td>--date:</td>
<td>27/Nov/2011</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<p></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10241795" width="1" height="1">ReportingAX2012multiple instancesscale-outclusterMicrosoft Dynamics AX 2012: Install multiple instances of Reporting Services extensions on the same machinehttp://blogs.msdn.com/b/emeadaxsupport/archive/2011/09/22/microsoft-dynamics-ax-2012-install-multiple-instances-of-reporting-services-extensions-on-the-same-machine.aspxThu, 22 Sep 2011 14:13:48 GMT91d46819-8472-40ad-a661-2c78acb4018c:10215321EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10215321http://blogs.msdn.com/b/emeadaxsupport/archive/2011/09/22/microsoft-dynamics-ax-2012-install-multiple-instances-of-reporting-services-extensions-on-the-same-machine.aspx#comments<p>With Microsoft Dynamics AX 2009 we do not support the setup where we have several instances of SQL Reporting Services on the same box connecting to different AOS. The reporting extensions always made connection to AOS mentioned in current configuration taken from Dynamics AX 2009 Configuration Utility. There is no way to change it. The only solution is to have several machines (virtualization).</p> <p>Fortunately with Microsoft Dynamics AX 2012&#160; it is changing. We have the way to implement it. The only requirements is that we have separate instance for each AOS to which we want to connect. More info you can find on TechNet site: <a href="http://technet.microsoft.com/en-us/library/hh389760.aspx">http://technet.microsoft.com/en-us/library/hh389760.aspx</a></p> <p> <table border="0"><tbody> <tr> <td>--author:</td> <td>Czesława Langowska Vliegen</td> </tr> <tr> <td>--editor:</td> <td>Czesława Langowska Vliegen</td> </tr> <tr> <td>--date:</td> <td>22/Sep/2011</td> </tr> </tbody></table></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10215321" width="1" height="1">ReportingAX 2009DeploymentInstallationReportSRSreportsAX2009TechNetYou cannot print images on batch reports in AX2009? - Now you can !!http://blogs.msdn.com/b/emeadaxsupport/archive/2011/09/19/you-cannot-print-images-on-batch-reports-now-you-can.aspxMon, 19 Sep 2011 08:16:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10213345EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10213345http://blogs.msdn.com/b/emeadaxsupport/archive/2011/09/19/you-cannot-print-images-on-batch-reports-now-you-can.aspx#comments<p>With Microsoft Dynamics AX 2009 we introduced the new Batch Framework with a lot of advantages compared to the Batch functionality of the former AX versions.<br />But there was also one disatvantage: It was not possible to print reports or generate PDF files in batch processing if the reports contained images.</p>
<p>This issue has now been addressed in a Hotfix and it's possible to generate reports with images on the batch server.<br />The Hotfix is available here: <a href="https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?wtntzsmnwukntmmytpnryvznnpwyswvqonooknnwynnquxsq" target="_blank">KB2604303</a>&nbsp;</p>
<p><em><strong>Note<br /></strong></em>This hoftix is a follow-up Hotfix which solves an issue introduced with the original Hotfix for this issue <a title="KB2584721" href="https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?wtntzsmnwukntmmyoyzuvnyunluztwzspzrtlnzqsmqkvsru">KB2584721</a>.<br />Please be aware that this is a hybrid hotfix which means that there have been made changes to the kernel AND the application. You must install the kernel part AND the Application part of this hotfix to make it working correctly.</p>
<p><strong><em>Affected objects<br /></em></strong>Ax32.exe<br />Ax32Serv.exe<br />\Classes\PDFViewer.xpo<br />\Classes\WinAPIServer.xpo</p>
<p>&nbsp;</p>
<table border="0">
<tbody>
<tr>
<td>--author:</td>
<td>Daniel Durrer</td>
</tr>
<tr>
<td>--editor:</td>
<td>Daniel Durrer</td>
</tr>
<tr>
<td>--date:</td>
<td>21/Oct/2011</td>
</tr>
</tbody>
</table><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10213345" width="1" height="1">ReportingSolutionPDFAX2009BarcodeCode128 and Tilde Characterhttp://blogs.msdn.com/b/emeadaxsupport/archive/2011/05/17/barcodecode128-and-tilde-character.aspxTue, 17 May 2011 08:34:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10165264EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10165264http://blogs.msdn.com/b/emeadaxsupport/archive/2011/05/17/barcodecode128-and-tilde-character.aspx#comments<p>Recently we came across an issue with BarcodeCode128 barcodes - when using a tilde character (~) within a BarcodeCode128 barcode in AX the resulting barcode can be unreadable by scanners. </p>
<p>The reason for this is that Code128 has three different code sets associated with it &ndash; using an escape character in the barcode string to switch between these code sets. Different applications do this in different ways using different characters, in AX we use the tilde character to inform the program that we want to use another code set. </p>
<p>Once AX has picked up a tilde it expects to receive a specific value next in the barcode string: c, d, e, f, or g, these are the control characters which have the ASCII numerical value of 99-105 which will change the code set and create the first few bars of the barcode which tell the reader which code set is being used and continue on to create a new barcode.</p>
<p>If a different character is placed after the tilde (anything other than c, d, e, f, or g) then it never finds the desired code set, doesn&rsquo;t create the first few lines of the barcode that tell the reader what it is supposed to be reading and leads to an unreadable barcode &ndash; it does not produce an error, it will simply create a corrupted barcode, which is why it is important to understand this process.</p>
<p>Here you can see the corrupted barcode, on the right hand side they are identical, however the beginning has been entirely left out in the ~A example:</p>
<p>With the barcode string "~A":</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-13-88/3704.brokenbarcode.png"><img height="189" width="278" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-13-88/3704.brokenbarcode.png" border="0" /></a>&nbsp;</p>
<p>With the barcode string "~gA":</p>
<p><a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-13-88/5751.woringbarcode.png"><img height="196" width="321" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-13-88/5751.woringbarcode.png" border="0" /></a>&nbsp;</p>
<p>When entering the value ~gA (~ = escape character, g = control character instigating code set B) then barcode is readable and displays &lsquo;A&rsquo; as with the second example above.<br />It is important to either keep tildes out of barcodes where possible or &ndash; if you must have tildes in your barcode strings then you would need to write a modification, bear in mind that any changes here may cause further problems in the future when using the BarcodeCode128 class for its original purpose. The specific place where this logic is used is: Classes\BarcodeCode128.encodeString()</p>
<p>Specifically the following line where the escChar parameter holds the value 126 (tilde):</p>
<p>
<div style="background-color: lightgray; font-family: courier new; font-size: 8pt; padding: 5px;">if ((charVal == #escChar) &amp;&amp; (char2num(textcvt, tichr+1) != 0))&nbsp;&nbsp; // tilda character #126</div>
</p>
<p><a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-13-88/5751.woringbarcode.png"></a></p>
<table border="0">
<tbody>
<tr>
<td>--author:</td>
<td>Nikita Hickson</td>
</tr>
<tr>
<td>--editor:</td>
<td>Nikita Hickson</td>
</tr>
<tr>
<td>--date:</td>
<td>17/May/2011 </td>
</tr>
</tbody>
</table><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10165264" width="1" height="1">ReportingAX 4.0AX 2009PrintingReportprintertildereportsbarcodecode128barcodeSome reports from Reporting extensions can raise error when running on SQL 2008 R2http://blogs.msdn.com/b/emeadaxsupport/archive/2011/03/18/some-reports-from-reporting-extensions-can-raise-error-when-running-on-sql-2008-r2.aspxFri, 18 Mar 2011 15:00:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10143107EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10143107http://blogs.msdn.com/b/emeadaxsupport/archive/2011/03/18/some-reports-from-reporting-extensions-can-raise-error-when-running-on-sql-2008-r2.aspx#comments<p>Thanks to our colleague in Japan we found problem when running some Dynamics AX reporting extensions report on SQL 2008 R2. </p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt">When we open some standard SSRS reports with SQL2008R2 (ie. TSInvoicedPurchaseAmount.TS_InvoicedPurchaseAmountDetail.Report ), we receive following error. </p>
<div style="color: red; margin-left: 40px; margin-right: 40px">An error has occurred during report processing. (rsProcessingAborted) <br />Query execution failed for dataset 'InvoiceAmountDetailedReport'. (rsErrorExecutingCommand) <br />Query (58, 19) Parser: The syntax for 'Item' is incorrect. </div>
<p>This is because the <strong>Item</strong> is reserved word of MDX and execution is causing the error. So to fix the problem we need to change parameter name for DataSet 'InvoiceAmountDetailedReport'.</p>
<p>Fortunately there are already hotfixes which fixed this problems:</p>
<p><strong>KB2519061</strong> <br />TSInvoicedPurchaseAmount.TS_InvoicedPurchaseAmountDetail.Report <br />TSInvoicedPurchaseAmount.TS_InvoicedPurchaseAmountWebpart.Report </p>
<p><br /><strong>KB2520255</strong> <br />ProjCashFlow.ProjActualvsBudgetNetCashflow.XYChart <br />ProjCostControl.ProjTotalBudgetCost.LineChart <br />ProjHourUtilization.ProjUtilizationEfficiency.XYChart <br />ProjStatements.ProjActualvsBudgetConsumption.XYChart <br />ProjStatements.ProjActualvsBudgetCost.XYChart <br />ProjStatements.ProjActualvsBudgetGrossMargin.XYChart <br />ProjStatements.ProjActualvsBudgetNetWIP.XYChart <br />ProjStatements.ProjActualvsBudgetPayroll.XYChart <br />ProjStatements.ProjActualvsBudgetRevenue.XYChart</p>
<p>&nbsp;</p>
<p>Right now both hotfixes are not published so please contact Support Team to get both hotfixes.</p>
<p>&nbsp;</p>
<table border="0">
<tbody>
<tr>
<td>--author:</td>
<td><span style="font-family: 'Tahoma','sans-serif'; font-size: 10pt; mso-fareast-font-family: calibri; mso-fareast-theme-font: minor-latin; mso-ansi-language: en-us; mso-fareast-language: en-us; mso-bidi-language: ar-sa">Yuji Imaoka</span></td>
</tr>
<tr>
<td>--editor:</td>
<td>Czesława Langowska</td>
</tr>
<tr>
<td>--date:</td>
<td>
<p>18/March/2011</p>
</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</tbody>
</table><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10143107" width="1" height="1">Enterprise PortalReportingAnalysis ServicesAX 2009Measure 'Total purchases' in Accounts payable cubes for dimension 'Vendor Master' shows values Uknownhttp://blogs.msdn.com/b/emeadaxsupport/archive/2011/03/01/measure-total-purchases-in-accounts-payable-cubes-for-dimension-vendor-master-shows-values-uknown.aspxTue, 01 Mar 2011 13:37:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10135507EMEADAXSupport2http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10135507http://blogs.msdn.com/b/emeadaxsupport/archive/2011/03/01/measure-total-purchases-in-accounts-payable-cubes-for-dimension-vendor-master-shows-values-uknown.aspx#comments<p>Some time ago I run into problem that measure &lsquo;Total purchases&rsquo; for dimensions &lsquo;Vendor Master&rsquo; did not work. There was only values for attribute Uknown. So I was not able to see what was sum of vendor purchases for each vendor although I had bunch of Purchase Orders which were posted and invoiced. </p>
<p>First step to troubleshoot this issue was to find out what exactly query is hidden under measure &lsquo;Total purchases&rsquo; To do it in Business Intelligence Development Studio when you look into Source Property of &lsquo;Total Purchases&rsquo; measure:</p>
<p><a href="http://blogs.msdn.com/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-01-13-88-metablogapi/5518.image_5F00_42B53511.png"><img height="441" width="584" src="http://blogs.msdn.com/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-01-13-88-metablogapi/0827.image_5F00_thumb_5F00_16688860.png" alt="image" border="0" title="image" style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" /></a></p>
<p>You can that values are coming from VendTransTotalPurchase.AmountMST.</p>
<p>When you go to data source view Dynamics AX you will that VendTransTotalPurchase it is named query and you will be able to see query behind.</p>
<p>If you wan to change this query to get data for Vendor account number I got following:</p>
<div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">SELECT&nbsp;&nbsp;&nbsp;&nbsp; VENDTRANS.ACCOUNTNUM,&nbsp; sum(AMOUNTMST), VENDTRANS.DATAAREAID, VENDTABLE.NAME </div>
<div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">FROM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dbo.VENDTRANS, dbo.VENDTABLE </div>
<div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">WHERE&nbsp;&nbsp;&nbsp;&nbsp; (INVOICE &lt;&gt; '') and VENDTRANS.ACCOUNTNUM = VENDTABLE.ACCOUNTNUM and VENDTRANS.DATAAREAID = VENDTABLE.DATAAREAID </div>
<div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">group by VENDTRANS.ACCOUNTNUM, VENDTRANS.DATAAREAID, VENDTABLE.NAME</div>
<div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">order by VENDTRANS.DATAAREAID </div>
<p>If I run this query I could see correct values for each vendor, but still I could not see it in &lsquo;Vendor master&rsquo;. So my next step was to get closer look on Vendor Master dimension.</p>
<p>I found that when processing dimension Vendors master attribute Vendors (key) there is very long and very complex query which I will not copy here, but the most important was where expression which looked like:</p>
<div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">WHERE <br />&nbsp; ( <br />&nbsp;&nbsp;&nbsp; <br />&nbsp; ( <br />&nbsp;&nbsp; [VENDTABLE].[DATAAREAID]&nbsp;&nbsp; =&nbsp; [EMPLTABLE].[DATAAREAID] <br />&nbsp; ) <br />&nbsp;&nbsp;&nbsp;&nbsp; AND&nbsp; <br />&nbsp; ( <br />&nbsp;&nbsp; [VENDTABLE].[MAINCONTACTID]&nbsp;&nbsp; =&nbsp; [EMPLTABLE].[EMPLID] <br />&nbsp; ) <br /><br />&nbsp; ) </div>
<p>The I looked into my VENDTABLE and I saw that indeed the field MAINCONTACTID was not set up.</p>
<p><strong><span style="color: #ff0000;">Update (02 March 2011)</span></strong></p>
<p><span style="color: #ff0000;"><span style="color: #000000;">The binding between VENDTABLE and EMPTABLE you can see in DataSource view. If you look into relationship one of the relationship look like following:</span></span></p>
<p><span style="color: #ff0000;"><span style="color: #000000;"><img src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-01-13-88/7077.vend.png" border="0" /></span></span></p>
<p>In summary to solve problem I needed in Dynamics AX Client for each Vendor update field Main Contact on General tab (to assign employee to vendor &ndash; it can be dummy empl) after that processing Vendor master dimension and Accounts payable cube is needed. It worked !!!</p>
<table border="0">
<tbody>
<tr>
<td>--author:</td>
<td>Czesława Lagowska</td>
</tr>
<tr>
<td>--editor:</td>
<td>Czesława Langowska</td>
</tr>
<tr>
<td>--date:</td>
<td>
<p>1/March/2011</p>
</td>
</tr>
<tr>
<td>--edit:</td>
<td>2/March/2011</td>
</tr>
</tbody>
</table><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10135507" width="1" height="1">CubeOLAPAnalysis ServicesAX 2009SolutionDynamics AX Business Intelligence bloghttp://blogs.msdn.com/b/emeadaxsupport/archive/2011/03/01/dynamics-ax-business-intelligence-blog.aspxTue, 01 Mar 2011 12:57:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10135495EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10135495http://blogs.msdn.com/b/emeadaxsupport/archive/2011/03/01/dynamics-ax-business-intelligence-blog.aspx#comments<p>I run into this blog some time ago. It is lead by Saveen Reddy who is Product Manager for Dynamics AX Business Intelligence. On his blog you will find the bunch of screen cast which will help you to develop reports: <a href="http://blogs.msdn.com/b/dynamicsaxbi/archive/2010/12/01/ax-ssrs-reporting-screencast-list.aspx">http://blogs.msdn.com/b/dynamicsaxbi/archive/2010/12/01/ax-ssrs-reporting-screencast-list.aspx</a> as well some sneak previews regarding Dynamics AX 2012 and BI.</p>
<p>Blog: <a href="http://blogs.msdn.com/b/dynamicsaxbi/">http://blogs.msdn.com/b/dynamicsaxbi/</a></p>
<p>Have fun reading!</p>
<p>&nbsp;</p>
<table border="0">
<tbody>
<tr>
<td>--author:</td>
<td>Czesława Lagowska</td>
</tr>
<tr>
<td>--editor:</td>
<td>Czesława Langowska</td>
</tr>
<tr>
<td>--date:</td>
<td>1/March/2011</td>
</tr>
</tbody>
</table><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10135495" width="1" height="1">CubeOLAPReportingAX 2009AX2012SRSDocumentation "How to: Add a URL Drill Through Action" confusinghttp://blogs.msdn.com/b/emeadaxsupport/archive/2011/02/23/documentation-quot-how-to-add-a-url-drill-through-action-quot-confusing.aspxWed, 23 Feb 2011 12:36:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10133054EMEADAXSupport1http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10133054http://blogs.msdn.com/b/emeadaxsupport/archive/2011/02/23/documentation-quot-how-to-add-a-url-drill-through-action-quot-confusing.aspx#comments<p>Recently we found an "Invalid Range" error to logged when using drill through on an AX SRS Report we created for a custom table following the documentation at the link below:</p>
<p>&nbsp;&nbsp;&nbsp; "How to: Add a URL Drill Through Action"&nbsp;<a href="http://msdn.microsoft.com/en-US/library/cc582049.aspx">http://msdn.microsoft.com/en-US/library/cc582049.aspx</a></p>
<p>From further investigation we found the the hardcoded 1 at indexFields.Add method from the code below to be the cause. The number is&nbsp;not referencing the order of the fields in the unique (composit) index but is a reference to the fieldnumber of the field in the table. For CustTable accountNumber used in the sample code this appear to be 1. For fields in custom tables&nbsp;this is rarely the case <br /><br />Just to clear up the confusion.</p>
<div style="BACKGROUND-COLOR: lightgray; FONT-FAMILY: Courier New; PADDING: 5px 5px 5px 5px">[DataMethod(), AxSessionPermission(SecurityAction.Assert)]<br />public static string AccountNumberUrl(string context, string accountNumber)<br />{<br />&nbsp;&nbsp;&nbsp; Dictionary&lt;int, object&gt; indexFields = new Dictionary&lt;int, object&gt;();<br />&nbsp;&nbsp;&nbsp; indexFields.Add(1, accountNumber);<br />&nbsp;&nbsp;&nbsp; int tableId = 77;
<p>&nbsp;&nbsp;&nbsp; // Check whether the context is the client. If so, generate a<br />&nbsp;&nbsp;&nbsp; // URL to display the CustTable form.<br />&nbsp;&nbsp;&nbsp; if (RuntimeReportContext.IsClientContext(context))<br />&nbsp;&nbsp;&nbsp; {<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return DynaLink.GenerateURL(context, "CustTable", MenuItemType.Display, tableId, indexFields);<br />&nbsp;&nbsp;&nbsp; }</p>
<p>&nbsp;&nbsp;&nbsp; // Check whether the context is EP. If so, generate a URL to<br />&nbsp;&nbsp;&nbsp; // display the EPCustTableInfo Web menu item.<br />&nbsp;&nbsp;&nbsp; else if (RuntimeReportContext.IsEPContext(context))<br />&nbsp;&nbsp;&nbsp; {<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return DynaLink.GenerateURL(context, "EPCustTableInfo", MenuItemType.WebMenuItemTypeUrl, tableId, indexFields);<br />&nbsp;&nbsp;&nbsp; }<br />&nbsp;&nbsp;&nbsp; return string.Empty;<br />}</p>
</div>
<p>&nbsp;</p>
<table border="0">
<tbody>
<tr>
<td>--author:</td>
<td>Jago van der Most</td>
</tr>
<tr>
<td>--editor:</td>
<td>Jago van der Most</td>
</tr>
<tr>
<td>--date: </td>
<td>25/Feb/2011</td>
</tr>
</tbody>
</table><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10133054" width="1" height="1">ReportingAX 2009SolutionReportDrillthroughAXSRSDynamics AX OLAP cubes shows data only till 2008 yearhttp://blogs.msdn.com/b/emeadaxsupport/archive/2011/02/07/dynamics-ax-olap-cubes-shows-data-only-till-2008-year.aspxMon, 07 Feb 2011 12:03:11 GMT91d46819-8472-40ad-a661-2c78acb4018c:10125660EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10125660http://blogs.msdn.com/b/emeadaxsupport/archive/2011/02/07/dynamics-ax-olap-cubes-shows-data-only-till-2008-year.aspx#comments<p>Some time ago we run into following problem. When we browsed Accounts Receivable Cube for Total Sales dimension we could see data only till 2008 year, the data for years: 2009, 2010 and 2011 where just simple not displayed. <br />The first idea was to try solution from following post: <a href="http://blogs.msdn.com/b/emeadaxsupport/archive/2011/01/07/olap-time-dimension-does-not-contain-dates-for-year-2011.aspx">http://blogs.msdn.com/b/emeadaxsupport/archive/2011/01/07/olap-time-dimension-does-not-contain-dates-for-year-2011.aspx</a> but it did not help. Then we double check that in OLTP database we for sure have needed data from i.e. 2010 year</p> <p>The query which is run to compute Total Sales is based on named query CustTransTotalSales. The measure Total Sales has relation with Time dimension using DUEDATE field. So to double check that query returns data for year 2010 we tried to run following query: </p> <div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">SELECT ACCOUNTNUM, VOUCHER, INVOICE, AMOUNTMST, CURRENCYCODE, TRANSTYPE, APPROVED, DIMENSION, DIMENSION2_, DIMENSION3_, DIMENSION4_, PAYMMODE, DATAAREAID, RECVERSION, RECID, CAST(FLOOR(CAST(DUEDATE AS FLOAT)) AS DATETIME) AS DUEDATE, CAST(FLOOR(CAST(LASTSETTLEDATE AS FLOAT)) AS DATETIME) AS LASTSETTLEDATE, CAST(FLOOR(CAST(CLOSED AS FLOAT)) AS DATETIME) AS CLOSED, CAST(FLOOR(CAST(TRANSDATE AS FLOAT)) AS DATETIME) AS TRANSDATE, CAST(FLOOR(CAST(DOCUMENTDATE AS FLOAT)) AS DATETIME) AS DOCUMENTDATE, CAST(FLOOR(CAST(LASTEXCHADJ AS FLOAT)) AS DATETIME) AS LASTEXCHADJ, CAST(FLOOR(CAST(MODIFIEDDATETIME AS FLOAT)) AS DATETIME) AS MODIFIEDDATETIME, CAST(FLOOR(CAST(CREATEDDATETIME AS FLOAT)) AS DATETIME) AS CREATEDDATETIME, CAST(FLOOR(CAST(PAYMMANLACKDATE AS FLOAT)) AS DATETIME) AS PAYMMANLACKDATE FROM dbo.CUSTTRANS WHERE (INVOICE &lt;&gt; '') and DUEDATE between '1/1/2010' and '12/31/2010' </div> <p>Query returned values so we needed to look further what is wrong</p> <p>With help of Analysis Services EE we saw that [Measures].[Total Sales] is changed/altered by a Scope with following expression: </p> <div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">This = [Master Company Reporting Currency].[Currency].[Local] * (Measures.[Master end of day rate], StrToMember(&quot;[Currency].[Currency].&amp;[&quot;+[Company].[Currency code].CurrentMember.Name+&quot;]&quot;)) / (Measures.[Master end of day rate], LinkMember([Master Company Reporting Currency].[Currency].CurrentMember, [Currency].[Currency])); </div> <p>The [Measures].[Master end of day rate] is used internally by above expression is null for the 2010 year and will cause that all other measure will be null for 2010. Measure is based on following named query: </p> <div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">BIMASTERCOMPANYEXCHANGERATES.ENDOFDAYRATE To check execute following SQL Query: SELECT D.ID AS EXCHANGERATECOMPANY, V.CURRENCYCODE, V.DATEKEY, V.ENDOFDAYRATE FROM dbo.DATAAREA AS D CROSS JOIN (SELECT EXCHANGERATECOMPANY, CURRENCYCODE, DATEKEY, ENDOFDAYRATE FROM dbo.BIEXCHANGERATES WHERE (UPPER(EXCHANGERATECOMPANY) = (SELECT TOP (1) UPPER(EXCHANGERATECOMPANY) AS EXPR1 FROM dbo.BICONFIGURATION AS B)) AND (UPPER(CURRENCYCODE) IN (SELECT CASE WHEN UPPER(CURRENCYCODE) IS NULL THEN '' ELSE UPPER(CURRENCYCODE) END AS CURRENCYCODE FROM dbo.COMPANYINFO))) AS V </div> <p>If you check following query:</p> <div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">Select Max(DateKey) from BIEXCHANGERATES Where CurrencyCode = ‘EUR’ </div> <p>You will see that the last value is for year 2008</p> <p>So to fix the problem we needed: </p> <p>1. Go to Administration &gt; Setup &gt; Business analysis &gt; OLAP &gt; BI generation options (if you get error please look into post: <a href="http://blogs.msdn.com/b/emeadaxsupport/archive/2011/02/07/error-when-accessing-form-bi-generation-options.aspx">http://blogs.msdn.com/b/emeadaxsupport/archive/2011/02/07/error-when-accessing-form-bi-generation-options.aspx</a>)</p> <p>2. Go to Time dimension tab Make sure that Ending time is set up till the end of this year or further and click OK </p> <p>3. Go to Administration &gt; Setup &gt; Business analysis &gt; OLAP &gt; Setup Exchange Rates and run the process </p> <p>After this when you run Select </p> <div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">Max(DateKey) from BIEXCHANGERATES Where CurrencyCode = ‘EUR’ </div> <p>You should get the ending date from 3rd step Process cubes <p>Now you can process cubes and data for remaining years will appear in cube.</p> </p> <p> <table><tbody> <tr> <td>author:</td> <td>Czesława Langowska</td> </tr> <tr> <td>editor:</td> <td>Czesława Langowska</td> </tr> <tr> <td>date:</td> <td>07/Feb/2011</td> </tr> </tbody></table></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10125660" width="1" height="1">CubeOLAPAnalysis ServicesAX 2009SolutionError when accessing form “BI generation options”http://blogs.msdn.com/b/emeadaxsupport/archive/2011/02/07/error-when-accessing-form-bi-generation-options.aspxMon, 07 Feb 2011 11:48:28 GMT91d46819-8472-40ad-a661-2c78acb4018c:10125654EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10125654http://blogs.msdn.com/b/emeadaxsupport/archive/2011/02/07/error-when-accessing-form-bi-generation-options.aspx#comments<p>You get error when opening form Administration &gt; Setup &gt; Business analysis &gt; OLAP &gt; BI generation options </p> <div style="color: red; margin-left: 40px; margin-right: 40px">Cannot execute the required database operation. The SQL database has issued an error </div> <p>and in Application event viewer on AOS server you can find following entry</p> <div style="color: red; margin-left: 40px; margin-right: 40px">The database reported (session 3 (Admin)): [Microsoft][SQL Native Client][SQL Server]Invalid column name 'usergroup3'.. The SQL statement was: DELETE FROM [DBO].BIUDMROLES WHERE USERGROUPID IN (usergroup1,usergroup2,usergroup3)&quot;</div> <p>The problem is caused by minor bug in Classes\ SrsStatementQuery method deleteInvalidBIUdmRoles() Right now the while looks like: </p> <div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">while select udmRoles <br />{ <br />&#160;&#160; select userGroupInfo where userGroupInfo.Id == udmRoles.UserGroupId; <br />&#160;&#160; if (!userGroupInfo) <br />&#160;&#160; { <br />&#160;&#160;&#160;&#160;&#160; if (strlen(list) &gt; 0) <br />&#160;&#160;&#160;&#160; { <br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; list += #comma; <br />&#160;&#160;&#160;&#160; } <br />&#160;&#160;&#160;&#160; list += udmRoles.UserGroupId; <br />&#160; } <br />} </div> <p>Should be changed into: </p> <div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">while select udmRoles <br />{ <br />&#160;&#160; select userGroupInfo where userGroupInfo.Id == udmRoles.UserGroupId; <br />&#160;&#160; if (!userGroupInfo) <br />&#160;&#160; { <br />&#160;&#160;&#160;&#160;&#160; if (strlen(list) &gt; 0) <br />&#160;&#160;&#160;&#160; { <br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; list += #comma; <br />&#160;&#160;&#160;&#160; } <br />&#160;&#160;&#160;&#160; <font style="background-color: #ffff00">list +=&quot;'&quot;+ udmRoles.UserGroupId+&quot;'&quot;; <br /></font>&#160; } <br />} </div> <p><strong>Note: <br />The code is provided as is with no warranties, and confers no rights, and is not supported by of Microsoft Support</strong></p> <p> <table><tbody> <tr> <td>author:</td> <td>Czesława Langowska</td> </tr> <tr> <td>editor:</td> <td>Czesława Langowska</td> </tr> <tr> <td>date:</td> <td>07/Feb/2011</td> </tr> </tbody></table></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10125654" width="1" height="1">CubeOLAPAX 2009SolutionHow to add financial dimension to Dynamics AX Default cubeshttp://blogs.msdn.com/b/emeadaxsupport/archive/2011/01/13/how-to-add-financial-dimension-to-dynamics-ax-default-cubes.aspxThu, 13 Jan 2011 11:55:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10115214EMEADAXSupport5http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10115214http://blogs.msdn.com/b/emeadaxsupport/archive/2011/01/13/how-to-add-financial-dimension-to-dynamics-ax-default-cubes.aspx#comments<p>Lately we got some request regarding this subject. Unfortunately in current version the is no way to get it done automatically. The process as the cleaning cubes process is quite complex and manual. Although with help of team we managed to create attached draft document with step by step documentation how to add financial dimension to Dynamics AX Default cubes. Please note that the exact steps my differ based on license keys you have applied. Below you can also find the reference to White Papers around Dynamics AX Default cubes we can find:</p>
<p>- <a target="_blank" href="http://www.microsoft.com/downloads/en/details.aspx?FamilyID=28cdb057-416a-497e-a7e0-8d52c4eb1bfb&amp;displaylang=en">Microsoft Dynamics AX 2009 White Paper: Configure the Default OLAP Cubes</a></p>
<p>- <a target="_blank" href="http://www.microsoft.com/downloads/en/details.aspx?familyid=86da8b20-9d96-47e6-821c-802da5053a55&amp;displaylang=en">Microsoft Dynamics AX 2009 White Paper: Extending Default Cubes for Virtual Companies</a></p>
<p>- <a target="_blank" href="http://blogs.msdn.com/b/emeadaxsupport/archive/2009/04/29/default-cube-advisor-tool-for-microsoft-dynamics-ax-2009-has-been-released.aspx">Default Cube Advisor Tool for Microsoft Dynamics AX 2009 has been released</a></p>
<p>- <a target="_blank" href="http://download.microsoft.com/download/c/f/a/cfa6f277-f78c-4276-8928-f22e8201c05e/AxBICubeReference.pdf">Microsoft Dynamics AX 2009 Business Intelligence Cube Reference Guide</a></p>
<table border="0">
<tbody>
<tr>
<td>author:</td>
<td>Czesława Langowska, Jago van der Most, Anne Schwarz-Nielsen</td>
</tr>
<tr>
<td>editor:</td>
<td>Czesława Langowska</td>
</tr>
<tr>
<td>date:</td>
<td>13/Jan/2011 </td>
</tr>
<tr>
<td>edited:</td>
<td>01/Feb/2011 </td>
</tr>
</tbody>
</table>
<p><br class="_mce_marker" /></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10115214" width="1" height="1">OLAPRole CenterReportingAX 2009SolutionOLAP Time dimension does not contain dates for year 2011http://blogs.msdn.com/b/emeadaxsupport/archive/2011/01/07/olap-time-dimension-does-not-contain-dates-for-year-2011.aspxFri, 07 Jan 2011 11:42:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10112918EMEADAXSupport2http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10112918http://blogs.msdn.com/b/emeadaxsupport/archive/2011/01/07/olap-time-dimension-does-not-contain-dates-for-year-2011.aspx#comments<p>I ran into this problem when running TS_DeliveryPerformance report which was simply empty. After investigation I saw that all packing slip transactions made in January 2011 were shown in Sales Cube under Unknown year. Going forward when I browse Time dimension I could see that dates are only generated till the end of 2010 year.&nbsp; I tried to process it several times but it did not change anything. The problem with Time dimension was that property Source - CalendarEndDate was set up to 12/30/2010 4:00 PM what was the reason the dates were not getting generated. After changing property to 12/30/2020 4:00 PM and processing dimension the date for 2011 was shown. Of course you can think on every other date than 30 Dec 2012 as performance of processing this dimension depend on how many dates it has to create from CalendarStartDate till CalendarEndDate</p>
<p><a href="http://blogs.msdn.com/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-01-13-88-metablogapi/6253.clip_5F00_image001_5F00_51F20EF2.jpg"><img height="244" width="176" src="http://blogs.msdn.com/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-01-13-88-metablogapi/2746.clip_5F00_image001_5F00_thumb_5F00_6381F9BD.jpg" alt="clip_image001" border="0" title="clip_image001" style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" /></a></p>
<table border="0">
<tbody>
<tr>
<td>--author:</td>
<td>Czesława Langowska</td>
</tr>
<tr>
<td>--editor:</td>
<td>Czesława Langowska</td>
</tr>
<tr>
<td>--date:</td>
<td>07-01-2011</td>
</tr>
</tbody>
</table><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10112918" width="1" height="1">CubeOLAPReportingAX 2009Print medium change in dialog not working on certain reportshttp://blogs.msdn.com/b/emeadaxsupport/archive/2010/12/20/print-medium-change-in-dialog-not-working-on-certain-reports.aspxMon, 20 Dec 2010 13:16:30 GMT91d46819-8472-40ad-a661-2c78acb4018c:10107190EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10107190http://blogs.msdn.com/b/emeadaxsupport/archive/2010/12/20/print-medium-change-in-dialog-not-working-on-certain-reports.aspx#comments<p>Recently we were able to solve an issue with the print medium on certain reports. It is not changed immediately in a report print dialog option when it is generated from a class that&nbsp;extends <strong><em>RunBaseReportDialog</em></strong>. <br />This works fine when printing a standard report without extending from the <strong><em>RunBaseReportDialog</em></strong> class, (i.e, menu item object type is report). </p>
<p>The problem was caused by the following code line in method<strong><em>&nbsp;Classes/RunBaseReportDialog/main().<br /></em></strong>The prompt&nbsp;is called from the reportRun object instead of the reportDialog object&nbsp;.</p>
<div style="BACKGROUND-COLOR: lightgray; FONT-FAMILY: Courier New; PADDING: 5px 5px 5px 5px">res = reportRun.prompt(); </div>
<p><br />To solve the problem&nbsp;we therefore had to change the code line like this:</p>
<div style="BACKGROUND-COLOR: lightgray; FONT-FAMILY: Courier New; PADDING: 5px 5px 5px 5px">res = reportDialog.prompt(); </div>
<p>&nbsp;</p>
<table>
<tbody>
<tr>
<td>author:</td>
<td>Sendil Kumar</td>
</tr>
<tr>
<td>editor:</td>
<td>Daniel Durrer</td>
</tr>
<tr>
<td>date:</td>
<td>20/Dec/2010</td>
</tr>
</tbody>
</table><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10107190" width="1" height="1">ReportingAX 2009X++Reporting Extensions Installation Fails to install on SQL 2008 Reporting services after applying 959494 and 957312http://blogs.msdn.com/b/emeadaxsupport/archive/2010/12/06/reporting-extensions-installation-fails-to-install-on-sql-2008-reporting-services-after-applying-959494-and-957312.aspxMon, 06 Dec 2010 13:36:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10100767EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10100767http://blogs.msdn.com/b/emeadaxsupport/archive/2010/12/06/reporting-extensions-installation-fails-to-install-on-sql-2008-reporting-services-after-applying-959494-and-957312.aspx#comments<p>We run into this problem on environment when we uninstalled SQL 2005 Reporting services and installed SQL 2008 Reporting services instead.</p>
<p>As needed I have applied one of hotfixes 959494 or 957312 and I wanted to install Dynamics AX reporting services according to <a href="http://www.microsoft.com/downloads/en/details.aspx?FamilyId=4B681C44-D944-4B3F-B846-1E2A025569FD&amp;displaylang=en">Dynamics AX Installation Guide</a>. While I selected role "Reporting extensions" I got error </p>
<div style="color: red; margin-left: 40px; margin-right: 40px"><br />"You must install SQL Server 2005 Reporting Services Service Pack 2 before installing the reporting extensions." </div>
<p><br />The problem happens because when you uninstall SQL 2005 reporting services not all entries in registry are removed so in the end Dynamics AX Setup does not know if he deals with SQL 2005 or SQL 2008 reporting services <br /><br />To solve the problem I did:</p>
<p>1. Using Process Monitor (http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx ) we found out that on customer environment the path for reportingserviceswmi.dll is taken from HKCR\CLSID\{08377CC4-E2FF-4cdb-B643-DA8C618F7614}\InprocServer32\(Default) and has value C:\Program Files\Microsoft SQL Server\90\Shared\reportingserviceswmi.dll </p>
<p>On working environment it has value: C:\Program Files\Microsoft SQL Server\100\Shared\reportingserviceswmi.dll </p>
<p>We went ahead and change each key from C:\Program Files\Microsoft SQL Server\90\Shared\reportingserviceswmi.dll to C:\Program Files\Microsoft SQL Server\100\Shared\reportingserviceswmi.dll even those now we were able to find reportingserviceswmi.dll we still were not able to install Dynamics AX reporting extensions. </p>
<p>2. The reason was that wmi instance (v9) which stayed after installation of SQL 2005 reporting services. To fix it: </p>
<p>a. Run command wbemtest </p>
<p>b. Click "Connect"and connect to &ldquo;ROOT\Microsoft\SqlServer\ReportServer&rdquo;(type this path in the Namespace textbox) </p>
<p>c. After connecting to the name space, click "Query" to query &ldquo;SELECT * from __namespace&rdquo;. There would be one data in the record window(while the server only have one RS instance). </p>
<p>d. On the list of namespaces you will see all instances of reporting services + namespace called 'v9' </p>
<p>e. Select namespace v9 and click Delete </p>
<p>f. In Command line go to the folder C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin </p>
<p>g. Run the command: MOFCOMP reportingservices.mof </p>
<p>After those actions you were able to install Dynamics AX reporting extensions</p>
<p>&nbsp;</p>
<table border="0">
<tbody>
<tr>
<td>--author:</td>
<td>Czesława Langowska</td>
</tr>
<tr>
<td>--editor:</td>
<td>Czesława Langowska</td>
</tr>
<tr>
<td>--date:</td>
<td>06-12-2010</td>
</tr>
</tbody>
</table><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10100767" width="1" height="1">Role CenterReportingAX 2009SolutionInstallationProblem with CEO Role Centerhttp://blogs.msdn.com/b/emeadaxsupport/archive/2010/12/06/problem-with-production.aspxMon, 06 Dec 2010 12:52:40 GMT91d46819-8472-40ad-a661-2c78acb4018c:10100746EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10100746http://blogs.msdn.com/b/emeadaxsupport/archive/2010/12/06/problem-with-production.aspx#comments<p>Sometimes I can see following problem. In the CEO role center the financial KPIs give following error:</p> <div style="color: red; margin-left: 40px; margin-right: 40px" mce_style="color: red; margin-left: 40px; margin-right: 40px">The error is Query (1, 9) The Total Revenue-Argument for the given KPIVALUE-Function must be a KPI-Name (Key Performance Indicator).</div> <p>Here problem is quite easy. </p> <p>For General Ledger KPIs please make sure that Ledger account categories are correctly set up. To learn more please visit Application and Business Processes Help (Applications and Business Processes -&gt; Finance -&gt;Setting up and maintaining Finance -&gt; Setting up and maintaining General ledger -&gt; Setting up the chart of accounts -&gt; Ledger account categories and analysis cubes) To learn more how KPIs are counted please read WhitePaper: <a href="http://www.microsoft.com/downloads/details.aspx?FamilyId=6A685DF3-912D-4545-B990-CD2283C159FB&amp;displaylang=en" mce_href="http://www.microsoft.com/downloads/details.aspx?FamilyId=6A685DF3-912D-4545-B990-CD2283C159FB&amp;displaylang=en"><font color="#0066cc">Microsoft Dynamics AX 2009 Business Intelligence Cube Reference Guide</font></a> </p> <p>To check which exactly Ledger account category has not assigned account to you will need to use BIDS (Business Intelligence Development Studio)</p> <p>&#160;</p> <p>&#160;</p> <p>&#160;</p> <p><a href="http://blogs.msdn.com/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-01-13-88-metablogapi/1565.BIDS_5F00_2.png" mce_href="http://blogs.msdn.com/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-01-13-88-metablogapi/1565.BIDS_5F00_2.png"><img style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" title="BIDS" border="0" alt="BIDS" src="http://blogs.msdn.com/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-01-13-88-metablogapi/5314.BIDS_5F00_thumb.png" width="1050" height="274" mce_style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" mce_src="http://blogs.msdn.com/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-01-13-88-metablogapi/5314.BIDS_5F00_thumb.png" /></a></p> <p>&#160;</p> <p>In above screenshot you can see that Cost of Goods sold is based on Ledger account category with id 35 which is COGS. So you would need to go to General ledger -&gt; Setup -&gt; Ledger Account categories and make sure that group COGS has accounts assigns.</p> <p>After changes made you will need to process cubes.</p> <p>&#160;</p> <p> <table class="mceItemTable" border="0"><tbody> <tr> <td>--author:</td> <td>Czesława Langowska</td> </tr> <tr> <td>--editor:</td> <td>Czesława Langowska</td> </tr> <tr> <td>--date:</td> <td>06-12-2010</td> </tr> </tbody></table></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10100746" width="1" height="1">OLAPRole CenterEnterprise PortalAX 2009SolutionProblem with Production Manager role centerhttp://blogs.msdn.com/b/emeadaxsupport/archive/2010/12/06/problem-with-production-manager-role-center.aspxMon, 06 Dec 2010 12:20:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10100736EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10100736http://blogs.msdn.com/b/emeadaxsupport/archive/2010/12/06/problem-with-production-manager-role-center.aspx#comments<p>Some time ago I run into following problem with Production Manager Role Center. One of the reporting services report - Capacity load nect 30 days (hours) raised error:</p>
<div style="color: red; margin-left: 40px; margin-right: 40px">Error while executing query for WIPLevel-Dataset. <br />The [WIP Level]-element could not be found in the cube while analyzing the string &lsquo;[Measure].[WIP Level]. <br />The value expression for the query object &lsquo;prodUnitId&rsquo; contains an error:&nbsp; the index is out of array size. <br />Here problem is quite easy. </div>
<p>After long troubleshooting we found&nbsp;out that&nbsp;this reports worked fine for environments were multi site functionality was on. Basically&nbsp;we missed some data in tables, what makes report not working. To workaround this problem you can:</p>
<p>1. &nbsp;&nbsp;&nbsp;&nbsp; Add one record to InventSite table <br />2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Add one record to ProdUnitTable where ParentSiteId is connected with record created in step 1 <br />3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Update table WrkCenterTable (field ProdUnitId for work center groups set up to record created in step 2) <br />4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Process cubes</p>
<table border="0">
<tbody>
<tr>
<td>--author:</td>
<td>Czesława Langowska</td>
</tr>
<tr>
<td>--editor:</td>
<td>Czesława Langowska</td>
</tr>
<tr>
<td>--date:</td>
<td>06-12-2010</td>
</tr>
</tbody>
</table><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10100736" width="1" height="1">OLAPRole CenterEnterprise PortalAX 2009SolutionHow to set up Dynamics AX 4.0 Reporting role on application with Turkish GLS installed and collation Turkish_CI_AShttp://blogs.msdn.com/b/emeadaxsupport/archive/2010/08/03/how-to-set-up-dynamics-ax-4-0-reporting-role-on-application-with-turkish-gls-installed-and-collation-turkish-ci-as.aspxTue, 03 Aug 2010 13:51:52 GMT91d46819-8472-40ad-a661-2c78acb4018c:10045374EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10045374http://blogs.msdn.com/b/emeadaxsupport/archive/2010/08/03/how-to-set-up-dynamics-ax-4-0-reporting-role-on-application-with-turkish-gls-installed-and-collation-turkish-ci-as.aspx#comments<p>Some time ago I needed to set up reporting role for Dynamics AX 4.0 with Turkish GLS and database which collation was Turkish_CI_AS. The task was not easy. Starting from situation that I was not even able to start AOS after installation when KB article: <a href="https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb$EN-US$931955&amp;wa=wsignin1.0">https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb$EN-US$931955&amp;wa=wsignin1.0</a> helped me to fix it. After compilation and synchronization I had to generate report models. During generation of report models after around 20 min I get following error:</p> <div style="color: red; margin-left: 40px; margin-right: 40px">Failed to process instance internal.totalcom.net Cannot create a record in Analysis Services Enum Cache (SRSAnalysisEnums). Value: 203, Subscription.The record already exists.&quot; </div> <p> <br />After longer investigation I found that error is raised in </p> <p>[c] \Classes\SRSModelWriter\cacheAnalysisEnumValues 93 </p> <p>[c] \Classes\SRSModelWriter\generateUniqueNames 21 </p> <p>[c] \Classes\SRSModelPerspectivesGenerator\generate 40 </p> <p>[c] \Classes\SRSUpdateModels\updateModels 105 </p> <p>[c] \Classes\SRSUpdateModels\run 5 </p> <p>[c] \Classes\SRSUpdateModels\main 8&#160; </p> <p>If you look into SRSAnalysisEnums Primary Key EnumValueEnumValue there is index: </p> <p>-LanguageID </p> <p>- EnumID </p> <p>- EnumItemValue </p> <p>Error is raised because the index is broken, the record with such a values (LanguageID, EnumID, EnumItemValue) already exists. What would mean that there is Enum which has two nodes with the same value, what is of course strange as you are not able to create such an Enum. <br />In the end I found the that indeed there is Enum which has two nodes with exactly the same values. <br />The problem happens during generation of Bank model. The enum which is causing the problem is </p> <p>\Data Dictionary\Base Enums\LedgerTransTxt\SMASubscription Layer: gls Value: SMASubscription which value has 203 </p> <p>If you look into \Data Dictionary\Base Enums\LedgerTransTxt there is another enum CashReceipt which value is also 203 what is causing the error (this one was added in GLS layer) </p> <p>So the solution was to apply KB 936323 <a href="https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb$EN-US$936323&amp;wa=wsignin1.0">https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb$EN-US$936323&amp;wa=wsignin1.0</a> which was nit included in SP2.</p> <p>After this change the models get generated, but it was not the end of the problems. </p> <p>After creating report in report builder and running in I run into new error: </p> <div style="color: red; margin-left: 40px; margin-right: 40px">Semantic query execution failed. Invalid column name 'WindowsID' Query execution failed for data set 'dataSet' An error has occurred during report processing. </div> <p> <br />The reason behind this is standard issue for Turkish localization difference between ‘i’ and ‘I’. In Turkish there is difference between i and I if you try to run this query you will get the error that column WindowsID if you change column name to WINDOWSID then the statement will be correct <br />In this case problem was hidden in macro SRSModel in AOT \ Macros \ SRSModel </p> <p>to fix it by changing the value from</p> <div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">#define.windowsIdFieldName (&quot;WindowsID&quot;) </div> <p>to </p> <div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">#define.windowsIdFieldName (&quot;WINDOWSID&quot;) </div> <p>After applying fix, you need to re-compile Classes\SRSModelGenerator. We can input a blank key at any place in SRSModelGenerator and delete it, after that, do compile. It will make sure system will re-compile it.</p> <p>After all those changes reports were running correctly.</p> <p></p> <p>&#160;</p> <p> <table border="0"><tbody> <tr> <td>--author: </td> <td>Czesława Langowska</td> </tr> <tr> <td>--editor: </td> <td>Czesława Langowska</td> </tr> <tr> <td>--date: </td> <td>03/Aug/2010</td> </tr> </tbody></table></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10045374" width="1" height="1">ReportingAX 4.0SolutionDeploymentDate picker in Dynamics AX 2009 SSRS reportshttp://blogs.msdn.com/b/emeadaxsupport/archive/2010/06/29/date-picker-in-dynamics-ax-2009-ssrs-reports.aspxTue, 29 Jun 2010 11:45:46 GMT91d46819-8472-40ad-a661-2c78acb4018c:10032042EMEADAXSupport1http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10032042http://blogs.msdn.com/b/emeadaxsupport/archive/2010/06/29/date-picker-in-dynamics-ax-2009-ssrs-reports.aspx#comments<p>Some time ago I run into following problem. The date picker control in Dynamics AX 2009 SSRS reports used wrong date format (EN-US) while it should use NO (Norwegian). This concerned all AX 2009 SSRS reports, and viewing them from both Dynamics AX client and in Enterprise Portal. When viewing the report directly in reporting services (Report Manager) it works correctly. The version of SQL used was SQL 2005 SP3. What was more interesting all regional settings for each server (AOS, SQL, MOSS) where set up into Norwegian. We also checked registry keys for each user on Reporting Services server HKEY_USER\.Default\Control Panel\International and HKEY_USER \........\Control Panel\International had regional setting set up to Norwegian.</p> <p>We never found caused of the problem however we managed to find workaround <br />We found out that when we run report from Report Server (using ReportViewer.aspx) the date picker is behaving in the same way. To solve it we set up Culture on Norwegian for ReportViewer.aspx in following way: </p> <p>Edit the ReportViewer.aspx webpage. It usually in this directory: &quot;%ProgramFiles%\Microsoft SQL Server\ MSSQL.<reportingservices instance>\Reporting Services\ReportServer\Pages\&quot; </reportingservices></p> <p>Add Culture attribute to the @Page declaration like this:</p> <div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">&lt;%@ Page Language=&quot;C#&quot; AutoEventWireup=&quot;true&quot; Inherits=&quot;Microsoft.ReportingServices.WebServer.ReportViewerPage&quot; Culture=&quot;nb-NO&quot;%&gt; </div> It worked fine in this case, but if you have users connecting from Europe and US in the same time, US users will start complain that in their case they always get European format. <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10032042" width="1" height="1">ReportingAX 2009Some charts in the Role Center show a wrong axis scale 0-0-0-1-1-1http://blogs.msdn.com/b/emeadaxsupport/archive/2010/05/27/charts-in-the-role-center-show-wrong-axis-scale-0-0-0-1-1-1.aspxThu, 27 May 2010 05:44:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10016104EMEADAXSupport5http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=10016104http://blogs.msdn.com/b/emeadaxsupport/archive/2010/05/27/charts-in-the-role-center-show-wrong-axis-scale-0-0-0-1-1-1.aspx#comments<p>We recently came across an issue, that if you are using Microsoft SQL Server 2008 Reporting Services some charts in the Microsoft Dynamics AX 2009 Role Center have incorrect axis scale values on the Y-Axis. Instead of values from e. g. 0 to 1000 you only see <strong>0-0-0-1-1-1</strong>.</p>
<p>For example the following chart reports are showing an incorrect Y-Axis scale:</p>
<blockquote sizset="0" sizcache="6">
<table cellpadding="2" cellspacing="0" border="0" style="width: 400px;">
<tbody>
<tr>
<td width="200" valign="top"><strong>Report Library</strong></td>
<td width="200" valign="top"><strong>Report</strong></td>
</tr>
<tr>
<td width="200" valign="top">Cust&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td>
<td width="200" valign="top">CashIflowvsCashOutflow</td>
</tr>
<tr>
<td width="200" valign="top">&nbsp;</td>
<td width="200" valign="top">CashReceiptJournalTotalsTrxCount </td>
</tr>
<tr>
<td width="200" valign="top">&nbsp;</td>
<td width="200" valign="top">ExpectedCashNextDays </td>
</tr>
<tr>
<td width="200" valign="top">&nbsp;</td>
<td width="200" valign="top">PostedCustomerInvoiceTotalsandTrxCnt </td>
</tr>
<tr>
<td width="200" valign="top">&nbsp;</td>
<td width="200" valign="top">&nbsp;</td>
</tr>
<tr>
<td width="200" valign="top">Ledger</td>
<td width="200" valign="top">ActualvsBudget </td>
</tr>
<tr>
<td width="200" valign="top">&nbsp;</td>
<td width="200" valign="top">GrossProfitinthePastXPeriods </td>
</tr>
<tr>
<td width="200" valign="top">&nbsp;</td>
<td width="200" valign="top">SalesInPastXMonths </td>
</tr>
<tr>
<td width="200" valign="top">&nbsp;</td>
<td width="200" valign="top">TotalAccountPayablePastXPeriods </td>
</tr>
<tr>
<td width="200" valign="top">&nbsp;</td>
<td width="200" valign="top">TotalAccountsReceivablePastXPriods </td>
</tr>
<tr>
<td width="200" valign="top">&nbsp;</td>
<td width="200" valign="top">TotalExpensesByPeriod </td>
</tr>
<tr>
<td width="200" valign="top">&nbsp;</td>
<td width="200" valign="top">&nbsp;</td>
</tr>
<tr>
<td width="200" valign="top">Vend</td>
<td width="200" valign="top">PurchasesPastXPeriods </td>
</tr>
<tr>
<td width="200" valign="top">&nbsp;</td>
<td width="200" valign="top">VendorInvoiceJournalTotalTrxCount </td>
</tr>
<tr>
<td width="200" valign="top">&nbsp;</td>
<td width="200" valign="top">VendorPaymentJournalTotalTrxCount</td>
</tr>
</tbody>
</table>
</blockquote>
<p>This issue does not exist if you are using Microsoft SQL Server 2005 Reporting Services. </p>
<p>The problem is caused by the <em>report design </em>of the affected chart reports. More concrete the <em>Max Value </em>property of the<em> Y-Axis </em>is having the value <em>1E-06</em> set which is wrong. Changing the property to <em>0</em> (which means <em>Auto</em>) and re-deploying the Report Libraries resolves the issue. <br />&nbsp;</p>
<p>In order to change the <em>Max Value</em> property please follow these steps:</p>
<ol>
<li>Log on to a PC having Microsoft Visual Studio 2008, the Microsoft Dynamics AX 2009 Client and the Microsoft Dynamics AX 2009 Reporting Tools installed <br />&nbsp; </li>
<li>In the Dynamics AX 2009 Client open the AOT window and navigate to <em>AOT\Report Libraries</em> <br />&nbsp; </li>
<li>Select the Report Library containing the chart report you want to update, click with the right mouse button at it and chose <em>Edit in Visual Studio </em>from the context menu&nbsp; <br />&nbsp;</li>
<li>Wait until the Report Library was opened in Microsoft Visual Studio 2008&nbsp; <br />&nbsp;</li>
<li>Open chart report you want to modify by double clicking at it in the <em>Solution Explorer </em>pane <br />&nbsp;</li>
<li>In the tree navigate to <em>Designs\Full\Page <br />&nbsp;</em></li>
<li>Select the <em>XYChart </em>design you want to modify, click with the right mouse button at it an select <em>Properties</em> from the context menu <br />&nbsp;</li>
<li>In the <em>Properties</em> pane change the property <em>Data Scale Max Value</em> from the value <em>1E-06</em> to the value <em>0</em> (which means <em>Auto</em>) <br />&nbsp;</li>
<li>Save your changes back to the Dynamics AX 2009 AOT by clicking at the Report Library in the Solution Explorer pane with the right mouse button and selecting <em>Save to AOD </em>from the context menu <br />&nbsp;</li>
<li>Re-Deploy the updated Report Library using the <em>Microsoft Dynamics AX 2009 Report Deployment</em> tool </li>
</ol>
<table border="0">
<tbody>
<tr>
<td>--author:</td>
<td>Czeslawa Langowska</td>
</tr>
<tr>
<td>--editor:</td>
<td>Alexander Lachner</td>
</tr>
<tr>
<td>--date:</td>
<td>27/05/2010</td>
</tr>
</tbody>
</table><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10016104" width="1" height="1">SQL ServerRole CenterEnterprise PortalReportingAX 2009SolutionInstallationDynamics AX Reporting Services Reports does not refresh after refreshing Role Center pagehttp://blogs.msdn.com/b/emeadaxsupport/archive/2010/04/02/dynamics-ax-reporting-services-reports-does-not-refresh-after-refreshing-role-center-page.aspxFri, 02 Apr 2010 15:02:58 GMT91d46819-8472-40ad-a661-2c78acb4018c:9989566EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=9989566http://blogs.msdn.com/b/emeadaxsupport/archive/2010/04/02/dynamics-ax-reporting-services-reports-does-not-refresh-after-refreshing-role-center-page.aspx#comments<p>Lately we run into strange problem. After changing data we would like to refresh Role Center page to see it in Dynamics Ax Reporting services report. Even those data were changed and we trie to refresh page (F5 or CTRL + F5) data in report is not refreshing. We were trying all possibilities like: refreshing AOD, Data and so on, but it did not help. What is interesting for reports which had Reporting services toolbar visible there were no problem, after we refreshed site, data were also refreshed in report. <br />We looked further into this problem and it happened this is a known behavior in SSRS. If the toolbar is set to false, then the report is rendered from cache from the last session and the parameters are not applied.</p> <p>With help of <a href="http://www.fits-consulting.de/blog/CategoryView,category,MS%2BSQL%2BServer,RS%2B-%2BSSRS.aspx">http://www.fits-consulting.de/blog/CategoryView,category,MS%2BSQL%2BServer,RS%2B-%2BSSRS.aspx</a>&#160; we found workaround. <br />The workaround is to on the SharePoint page put a PageViewer WebPart ( or a user control with IFRAME in it) and set the url to http://&lt;reporting server&gt;/ReportServer?%2fDynamics%2fCustDynamicsReport.ReportCust2.AutoDesign1&amp;rs:Command=Render&amp;rc:Toolbar=false&amp;rs:ClearSession=true where 2fDynamics%2fCustDynamicsReport.ReportCust2.AutoDEsig1 is the report name and design which you what use. </p><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9989566" width="1" height="1">ReportingSolutionYou get a warning message when deploying the AX 2009 smmOpportunityReports report libraryhttp://blogs.msdn.com/b/emeadaxsupport/archive/2010/02/18/you-get-a-warning-message-when-deploying-the-ax-2009-smmopportunityreports-report-library.aspxThu, 18 Feb 2010 17:18:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:9965839EMEADAXSupport1http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=9965839http://blogs.msdn.com/b/emeadaxsupport/archive/2010/02/18/you-get-a-warning-message-when-deploying-the-ax-2009-smmopportunityreports-report-library.aspx#comments<P>When deploying the AX 2009 smmOpportunityReports using the Reports Deployment tool or directly from the AOT, you may get the following warning:</P>
<DIV style="COLOR: red; MARGIN-LEFT: 40px; MARGIN-RIGHT: 40px">
<P><STRONG>One or more libraries built with warnings. Please see MSBuild log at C:\Users\<EM>&lt;your username&gt;</EM>\AppData\Local\Temp\1\tmp98ED.tmp</STRONG><BR>Deploying 1 data source(s) and&nbsp;2 design(s) in 3 culture(s) (7 item(s) total)...<BR>Deployment done at 13:25:38. Duration: 00:00:23.5803347<BR>The deployment log file can be found at "C:\Users\<EM>&lt;your username&gt;</EM>\AppData\Local\Temp\1\tmp1319.txt"</P></DIV>
<P>(Note: any random tmp filename will be generated). Checking the .tmp file that is specified in the warning in notepad&nbsp;reveals the following warning:
<DIV style="COLOR: red; MARGIN-LEFT: 40px; MARGIN-RIGHT: 40px"><BR>…<BR>…<BR>Target CoreCompile:<BR>&nbsp;&nbsp;&nbsp; C:\Users\&lt;interactive user&gt;\AppData\Local\Temp\1\tmp1329.tmp\smmOpportunityReports\smmPipelineMonthOverMonthClosingTrend.moxl : warning AX3020: The data method 'GetColor' in class 'smmPipelineMonthOverMonthClosingTrend' is not present in the model.<BR>Done building target "CoreCompile" in project "smmOpportunityReports.dynamicsproj".<BR>…<BR>…<BR>Done building project "smmOpportunityReports.dynamicsproj".
<P>Build succeeded.</P>
<P>C:\Users\&lt;interactive user&gt;\AppData\Local\Temp\1\tmp1329.tmp\smmOpportunityReports\smmPipelineMonthOverMonthClosingTrend.moxl : warning AX3020: The data method 'GetColor' in class 'smmPipelineMonthOverMonthClosingTrend' is not present in the model.<BR>&nbsp;&nbsp;&nbsp; 1 Warning(s)<BR>&nbsp;&nbsp;&nbsp; 0 Error(s)</P></DIV>
<P mce_keep="true">&nbsp;</P>
<P><STRONG>You can safely ignore this warning</STRONG>. There is a code fragment left behind in the smmPipelineMonthOverMonthClosingTrend.cs file which declares a GetColor() method but it is actually not exposed or used in the report library model. </P>
<P mce_keep="true">&nbsp;</P><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9965839" width="1" height="1">ReportingAX 2009DeploymentHow to manually deploy ODC Files to Microsoft Dynamics AX 2009 Enterprise Portalhttp://blogs.msdn.com/b/emeadaxsupport/archive/2010/02/17/how-to-manually-deploy-odc-files-to-microsoft-dynamics-ax-2009-enterprise-portal.aspxWed, 17 Feb 2010 15:06:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:9965094EMEADAXSupport2http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=9965094http://blogs.msdn.com/b/emeadaxsupport/archive/2010/02/17/how-to-manually-deploy-odc-files-to-microsoft-dynamics-ax-2009-enterprise-portal.aspx#comments<P>Sometimes you may come across an issue with deploying ODC files from "AX2009 -&gt;Administration -&gt; Setup -&gt; Business Analysis -&gt; OLAP -&gt; OLAP Administration" for various reasons and you have already&nbsp;tried the suggestions given in this <A href="http://blogs.msdn.com/emeadaxsupport/archive/2009/04/23/unable-to-deploy-odc-files-to-enterprise-portal-even-after-installing-hotfix-kb960158.aspx" target=_blank mce_href="http://blogs.msdn.com/emeadaxsupport/archive/2009/04/23/unable-to-deploy-odc-files-to-enterprise-portal-even-after-installing-hotfix-kb960158.aspx">link</A>, then you can follow through the following manual steps to&nbsp;deploy them to the Enterprise Portal Server:<BR>&nbsp;<BR>1.&nbsp;The ODC files are deployed to the Data Connections page on the Enterprise Portal site. By default, the Data Connections page is located at: <A href="http://[your ep hostname]/sites/DynamicsAx/Data%20Connections/Forms/AllItems.aspx">http://<EM>[your ep hostname]</EM>/sites/DynamicsAx/Data%20Connections/Forms/AllItems.aspx</A> <BR>Verify if the files, definitely do not exist.</P>
<P>2.&nbsp;Download the attached AX2009_ODC_Files.zip and extract its contents to an empty folder. This contains 11 default ODC files.<BR></P>
<P>3.&nbsp;Open the extracted ODC files with Notepad or any other text editor.</P>
<P>4.&nbsp;Edit all the odc files and replace the values in &lt;odc:ConnectionString&gt; to reflect your OLAP Server/Instance name and Database name:</P>
<P>Data Source=<EM>[Specify Your OLAP ServerName]<BR></EM></P>
<P>Initial Catalog<EM>=[Specify Your OLAP DbName]</EM><BR></P>
<P>ALSO, consider adding <STRONG>SSPI=Kerberos;</STRONG> to the ConnectionString, <STRONG>ONLY</STRONG> if you have configured Role Centers to use <A href="http://www.microsoft.com/downloads/details.aspx?familyid=be720eb3-649a-49ff-b019-a1e4e7af6b47" target=_blank mce_href="http://www.microsoft.com/downloads/details.aspx?familyid=be720eb3-649a-49ff-b019-a1e4e7af6b47">Kerbersos Authentication</A> (given in bold below):</P>
<DIV style="PADDING-BOTTOM: 5px; BACKGROUND-COLOR: lightgray; PADDING-LEFT: 5px; PADDING-RIGHT: 5px; FONT-FAMILY: Courier New; FONT-SIZE: 8pt; PADDING-TOP: 5px">… <BR>… <BR>&lt;odc:Connection odc:Type="OLEDB"&gt; <BR>&lt;odc:ConnectionString&gt;Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=True;DataSource=[YourOLAPServerName];Initial Catalog=[YourOLAPDbName];<STRONG>SSPI=Kerberos;&lt;/</STRONG>odc:ConnectionString&gt; <BR>… <BR></DIV>
<P>For example, if your OLAP Server name is Server1 and the OLAP database name is “Dynamics AX” and you have Kerberos Authentication configured then the &lt;odc:ConnectionString&gt; should look like this:
<DIV style="PADDING-BOTTOM: 5px; BACKGROUND-COLOR: lightgray; PADDING-LEFT: 5px; PADDING-RIGHT: 5px; FONT-FAMILY: Courier New; FONT-SIZE: 8pt; PADDING-TOP: 5px">&lt;odc:ConnectionString&gt;Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=True;Data Source=Server1;Initial Catalog=Dynamics AX;SSPI=Kerberos;&lt;/odc:ConnectionString&gt;<BR></DIV>
<P>5.&nbsp;Save the changed ODC files.</P>
<P><BR>6.&nbsp;If required, rename the ODC files names to match your OLAP database name, if not using the default database name "Dyanmics AX". By default the file naming structure is<EM> [OLAP Database name][space][Cube name]</EM>.ODC, and there is also a default .ODC file just named as<EM> [OLAP Database name].</EM>ODC. <BR>NOTE: The [OLAP Database name] is determined from what is specified in the "OLAP Administration" form under the "OLAP databases" tab (AX2009 -&gt;Administration -&gt; Setup -&gt; Business Analysis -&gt; OLAP -&gt; OLAP Administration)<BR></P>
<P>7.&nbsp;Browse to your Enterprise Portal site main site. <BR></P>
<P>8.&nbsp;Click on Site Actions &gt; Site Settings. <BR></P>
<P>9.&nbsp;Under Galleries, click on Master pages. <BR></P>
<P>10.&nbsp;Click on View all site content (top left). <BR></P>
<P>11.&nbsp;Click on Data Connections folder (or alternatively browse to the Data Connection page, by default this is located at <A href="http://servername/sites/DynamicsAx/Data%20Connections/Forms/AllItems.aspx">http://ServerName/sites/DynamicsAx/Data%20Connections/Forms/AllItems.aspx</A>). <BR></P>
<P>12.&nbsp;Import all the edited ODC files.</P>
<P mce_keep="true">&nbsp;</P>
<P><U>REFERENCES:</U></P>
<P><A href="http://blogs.msdn.com/emeadaxsupport/archive/2009/04/23/unable-to-deploy-odc-files-to-enterprise-portal-even-after-installing-hotfix-kb960158.aspx" target=_blank mce_href="http://blogs.msdn.com/emeadaxsupport/archive/2009/04/23/unable-to-deploy-odc-files-to-enterprise-portal-even-after-installing-hotfix-kb960158.aspx">Unable to deploy ODC files to Enterprise Portal even after installing Hotfix KB960158</A> (or any AX 2009 Rollup Update 1, 2,3..)<BR></P>
<P><A href="https://mbs.microsoft.com/partnersource/deployment/documentation/howtoarticles/AX2009_SSRS_SSAS_Integration&amp;NRCACHEHINT=Guest&amp;wa=wsignin1.0" mce_href="https://mbs.microsoft.com/partnersource/deployment/documentation/howtoarticles/AX2009_SSRS_SSAS_Integration&amp;NRCACHEHINT=Guest&amp;wa=wsignin1.0">Tips and Tricks Implementing SSRS and SSAS Integration for Microsoft Dynamics AX 2009</A></P><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9965094" width="1" height="1">OLAPRole CenterEnterprise PortalAX 2009SolutionDeploymentError “Thread was being aborted” when deploying reporting extensionshttp://blogs.msdn.com/b/emeadaxsupport/archive/2010/02/05/error-thread-was-being-aborted-when-deploying-reporting-extensions.aspxFri, 05 Feb 2010 16:12:45 GMT91d46819-8472-40ad-a661-2c78acb4018c:9958851EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=9958851http://blogs.msdn.com/b/emeadaxsupport/archive/2010/02/05/error-thread-was-being-aborted-when-deploying-reporting-extensions.aspx#comments<p>Some time ago we run into problem which did not let us deploy reporting extensions to SQL Reporting Services. Just after building libraries we got the error:</p> <div style="color: red; margin-left: 40px; margin-right: 40px">[ThreadAbortException]: Thread was being aborted. <br />at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously) <br />at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error) <br />at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) <br />at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) </div> <p>Because the error was very cryptic it took us a lot of time to find the solution for this problem.</p> <p>In the end it happened that&#160; although all other components on other machines (AOS, Enterprise portal, etc) were already upgraded to SP1 RU3, we totally forgot to upgrade machine were SQL Reporting Services and Microsoft Dynamics AX 2009 Report Deployments tools were installed. After upgrading first to SP1 and then to RU3 we managed to deploy reports.</p> <p>Please note if you are running AX 2009 RTM version and also running into issue, it can be that you did not apply KB 957312 (<a href="https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb$EN-US$957312&amp;wa=wsignin1.0">https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb$EN-US$957312&amp;wa=wsignin1.0</a>) on machine were Microsoft Dynamics Ax 2009 Reports Deployments tools were installed.</p><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9958851" width="1" height="1">Role CenterReportingSolutionDeploymentInstallationHow to install AX 4.0 Reporting Role with SSRS 2008http://blogs.msdn.com/b/emeadaxsupport/archive/2010/01/22/how-to-install-ax-4-0-reporting-role-with-ssrs-2008.aspxFri, 22 Jan 2010 12:26:12 GMT91d46819-8472-40ad-a661-2c78acb4018c:9951943EMEADAXSupport0http://blogs.msdn.com/b/emeadaxsupport/rsscomments.aspx?WeblogPostID=9951943http://blogs.msdn.com/b/emeadaxsupport/archive/2010/01/22/how-to-install-ax-4-0-reporting-role-with-ssrs-2008.aspx#comments<p>Some time ago we got question how to install AX 4.0 Reporting Role with SQL Server 2008. As every time when you are trying to install Reporting Services extension from AX 4.0 installation wizard, partner has got error: </p> <div style="color: red; margin-left: 40px; margin-right: 40px">&quot;SQL Server Reporting Services must be installed before a Microsoft Dynamics AX reporting server can be set up.&quot; </div> <p> <br />The problem is probably somewhere in axsetup. Although we managed to create workaround. The workaround is to create manually the actions axsetup is doing, so we do not need to launch axsetup anymore. </p> <p>To workaround the problem you need to: <br />1. Go to report manager <br />2. Create new folder call Dynamics <br />3. Create new data source called “Dynamics Database” with following settings: <br />&#160;&#160;&#160; a. Enable this data source: true <br />&#160;&#160;&#160; b. Connection type: Microsoft SQL Server <br />&#160;&#160;&#160; c. Connection string:&#160;&#160;&#160;&#160;&#160; </p> <div style="padding-bottom: 5px; background-color: lightgray; padding-left: 5px; padding-right: 5px; font-family: courier new; font-size: 8pt; padding-top: 5px">initial catalog=<em>DynamicsAXDatabaseName</em>;Application Name=Dynamics;data source=<em>DatabaseServerName</em>; </div> <br />&#160;&#160;&#160; d. Connect using: select “Credentials stored securely in report server” - put the domain account name which has publishing rights for this instance for SRSS <br />&#160;&#160;&#160; e. Select “Use as Windows credentials when connecting to data source” <br />4. Go to Dynamics AX Client <br />5. Go to Tools &gt; reporting tools &gt; reporting server <br />6. Specify the urls for Report Server and Report Manager. <br />7. Check on Advanced tab if folder name and data source name are the same as one created <br />8. Click validate button. <br />9. Try to update report model <p></p> <p>To learn more about configuring report builder please visit: <a href="http://msdn.microsoft.com/en-us/library/ms365173.aspx">http://msdn.microsoft.com/en-us/library/ms365173.aspx</a> </p> <p>To learn more about SRSS security please visit: <a href="http://msdn.microsoft.com/en-us/library/ms156034.aspx">http://msdn.microsoft.com/en-us/library/ms156034.aspx</a> </p> <p>One more issue you can run into when you use reporting extensions for DAX 40: <a href="https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb$EN-US$951396&amp;wa=wsignin1.0">https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb$EN-US$951396&amp;wa=wsignin1.0</a></p><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9951943" width="1" height="1">ConfigurationReportingAX 4.0SolutionInstallation