Microsoft Dynamics AX 2012 Cubes or Role center BI report error

Microsoft Dynamics AX 2012 Cubes or Role center BI report error.

In Microsoft Dynamics AX 2012 you might face problem with BI reports for role center or reports where Cubes are involve.

There can be number of reasons for this and you will get number of errors. Like permission not granted, access denied, related data missing, cubes not processed etc.

Two main reasons are (1) data missing in respective tables and (2) insufficient license.

In most of the places data is interrelated among the tables. If you are missing related data in tables, it will give some errors.

Secondly, by default Microsoft provides cubes for all the tables and assumption is you have 100% license. But when there is a limited license and you apply it to your application, based on limited license system drops few tables for which you do not have license. In such a scenario your queries for cubes are not updated and they are still using 100% tables but you don’t have 100% tables now because of limited license.

Here the option for you is to update the queries but it’s a huge task. For Microsoft Dynamics AX 2009 you have to do it manually but to help you Microsoft published a tool to generate an excel sheet which tells you what are the areas you need to work.
In case of Dynamics AX 2012, Microsoft provided few options in the form of a wizard from where you can do it by clicking a button as shown below:
Path: Tools Business Intelligence (BI) Tools  SQL Server Analysis Services project wizard.

In the above wizard if you select Update option and follow the wizard it resolve your problem.

How to resolve Ax 2009 SRS reports deployment error or exception

This article explains how to remove

• While deploying AX SRS reports from AX client (AOT->Report Libraries), system gives below error / exception
• While deploying AX Reports Deployment tools , system gives below error / exception

Symptom:
In case of SQL Server 2008
One or more libraries built with warnings. Please see MSBuild log at C:\Documents and Settings\Administrator\Local Settings\Temp\tmp.tmp
Deploying 0 data source(s) and 63 design(s) in 42 culture(s) (2521 item(s) total)...
Unable to connect to http : // [your system name] /ReportServer/ReportService2005.asmx as specified in the config file for the report server at C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\RSReportServer.config. If this url is not correct please update the config file, otherwise make sure the report server is configured correctly. The deployment log file can be found at "C:\Users\Administrator\AppData\Local\Temp\1\tmp.txt"



In case of SQL Server 2005
One or more libraries built with warnings. Please see MSBuild log at C:\Documents and Settings\Administrator\Local Settings\Temp\tmp.tmp
Deploying 0 data source(s) and 63 design(s) in 42 culture(s) (2521 item(s) total)...
Unable to connect to http : // [your system name] /ReportServer/ReportService2005.asmx as specified in the
config file for the report server at C:\Program Files\Microsoft SQL Server\ MSSQL.3\Reporting Services\ReportServer\RSReportServer.config. If this url is not correct please update the config file, otherwise make sure the report server is configured correctly.
The deployment log file can be found at "C:\Users\Administrator\AppData\Local\Temp\1\tmp.txt"


Resolution:
Check following:
1) Is your report manager working from IIS or Internet explorer? If no then make it workable. If it works then you can see Report Manager Home.
2) Is web service http : // [your system name] /ReportServer/ReportService2005.asmx working?

To make the default Report Manager workable, you can see the installation and configuration guidance.

If you are using SQL server 2008, open the C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\RSReportServer.config file in an editor (Notepad is perfect).

If you are using SQL server 2005, open the C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\ rsreportserver.config file in an editor (Notepad is perfect).

Now you have to modify this config file. Before you do this I do recommend you to make a copy of this file as a backup.Press Ctrl + F and find ‘SQLCommandTimeoutSeconds’. By default the value is 60. Increate the value upto 300 and save the file.

Now restart the IIS.
Launch AX SRS report deployment tool. I hope it will work.

Once the AX SRS Reports deployment is finished go back to the above mentioned config file and decrease the value 60 from 300.

Note: Use at your own risk. There is no warranty on this article.

Cheers!