actually what i am trying to do is

logic something like below that I am going to put in a function .. but value field in table A ...

thanks..

what if i want to convert any numeric value to integer ,is it possble to do it in function?

if so, can you show me some examples?

Did you create proper attribute relationships in your diemnsions?

thanks!  I will try it and let you know

Data_Staging:

Unique_id   Gender  Ethnicity RACE MCP_Key Admission_DT Discharge_date Enrollment_key Reason Disbility Income Employment

100A1         M           A         3         1010     01/4/1999      11/3/2006       163278           R        Y           47389    UIN90

Here is the...