TO_NUMBER in OBIEE

You can use CAST function to convert from one datatype to another datatype. and you can create a new logical column in your RPD , that use this function;

cast(MONTH("Fixed Assets Depreciation".DEPRN_RUN_DATE) as char)

Technorati Tags: OBIEE