Oracle Business Intelligence Applications

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

Categories

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

Trying to create an Absence Report and restrict view to session login HR/ HR Generalist

Received Response
1
Views
5
Comments
3397433
3397433 Rank 1 - Community Starter
in Oracle Business Intelligence Applications

Hi,

Am trying to Create an Absence Report. I want to create a filter criteria where the Report have to populate results according to Department which are under that Particular Signed in Hr Generalist.

Please help me creating this filter or Security criteria.

Thank you.

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Hi,

    to do this you need; -

    an sql query that would provide the row / rows of data for each user

    to create the variables to hold this row level initialised data

    an init block to be defined to populate the data for the session

    this to be then associated with the users via the mediums of groups set up for the purpose (i.e. there might be exec / admin users that you do not want the security to apply to) and filters created to apply the security to the facts / dimensions in question (note you need to apply it to both sides)

    Hope this helps give you the skeleton of what you are looking at to achieve what you describe.

  • 3397433
    3397433 Rank 1 - Community Starter

    Hi Robert,

    It would be a great help if you would share your SQL, Which you have used at your end for similar kind of requirement.

    Thank You.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Sorry, I have not implemented the exact filter that you describe, and I suspect that your requirement is specific to your business, so to achieve this you really need someone locally who can write sql in conjunction with a functional HR specialist and yourself to explain your exact requirement.

    The key question you need answering is how is it configured in your e-business system to associate an 'HR generalist' with department or department(s).

    If someone can write SQL code that when given the 'HR Generalist' returns Departments covered by that person, then you can achieve your requirement.

    Good Luck!

  • John_K
    John_K Rank 5 - Community Champion

    Have you set up security profiles in EBS to secure the user to just the employees they are allowed to see?

  • Venkata Yaswanth Ramisetty
    Venkata Yaswanth Ramisetty Rank 5 - Community Champion

    Hi,

    We got the same requirement and I thought and implemented the below approach..

    1. Create helper report. Report with employee number/ username, department

    2. In the main report, use a filter where department in (select department from helper report)

    3. Based on above result, you will get all the departments.. So, we need to restrict based on the user who logs in.

    4. In helper report, add a filter where username/ employee number in VALUEOF(NQ_SESSION."DESCRIPTION"). This will return the department of the specific user who logs in.

    5. The user will be created in console right? So, in the console, for the users, under description, provide their login username/ employee number based on your helper report field.

    6. For other users, report should display all the departments details. for that in the helper report itself provide VALUEOF(NQ_SESSION."DESCRIPTION") or (1=1).

    Hope this helps..

    Thanks,

    Yaswanth