Errors in the backend data base access module

Question

hi all ,

when I tried to process the cube all my dimensions are succeeded but one measure is failed

ERROR

Errors in the backend databse acess module. OLE DB reported an overflow of the data type for column 0.

The measure name is FCT_Service_Agreement

it has agreement key,

agreemnt number  and many as attributes.

Please help me how to resolve this issue.

---

s dhwani

Answer 1

Hi,

Please check your source data type in the database and your cube.

I hope this is helpful.

Elmozamil Elamir

MyBlog

---

Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
http://elmozamil.blogspot.com

Answer 2

Hi Dhwani,

As suggested Elmozamil, check your source data type. Here is a related thread with same error message where the error is caused because the number is converted into exponential. http://social.msdn.microsoft.com/Forums/eu/sqlanalysisservices/thread/d7777ee3-b056-4cb9-830a-b0c9668c123e .

Hope this helpfully,

Regards,
Jerry