Aging

[#1]

Requires aging of item,supplier,customer.

in MDM module.

item : 0 to 2 days,3 days,4 days and more than 4 days

supplier : 0 to 1 days,2 days,3 days and more than 3 days

customer : same as supplier

Please send the qvw as soon as possible.

Regards,

[#2]

can anybody help me on this query.

[vikasmahajan]

Have you got solution for the same ?

[#4]

Hi,

You can load something like this

IF(AGE >1 AND AGE<= 20, DUAL('1-20',1),

    IF(AGE>=21 AND AGE<= 25, DUAL('21-25',2),

    IF(AGE>=26 AND AGE<= 30, DUAL('26-30',3),

    IF(AGE>=31 AND AGE<= 35, DUAL('31-35',4),

    IF(AGE>=36 AND AGE<= 40, DUAL('36-40',5),

    IF(AGE>=41 AND AGE<= 45, DUAL('41-45',6),

    IF(AGE>=46 AND AGE<= 50, DUAL('46-50',7),

    IF(AGE>=51 AND AGE<= 55, DUAL('51-55',8),

    IF(AGE>=56 AND AGE<= 60, DUAL('56-60',9),    

    IF(AGE>60, DUAL('60+',10))))))))))) AS [Age Band]

in your load script. AGE is your Column name.

Thanks,

Selvakumar