Hello Again,
I might sound a bit stupid in changing what I problem faced but I am now able to process the cubes but the different applications that need to process this cube are not.
My Tech lead tells me that we need to configure the ODBC drivers into our new server because of which this is failing.
I am attaching an image that shows the ODBC Data Source Administrator-> Drivers window for my new server on the left and the old on the right. I basically need both to have the same drivers and really need help on this as I am a first timer at this.
If any one has any clue on this please give me some direction as I am looking for anyone to direct me where to look for these details from.
Thanks in advance to any one who can help me out.