Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
can anybody help me on this query.
Have you got solution for the same ?
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