#Datatype error in WebI Reports

[Former Member]

Hi,

I am getting #datatype error for the a measure object in webi report.

The same column is displaying as blank in the dev system. But in production system the column is showing #datatype error.

I am using XI3.1. I verified the datatype of the object in database & it is integer. In the universe also the object is parsing fine and is displaying the LOV fine.

But at the report ;level getting error only in prod system.

Could anyone please provide some solution.

Thanks

Sindhu

[Former Member · Accepted solution]

Hi,

Please check the data type at the universe levele aswell and cast it to number even if it's datatype is number.

Please try this and let us know.If this did not work them please give us the complete error which you are getting.

Cheers,

ravichandra K

[Former Member · Accepted solution]

Hi Ravi,

Thanks for your reply.

We changed the datatype at database level. Its working fine.

Thnaks

Sindhu

[Former Member · Accepted solution]

Its worked. Changed data type at database level using to_number() function.

Thank You Ravichandra.