Total Pageviews

Search This Blog

Sunday, April 22, 2012

Voting begins for Top 100 Microsoft Dynamics Influential People in the world

Dear Friends,

I'm bit late on this news but Thank you for nominating me once again for the most important person within Microsoft Dynamics. There is at the moment a voting going on where I'll very much appreciate your vote.

Please go to: 

And then set a tick in front of my name: Dilip Nair

Thanks in advance.

Monday, April 16, 2012

Kurt Hatlevik's post on Enabling wireless PDA Capabilities in Dynamics AX 2012

Dear Friends,

I just stumbled upon Kurt's blog on enabling wireless PDA Capabilities in Dynamics AX 2012. A very interesting post on how to run Dynamics AX 2012 rich client on wireless device, straight away out of the box without any custom apps or services.

For more detailed info, you can jump on to this blog post below...

Good work Kurt..

Saturday, April 14, 2012

Troubleshooting OLAP Errors in OLAP Storage Engine The attribute key cannot be found when processing: Table

Dear Friends!

I have been working as part-time BI and Sharepoint Developer/Admin alongwith my routine AX development. While working with Analysis Services and Cubes Processing, I have come across several errors, In today's post, I will list down the troubleshooting steps involved to solve one such error, Hope it helps somebody out there:

Error# 1
Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_RR006_Inventory_x0020_Calculations', Column: 'TimeKey_FK', Value: '12/01/2012'. The attribute is 'Time Key PK'. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Time Key PK of Dimension: Time Dimension from Database: RR001a-RetailReporting, Cube: RR001-RetailReporting, Measure Group: Inventory Calculations, Partition: RR006 Inventory Calculations, Record: 1. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Errors in the OLAP storage engine: An error occurred while processing the 'RR006 Inventory Calculations' partition of the 'Inventory Calculations' measure group for the 'RR001-RetailReporting' cube from the RR001a-RetailReporting database.


Process the Dimension in question by going to Process options and change from “Process Update” to “Process Full”

Also had to reprocess the following dimensions
Dim Sales Dimensions, Time, Item Dimensions, End of Details, Customers

Note: The table names and dimensions names may differ in your scenario.

Some Additional Notes/References:

Difference between ProcessFull and ProcessUpdate


ProcessFull applies to all objects. It discards the storage contents of the object and and rebuilds them. ProcessFull is recursively applied to all descendants of the object as well.


ProcessUpdate applies only to dimensions. It is the equivalent of incremental dimension processing in Analysis Services 2000. It sends SQL queries to read the entire dimension table and applies the changes—member updates, additions, deletions.

Since ProcessUpdate reads the entire dimension table, it begs the question, "How is it different from ProcessFull?" The difference is that ProcessUpdate does not discard the dimension storage contents. It applies the changes in a "smart" manner that preserves the fact data in dependent partitions. ProcessFull, on the other hand, does an implicit ProcessClear on all dependent partitions. ProcessUpdate is inherently slower than ProcessFull since it is doing additional work to apply the changes.

Depending on the nature of the changes in the dimension table, ProcessUpdate can affect dependent partitions. If only new members were added, then the partitions are not affected. But if members were deleted or if member relationships changed (e.g., a Customer moved from Redmond to Seattle), then some of the aggregation data and bitmap indexes on the partitions are dropped. The cube is still available for queries, albeit with lower performance. (Look at Section “Ignore the Error”)

Wednesday, April 11, 2012

Wanted - Dynamics AX ERP Business Analyst


Rarely you will come across job advertisement on my blog, but just thought of helping my company out here. Paspaley Pearls is looking for a Dynamics AX Business Consultant. This position is based out of Darwin, Australia. Please find the ad below:

Note - For those not eligible to work in Australia,Visa sponsorship/assistance is available for the right candidate



Ø  Darwin Based

Ø  Challenging Role

This is an exciting opportunity to join a very progressive Group with interests in many diverse industries that uses the Microsoft Dynamics AX ERP system.

The position reports to the Manager – Information Technology and will be responsible for analysing business processes across the Group and formulating solutions through the use of the AX ERP system and other applications; initiating and leading related projects; and providing day-to-day support of the AX ERP system.

The person we seek must be a self-motivated individual with a positive attitude and have had experience with and exposure to major ERP implementations, process re-engineering, change management and documentation preparation.

Although not absolutely necessary, experience specifically with Microsoft Dynamics AX will be considered as highly advantageous.

Ideally, you will have:

·         A good functional understanding in and have been involved in deploying a variety of ERP system modules.

·         Experience in gathering business requirements and preparing functional specifications for system modifications.

·         Experience in providing end user support.

You will also be an excellent communicator across all levels and have the ability to manage multiple deadlines and stakeholders within a team environment.

Darwin is a vibrant and multicultural city and is Australia’s gateway to Asia.  Over $150 billion in investments is slated for northern Australia in the next 5 years and Darwin is positioned to benefit from this investment.

Salary will be negotiated with the successful applicant.

Applications close Monday 23th April 2012 and should be addressed to the Manager Information Technology at  

Tuesday, April 10, 2012

How to move Sharepoint Databases from one Server to another

Dear Friends,

A while ago, I was involved in upgrading our Sharepoint SQL Server databases and had them move from one server to another. Initially, I was under the impression that moving Sharepoint databases would be as simple as detaching databases from one server and attaching it to the destination server. But it's not easy as said, with sharepoint the databases are tightly coupled with the web applications, so I had to go through a series of steps to complete the move.

Note - In case if you are trying out these steps, I would highly recommend to perform these steps first on your TEST Environment.

In case, you are not able to view the embedded document below, please go to this link

Thursday, April 5, 2012

Follow me @dynamicserphub for the latest happenings in Dynamics ERP world

Dear Friends,

You can follow me on twitter (@dynamicserphub) as I often tweet about the latest happenings in Dynamics ERP World. My tweets are mostly based on latest blog posts,news and other buzz happening in Dynamics world