Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Accepted answer
35
Views
5
Comments
KeerthanaBaskaran
KeerthanaBaskaran Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence

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

Best Answer

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    Answer ✓

    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.

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited Oct 15, 2024 8:08AM

    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.

    image.png
  • KeerthanaBaskaran
    KeerthanaBaskaran Rank 3 - Community Apprentice

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

  • gclampitt
    gclampitt Rank 6 - Analytics Lead

    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
    KeerthanaBaskaran Rank 3 - Community Apprentice

    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