Hi Lendra, We were also facing a similar challenge. So we created a sample Analysis with the required formatting theme. After this whenever we create a new report we just do a import from the template analysis and all the formatting gets applied same as parent report. This might also prove helpful for you. Regards, Kiran…

Hi Ling, In BO we have a dedicated object called as Current Date which is part of query, not sure technically how it can be implemented within OBI. If session variable helps that would be great! Thanks & Regards, Kiran

Thankyou Ling... this is great news! Regards, Kiran Shenvi

Thanks Rachel.. this works perfect :-)

Hi Nicole, You can use the CAST function to convert the UDF into Date CAST( UDF AS DATE) Regards, Kiran

Hi Doug, This is a known bug with OBI and would probably get fixed in future release. As of now the only workaround known are manual one. We have to go to bottom of the table and unmerge the cell. If we don't wish the users to do it each time, some developer from your team can create an excel macro utility which the users…

Hi Rachel, Yes, I agree with Shashi. Manually doing these basic tasks keeps eating up time. Has Oracle any plans inline for near future to provide SDK support just like we have in BO? Regards, Kiran

Hi Arun, When we addressed this issue to support via SR but they have been in a denial mode to accept this as an unexpected behaviour. Since they do not have any auditing setup they are say that some developer activity could have mistakenly caused the folder movement. We were also being informed that our observation may be…

Hi Kelly, We have observed whenever the data volume is such that the file size crosses 9 MB, it gives error. We had raised an SR and they admitted it to be bug. Still no confirmation when it will be fixed. Till then users will have to break down the prompts such that the data volume fits in smaller size. Regards, Kiran…

Hi, If you are looking for Req. Total Days on Hold then in OBI Recruiting its as below : EVALUATE('RL_REQTIMEBETWEEN_FNC(%1,LOCALTIMESTAMP,%2,0,0,0,NULL)' AS DOUBLE,"Requisition Dates"."Req. Creation Date","Requisition Identification"."Req. Identifier")-EVALUATE('RL_REQTIMEBETWEEN_FNC(%1,LOCALTIMESTAMP,%2,1,0,0,NULL)' AS…

Hi Anish, I have found a probable solution. Use both Transaction Tables and Historical CSW Tables and use below filters. "Submission Tracking History"."Transaction is Most Recent" = Yes & RANK("Submission CSW Status - Historical"."Submission Historical Status Start Date" BY "Submission General Info"."Submission…

Hi Anish, Just one query to understand your BO requirement correctly. 1. Step/Status you are looking for History or Step/Status of last CSW activity i.e. means Current Step/Status. 2. Last Activity is tracked using "Is Most Recent" in OBI but do you want to additionally check if the latest activity within 24 hrs. Regards,…

Hi Anish, If you are looking for Current Step/Status you may try this and make changes accordingly > (CASE WHEN "Requisition Primary Location"."Location Level1 Code" IN ('Value 1','Value 2') AND TIMESTAMPDIFF(SQL_TSI_DAY,"Submission CSW Status - Current"."Current Status Start Date", CURRENT_DATE) <=1 AND "Submission CSW…

Hi Anish, Just wanted to check s there any specific reason you are using Application Tracking CSW Step/Status instead of Application Current CSW Step/Status? Because in OBI Application Tracking CSW objects are now tracking only Submission Tracking events and not CSW events. For CSW Events we need to use Submission History…

Thanks Rachel.. this works perfect :-)

Thanks Rachel.. this works perfect :-)

Thanks Rachel.. this works perfect :-)

Thanks Rachel.. this works perfect :-)