Below mentioned are BO subqueries, need to use them in OBIEE. Can anyone list out anyway to do it..
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 objects. Using mix of both will complicate things.
Also, Req. Primary Location ID Level 1 is no present in OBI and you will have to use regular object Req. Primary Location Level 1.
Regards,
Kiran Shenvi
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 Status - Current"."Current Step Name" = 'New (T)' AND "Submission CSW Status - Current"."Current Status Name" IN ('Rejected (T)','Move Forward (T)','Under Consideration (T)') THEN 1 ELSE 0 END) = 1
If History Step/Status >
MAX(CASE WHEN "Requisition Primary Location"."Location Level1 Code" IN ('Value 1','Value 2') AND TIMESTAMPDIFF(SQL_TSI_DAY,"Submission CSW Status - Historical"."Submission Historical Status Start Date", CURRENT_DATE) <=1 AND "Submission CSW Status - Historical"."Historical Step/Status Was Reverted" = 'No' AND "Submission CSW Status - Historical"."Historical Step Name" = 'New (T)' AND "Submission CSW Status - Historical"."Historical Status Name" IN ('Rejected (T)','Move Forward (T)','Under Consideration (T)') THEN 1 ELSE 0 END BY "Submission General Info"."Submission Identifier") = 1
Paste these in convert to SQL text box.
Hope this helps.
Hi Kiran,
Thanks for the response, we use application tracking CSW step and status, when we are looking for all such transaction that has happened to particular submission. So this helps us in having historical data to be used in reports. If there is requirement for any current CSW step/ status we use Application Current CSW Step/Status. Yes, I agree that using transaction tracking is not as it does not take CSW events, instead if we use Historical Step/status. its not populating complete data.
In this particular SubQuery is used for populating Most Recent Comment, date and user by. In OBI, we have used transaction tracking fields, as historical step/status was not populating data properly. Can you help me with particular sub query as well.
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.
Response to query:
We are looking for History step/status.
Most recent is " Is Most Recent"
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 Identifier") = 1
This will bring the most recent in all the columns.
Later, the trick is check 2 date fields -> Latest Transaction Date and Latest Historical CSW Start Date, whichever is greater show the comments/user from respective sections.
I have attached a sample catalog file. You may unarchive it and test by hard-coding the sample submissions.
There are 3 tables :
1. Latest Transaction
2. Latest History
3. Final columns
If this is successful then we can move with the final solution.
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
We are encountering issues with our OTBI dashboards where there is no option to export to Excel. This seems to be a new issue after the latest update to 26B. I made a change to the report layout (moved one analysis into its own section), and now I cannot export the page. As you can see in my attached photos, the export…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
Could you please provide an update on when the 26C Deprecated BI View Objects document will be available? As Oracle Cloud 26C is scheduled to roll out soon, with test environments expected to be updated on August 7, followed by the production release on August 21, we have a limited window to review and assess any potential…
