Hello ray,
I do have a strange issue. I will explain my scenario in details. We have 2 servers(on same domain) , one is Sharepoint Server machine and another one is Database Server,which have SSAS Database. On the sharepoint site i have to display KPIs which is deployed on the SSAS on the Database Server. On the way to acheive this i have creates odc files which is linked to the cubes on the SSAS Database.After that i have uploaded the odc files to the Dataconnections Library of the Sharepoint Site and Approved the odc list item. Then on the KPI List i have taken the option to add KPI indicator from SSAS Cube and selected my ODC file. After this action , it is not listing  any of the KPIs in the KPI Dropdown and also gives an error "A connection cannot be made. Ensure that the server is running".
Actually i got a workaround for this error,It is to impersonate the user  on the sharepoint site which have access on the Database server. But this workaround is creating problem when i need to take the current logged in user.
What will be the correct way to do this? I dont want to do impersonation... Please help me.. Thanks in advance