Datype Issue with Number

building semantic layer
1

Hi,
I have been using cast to get the calculations for Day1 as in the database the table column is small integer and in the universe I am using number and using a cast for the conversion but these objects in the report are not returning correct values.

How to handle this datatype issue?

sum(cast( cast(SMARTPOST_BUSOBJ_L2F5_VIEW_DB.fxsp_ontime_svc_meas_summary.tot_dlvd_day_1_qty as char) as decimal(7,4))

Requesting for suggestions to solve the issue.

Thanks

s7jyothi (BOB member since 2008-09-07)

2

Can you give us an example of what is going wrong?

What are you doing, what are you getting and what were you hoping to get?