Hi All,
If you guys are familier with Randomized allocation in SQL, i need the same logic to be implemented in Cognos.
For Eg:
sample randomized allocation
WHEN (acctnmbr like'11%'
and DPD=0)THEN 1
WHEN (acctnmbr like'11%'
and DPD between 1 and 10)THEN 2
WHEN (acctnmbr like'11%'
and DPD between 10 and 20)THEN 2
WHEN (acctnmbr like'11%'
and DPD between 20 and 30)THEN 2
WHEN (acctnmbr like'10%'
and DPD between 1 and 10)THEN 3
WHEN (acctnmbr like'10%'
and DPD between 10 and 20)THEN 5
WHEN (acctnmbr like'10%'
and DPD between 20 and 30)THEN 5
END
In this case it will give me 1 acct that starts with 11 and has dpd=0,
2 accts that start with 11 and have dpd btwn 1 and 10.....and so on.
I need the same logic in cognos. i did it with unions but it's too many queries.
This is only for one page. i have 12 more pages like this with different allocations.
Please help. Kind of urgent.
Thanks in advance.
If you guys are familier with Randomized allocation in SQL, i need the same logic to be implemented in Cognos.
For Eg:
sample randomized allocation
WHEN (acctnmbr like'11%'
and DPD=0)THEN 1
WHEN (acctnmbr like'11%'
and DPD between 1 and 10)THEN 2
WHEN (acctnmbr like'11%'
and DPD between 10 and 20)THEN 2
WHEN (acctnmbr like'11%'
and DPD between 20 and 30)THEN 2
WHEN (acctnmbr like'10%'
and DPD between 1 and 10)THEN 3
WHEN (acctnmbr like'10%'
and DPD between 10 and 20)THEN 5
WHEN (acctnmbr like'10%'
and DPD between 20 and 30)THEN 5
END
In this case it will give me 1 acct that starts with 11 and has dpd=0,
2 accts that start with 11 and have dpd btwn 1 and 10.....and so on.
I need the same logic in cognos. i did it with unions but it's too many queries.
This is only for one page. i have 12 more pages like this with different allocations.
Please help. Kind of urgent.
Thanks in advance.