Hi
I need to modify the report as per the following Instruction in BO 6.5 Deski So please help me with solution or any idea.
Need A formula in BO 6.5 in universe and Report.
Priority Date will not be there in the report, It will be there in Universe.
Example:
If (prority date-Due Date) < 1year then Due date+1year where title is 12 Month proceed and
If (prority date-Due Date) is between More then 1yr to 2.5 yrs then Due date +2.5 yrs where title is 30nd procedding. Display Due Date.
Example
Priority Date Due Date Title
01/01/08 01/11/08 12 Month proceed
01/01/08 01/02/10 30 Month Proceed
Change 1:
V need to add 1 year to the Due Date if the Difference between Priority Date and Due Date is (Only 12 Months) 1 Year where Title is 12 Month proceed
Change 2:
V need to add 2.5 year to the Due Date if the Difference between Priority Date And Due Date is More then 1year to 2.5 Years where Title is 12 Month proceed.
Result should look like.
U will find the difference in Due Date
Priority Date Due Date Title
01/01/08 01/11/09 12 month proceed
01/01/08 01/08/12 30 month Proceed
I have following query So please check whether this work for above requirment and please tell me how exactly I can put this formula in BO 6.5 Designer and Report…Find the Below query
SELECT CASE WHEN MONTHS_BETWEEN(TRUNC(priority_date),TRUNC(due_date))<12 THEN ADD_MONTHS(due_Date,12) END AS “12 Month Proceed”,CASE WHEN MONTHS_BETWEEN(TRUNC(priority_date),TRUNC(due_date)) BETWEEN 12 AND 30 THEN ADD_MONTHS(due_Date,30) END AS “30 Month Proceed”
FROM TEST_DATES
Please let me know for any further queries on the same
This is much easily done in the universe. Since it came to Reporting follow below.
=If (Mod(Year ([Priority Date])/4)=0;
If(DaysBetween(prority date-Due Date)<0 and DaysBetween(prority date-Due Date)>-365;FormatDate(RelativeDate[DueDate]+365;"mm/dd/yyyy"));"Met the deadline");If (Mod(Year ([Priority Date])/4)<>0;
If(DaysBetween(prority date-Due Date)<0 and DaysBetween(prority date-Due Date)>-365;FormatDate(RelativeDate[DueDate]+364;"mm/dd/yyyy"));"Met the deadline"))
;If ((Year ([Priority Date])/4)>0;
If(DaysBetween(prority date-Due Date)<=-365;FormatDate(RelativeDate[DueDate]+910;"mm/dd/yyyy"));"Met the deadline");If (Mod(Year ([Priority Date])/4)<>0;
If(DaysBetween(prority date-Due Date)>=-365;FormatDate(RelativeDate[DueDate]+911;"mm/dd/yyyy"));"Met the deadline"));"Ask me to modify")
This is the half of the definition to define the status “12 month Proceed/30 month Proceed”. Let me know if it is ok to go ahead or go with Designer solution?. If you want the slouting at report level all had to be done is extened and redifine the formula above.
I need to create a DUE DATE Variable in the report .
So I need formula for DUE DATE As
DUEDATE = PriorityDate + 365days(1year) Where Title is 12MONTHS(Fillter is there on ths Column(Satus)) and DUEDATE = Priority Date + 880days(2.5Years) Where Title is 30MONTHS(Fillter is there on ths Column(Satus))
Priority date and status are the Objects which come from Universe.
So I want the formula for new Variable in BO 6.5 Deski Basing on the Above requirment.
Please Paste the formula exactly how it appears in BO 6.5 Deski .
Just let me know if need any clarification from my end.
(BOB member since 2005-02-24)