Global date format conversion

Convert any country specific date time format and use it for Query range


UTCDateTime = fromDateTime,  toDateTime;
 ;   
 


fromDateTime    = Global::datetobeginUtcDateTime(fromDateFilter, DateTimeUtil::getUserPreferredTimeZone());







toDateTime      = Global::datetoendUtcDateTime(toDateFilter, DateTimeUtil::getUserPreferredTimeZone());

Use of User Preferred time zones with DateTimeUtil class in DAX

• Fetch only date from UTCDateTime (From user preferred time zone)

static void Job1(Args _args)
{
    date i;
    ;
   
    i= DateTimeUtil::date(DateTimeUtil::applyTimeZoneOffset(DateTimeUtil::utcnow(), DateTimeUtil::getUserPreferredTimeZone()));
    info(strfmt('%1',i));
}

• Fetch only time from UTCDateTime (From user preferred time zone)

static void Job1(Args _args)
{
     str i;
    ;
   
    i =  time2str(DateTimeUtil::time(DateTimeUtil::applyTimeZoneOffset(datetimeutil::utcNow(), DateTimeUtil::getUserPreferredTimeZone())), timeseparator::Colon, timeseparator::Colon);
    info(strfmt('%1',i));
}

•   Fetch the Utcdatetime (with User preferred time zone only)

static void Job1(Args _args)
{
     utcdatetime i;
    ;
   
    i = DateTimeUtil::newDateTime(systemDateGet(), timeNow());
    info(strfmt('%1',i));
}

•   Fetch the Utcdatetime (Without User preferred time zone only)

static void Job1(Args _args)
{
     utcdatetime i;
    ;
    i = datetimeutil::utcnow();
    info(strfmt('%1',i));
}

Get dimension value dynamically using dimOf function

static void getDimensions(Args _args)
{
    Dimension   dimension;
    int         numOfDimensions, i;
    ;
 
    numOfDimensions = dimOf(dimension);
 
    for (i = 1; i <= numOfDimensions; i++)
    {
        info(YourTable::find('XYZ').dimension[i]);
       // salesTableLocal.Dimension[i] = carrier.Dimension[i];
    }
}

you can get more details on link - https://msdn.microsoft.com/en-us/library/aa597117.aspx

Install Dynamics AX 2009 Reporting Extensions with SQL server 2008

Hi Friends,

This is Nitin here i'm working as MS Dynamics Axapta technical . I would like to share some of the finding and the issues on which i have worked .

Disclaimer

1. I have no link whatsoever with Microsoft. I'm just at the IT staff on a customer using AX.
2. This procedures are provided "as is" with no warranties at all.
3. All of this procedure are documented somewhere else.

Install Dynamics AX 2009 Reporting Extensions with SQL server 2008

Sometime back, I have experience on interesting issue while installing Reporting Extensions with SQL server 2008, When I run the Setup, I get the following message : "You must install SQL server 2005 Reporting Services Service Pack 2 before installing the report extensions". Here is the workaround

1. 1. Locate the Dynamics AX 2009 Reporting services dll from the extracted AX 2009 SP1 folder[\\AX2009SP1\support\axsetupresources\microsoft.dynamics.setup.reportingservices.dll;File Version - 5.0.1000.52]
2. Extract the AX 2009 .iso to a folder
3. Copy the microsoft.dynamics.setup.reportingservices.dll into the folder:\\DynamicsAX\Msi\Components32\Program Files\Microsoft Dynamics AX\50 and Setup\\DynamicsAX\Msi\Components64\Program Files\Microsoft Dynamics AX\50\Setup
4. It will ask to replace the existing dll having File Version - 5.0.593.0. Say Yes and replace.
5. 5. Then Install AX Reporting Services extensions. It works fine and the Reporting Extensions are installed nice.

Error while trying to deploy Dynamics AX 2009 SSRS reports

Following are the checkpoints:

1) All the prerequisites has been installed for Report Server. (Windows SDK, Microsoft Visual Studio 2008 Shell  Re-distributable package - Isolated mode, reporting extensions)

2) Check your Reporting Services Configuration Manager - In the Service Account - you must select the second option "Use Another account and provide the proper credentials". Once done apply the settings

3) Now run the Report Service Web Service URL's under "Web Service URL tab" and check it's opening correctly. Make sure that the dynamics Folder exists.

4) If Dynamics Folder doesn't exists. Go to MSDAX 2009 and under Administration >> Setup >> Business Analysis >> Reporting Services  open Reporting Servers now make sure you have the record created and click on "Create" button to create the new Dynamics Folder. You can cross check it by re-visiting the Reports Url in IE. You will find the dynamics folder.

5) Now go to Report Server and run the Setup Microsoft Dynamics AX 2009 Reports Deployment as administrator. Click on single report and deploy. The reports will deploy and you can verify the same in report manger url.