Epicor data Discovery view does not display columns with Type Float

,

Using EDD on Epicor 10.2.200,
I have an external BAQ that successfully fetches data from the external data source when analyzing and testing the BAQ. However when I use the BAQ as a source in EDD, the float columns are not shown in the dimensions or measures listing. If I change the data type in External table to Decimal, the columns get fetched without any problem.

The source database is external (Non Epicor source , MSSQL DB )and not under my control - I cannot make the change permanent.

Any idea why the column with float data is not fetched in EDD?

Hi Jani,

We have seen a similar error when trying to use an external BAQ with Float fields through REST. To solve it, replace all your Float fields by Calculated fields with Decimal data type in your external BAQ.

Editor:
convert(decimal, externaltable.floatfield)

Regards
PSE

Thank you Carlos. I ended up doing the same.