Oracle Communities

Oracle Analytics and AI

Child Item

Subject Area 'Performance Check-in Real time' doesn't provide any results

We have an OTBI report requirement to fetch the Performance related details along with specific question texts and responses. When we use Subject area 'Performance Check-in real time' it doesn't provide any results.

Please let me know if anybody faced this issue. Kindly let me know if we have a solution for this.

Thanks,

Keerthana.

test (1).catalog

Find more posts tagged with

Accepted answers

Nathan CCC

Hi The where clauses for data security are added at runtime after you submit your query. You will never see them in the logical SQL on the advanced tab of your analysis which is what you cut paste in the previous post. You have to view log in manage sessions to see the one or more generated physical SQL(s) (normally WITH… statements) that query the application source transaction database tables and views for your user and roles that are used by BI to answer your question in your logical SQL.

All comments

Nathan CCC

Hi,

As per the user guide for subject area
Workforce Performance - Performance Check-In Real Time

Oracle Fusion Cloud HCM
Subject Areas for Transactional Business Intelligence in HCM G12536-01 24D

https://docs.oracle.com/en/cloud/saas/human-resources/24d/faohb/Workforce-Performance--Performance-CheckIn-Real-Ti-SA-81.html#Workforce_Performance__Performance_CheckIn_Real_Ti_SA_81_d1e21639

To be able to query this subject area without throw a database connection error then you need a pre-defined job role or custom job role that inherit duty role Performance Management Transaction Analysis Duty. But this does not mean you will get any rows if the subject area has data security on rows and columns.

If you look in your job roles Human Resource Analyst and Line Manager you will see data security policies. To make it so you get data you must go to navigator My Enterprise work area Setup and Maintenance . Use task "Manage Data Role and Security Profiles". Create a custom data role that inherits your job role from above with security profiles to view persons etc.

Now a user with this data role will get get results from a query on this subject area in either a) your analysis in OTBI that query this subject area or b) your publisher report in OTBI with dataset either i) type SQL that query this subject area with data source Oracle BI EE or ii) data set type analysis that reference an analysis that query this subject area.

For example, we created a custom "read only" job role which is a copy of pre-defined job role Human Resource Analyst, nothing added, no change to data security profiles, removed all roles except for required roles with "transaction analysis", removed all function security policies. Then we created a custom data role inherit that that custom job role with data access using a custom security profile on persons by areas of responsibility we setup to limit to persons with work assignments starting at various nodes in our department hierarchy.

KeerthanaBaskaran

Thank you @Nathan CCC . I will check on this.

gclampitt

If you look at the SQL that has been generated when you've ran the report ..

if this shows "and 1=2"…. then this means you don't have a role that grants access.

If you have the required role, you will see "and 1=1"

KeerthanaBaskaran

Thanks @gclampitt . But i don't see both of the conditions in the SQL.

I'm pasting the SQL for reference.

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Workforce Performance - Performance Check-In Real Time"."Check-In Questionnaire"."Worker Question Text" s_1,
"Workforce Performance - Performance Document Status Real Time"."Business Unit"."Business Unit Name" s_2,
"Workforce Performance - Performance Document Status Real Time"."Department"."Department Name" s_3,
"Workforce Performance - Performance Document Status Real Time"."Job"."Job Name" s_4,
"Workforce Performance - Performance Document Status Real Time"."Legal Employer"."Name" s_5,
"Workforce Performance - Performance Document Status Real Time"."Manager"."Name" s_6,
"Workforce Performance - Performance Document Status Real Time"."Performance Document Details"."Performance Document Status" s_7,
"Workforce Performance - Performance Document Status Real Time"."Performance Document"."Performance Document Period Name" s_8,
"Workforce Performance - Performance Document Status Real Time"."Review Period"."Review Period Name" s_9,
"Workforce Performance - Performance Document Status Real Time"."Worker"."Employee First Name" s_10,
"Workforce Performance - Performance Document Status Real Time"."Worker"."Employee Last Name" s_11,
"Workforce Performance - Performance Document Status Real Time"."Worker"."Person Number" s_12,
DESCRIPTOR_IDOF("Workforce Performance - Performance Document Status Real Time"."Business Unit"."Business Unit Name") s_13,
DESCRIPTOR_IDOF("Workforce Performance - Performance Document Status Real Time"."Job"."Job Name") s_14,
"Workforce Performance - Performance Check-In Real Time"."Check-Ins"."Checkins" s_15,
"Workforce Performance - Performance Document Status Real Time"."Performance Document Status"."Performance Documents" s_16
FROM "Workforce Performance - Performance Document Status Real Time"
WHERE
("Workforce Performance - Performance Check-In Real Time"."Check-In Questionnaire"."Worker Question Text" IN ('Quels sont vos souhaits de développement à court terme?', 'Quels sont vos souhaits de développement à moyen terme?', 'Avez-vous des souhaits de mobilité géographique?'))
ORDER BY 13 ASC NULLS LAST, 11 ASC NULLS LAST, 12 ASC NULLS LAST, 7 ASC NULLS LAST, 5 ASC NULLS LAST, 15 ASC NULLS LAST, 4 ASC NULLS LAST, 3 ASC NULLS LAST, 14 ASC NULLS LAST, 6 ASC NULLS LAST, 9 ASC NULLS LAST, 10 ASC NULLS LAST, 8 ASC NULLS LAST, 2 ASC NULLS LAST
FETCH FIRST 250001 ROWS ONLY

Nathan CCC