Oracle Analytics Cloud and Server

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

Two users view with mask

Received Response
35
Views
8
Comments
TANI_TOL
TANI_TOL Rank 2 - Community Beginner

Hi everyone ,

I have 2 users to connect to the  BI report and one data model. One user will see the columns in the report with mask  the other user without the mask for same report.

How can i do it ? Is it possible?

Thx,

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    One option would be to have 2 columns defined in your repository.

    one with data

    one with masked data

    In your analysis, you can use a CASE statement in the column formula to identify which user is running the analysis and then select which presentation column to display. I would suggest that the users are derived from groups/application roles rather than users themselves.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    No offence to the other two guys, but that's out-of-the-box / vanilla / standard functionality. You just put access permissions on the presentation column.

    Can't get more basic than that.

    Also: it's an "analysis". Not a "report". "reports" are BI Publisher objects and a different technology alltogether.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    doh!

    Though - there is no allusion to version of OBIEE - can he?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    If he has anything above Siebel Analytics 7.0, yes X-D

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Wow, okay, did not realise I had been overlooking field level redaction all of these years!!

  • TANI_TOL
    TANI_TOL Rank 2 - Community Beginner

    Thank you Robert . I did .

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    You did what? Is your topic closed? Which path did you choose? Can you mark the answer that was correct?