Friday, January 27, 2012

Creating a Reporting Services Report Using Cube

Very nice vedio, demonstrating How to create a SSRS report using Cube as a datasource.

Dynamics AX 2012 Data Import using Excel Add-in

Hy All,

During last few weeks I was very much wondering that How master data can be uploaded to Ax via Excel, it's pretty much painful activity as compared to previous Ax versions.

Just came across a very nice blog, which explains how to import all master data to Ax via Excel. by  Alex Anikiev

Mukesh Hirwani

Tuesday, January 24, 2012

Setting Up Database Mail

Select all months bewtween two dates

 No loops... no recurrsion... nice tight code...

;with Numbers (Number) as
 (select row_number() over (order by object_id)
 from sys.all_objects)
select dateadd(month, number, @StartDate)
from Numbers
where number <= datediff(month, @StartDate, @EndDate)

Thursday, January 5, 2012

AX 2012 - Data & Code Upgrade

Hy Folks,

During last few days, I have been researching for Up gradation & Migration Help for DAX 2012. So here are few very useful links available which helps a lot in performing same activity.

Enjoy Ax 2012.. :)