i have no luck on research and got the solution on this... attempting to convert/cast given integer (eg: 301193) to date with format 1993-11-30. I need the date data type to build my cube.. and i should use 'Database only' or 'limited local' for query processing mode...
This is untested, but the expression would be something like this. Check the user guide, function tab in the expression editor for more information.
cast(substring(cast(myinteger,varchar(6)),3,2)+'-'+substring(cast(myinteger,varchar(6)),1,2)+'-'+substring(cast(myinteger,varchar(6)),5,2),date)