Archive
January, 2011
Browsing all articles from January, 2011
0

As part of Microsoft technical community contributions in Saudi Arabia, we are conducting a two days online event in February 10th and 11th.

Dynamics AX Brains will conduct a Dynamics AX session by the end of that event called: “The What, Why and How Answers of Dynamics AX” which will give an overview about the Dynamics AX 2009 from functional and technical perspectives.

There are going to be other topics to be covered like Windows Azure, Silverlight, SharePoint 2010, XNA, Windows Phone 7, Dynamics CRM 2011, and SSIS.

Wish you can attend! :) Remember that the Dynamics AX session will be on the 11th at 03:00 PM Riyadh time.

Attend

0

The great Microsoft Dynamics team is conducting some sessions in the coming period. Those online sessions will cover topics in all Dynamics products including Microsoft Dynamics AX.

The first coming event will be “Management Reporter and Performance Management with Microsoft Dynamics AX that will be held in the 12th of Jan. The next session will be “See the New Payroll for Microsoft Dynamics AX“, and I’m really excited to attend this session to see the new Payroll. The Payroll session will be in the 1st of Feb.

To see full list of those webcasts and to register, click here.

4

Happy new year :)

I got a SQL error today when I tried to open the “BI project generation options” form in Dynamics AX. The error was like the following:

When walked through the code, I discovered that it tries to delete some entries from a table called: “UDM Roles (BIUdmRoles) throw a SQL statement but unfortunately that SQL statement is mistyped!

To correct the issue, go to AOT –> Classes –> SRSStatement –> deleteInvalidBIUdmRoles method and write the code between my comments as below:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
//Amer Atiyah, http://blog.amerax.net/
public static void deleteInvalidBIUdmRoles()
{
    BIUdmRoles udmRoles;
    UserGroupInfo userGroupInfo;
    str list = #emptyString;
 
    Connection connection;
    Statement statement;
    SqlStatementExecutePermission permission;
 
    str sqlStatement = @"DELETE FROM %1BIUDMROLES WHERE USERGROUPID IN (%2)";
    ;
 
    while select udmRoles
    {
        select userGroupInfo where userGroupInfo.Id == udmRoles.UserGroupId;
        if (!userGroupInfo)
        {
            if (strlen(list) > 0)
            {
                list += #comma;
            }
            /*Comments Begin*/
            //list += udmRoles.UserGroupId;
            list += "'" + udmRoles.UserGroupId + "'";
            /*Comments End*/
        }
    }

Dynamics AX 2012 Event

Recent Posts

Tags

Archives

Random Testimonial

  • ~ Mohamed Wajd Haikal, Software Team Leader at IDIS

    no_thumb"Amer is one of my best friends, he always tries to be the best by focusing on gaining new certifications and to have wide relationships"

  • Read more testimonials »