How to hide tables in Oracle BICS Modeler — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

How to hide tables in Oracle BICS Modeler

Received Response
41
Views
3
Comments
Saud
Saud Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Summary

How to hide tables in Oracle BICS Modeler

Content

Hi all,

Can anyone please tell me how to hide table in Oracle BI Cloud Service Modeler.

Thanks.

Answers

  • Saud
    Saud Rank 3 - Community Apprentice

    Hi Kaviraj,

    I tried this option as well. I click on hide from everyone but still it is visible in Analysis and Visual Analyzer.

    Thanks,

    Saud

  • Kaviraj Sekar-Oracle
    Kaviraj Sekar-Oracle Rank 3 - Community Apprentice

    Hi Saud,

    I think you should have the option of hiding tables based on Roles.

    Under Model ---> Table Name --> Permissions Tab --> Select or Add Preferred Role( or Everyone) and give Hidden.

    Have you tried this already ?

    Thanks,

    Kaviraj.

  • SantoshKumarBhairi
    SantoshKumarBhairi Rank 6 - Analytics Lead

    Hi Saud,

    You may want to check all the responsibilities the user is associated with. For example, you want to hide 'customer dim' from User # 1 who has responsibility 'Sales Region EMEA'. You can explicitly grant it to this User.   And if the same User # 1 has access to other responsibilities, the table in question will still be visible. So the bottom-line, follow what Kaviraj explained above to set Hidden or Visible for a responsibility.