Translate

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.

http://www.sqlservercentral.com/articles/Video/64190/

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.

http://ax2012exceldataimport.blogspot.com/ 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.. :)