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

1. Import Customers
2. Importing Vendors
3. Importing Main Accounts
4. Importing Products
5. Importing Customer Transactions/Balances
6. Importing Vendor Transactions/Balances
7. Importing Ledger Transactions/Balances
8. Importing Inventory Transactions/Balances
9. Importing Sales Orders
10. Importing Free Text Invoices
11. Importing Purchase Orders

Regards,

Mukesh Hirwani

Setting Up Database Mail

Very nice article, describes how to configure Database Mail in SQL

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

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

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)

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.

• How to Write Data Upgrade Scripts for Microsoft Dynamics AX 2012
• Code Upgrade Tool
• EDT Relation Migration Tool
• Series of White Papers - Code Upgrade
• Data migration - Importing the InventItemGroupForm Table
• Code upgrade (InventTrans refactoring Item-Product data management, OperationalResource Model)

Enjoy Ax 2012.. :)