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 table/KPI:
When this same KPI gets added into the RAC, I still see 18 reqs which is correct if no session variables are applied.
Here are the session variables I'm using in my filter:
("Job Requisition - Hiring Team"."Recruiter Person Identifier" = VALUEOF(NQ_SESSION."PERSON_ID_HCM")
OR
"Job Requisition - Hiring Team"."Collaborator Person Identifier" = VALUEOF(NQ_SESSION."PERSON_ID_HCM")
OR
"Job Requisition - Hiring Team"."Hiring Manager Person Identifier" = VALUEOF(NQ_SESSION."PERSON_ID_HCM"))
I found an old Infolets post saying a similar thing, and I already tried the "Bypass Oracle Analytics Presentation Services Cache" which was recommended there. Does anyone know if it's possible to use session variables in these KPIs/Visualizations?
Thanks,
Nick
