How to hide tables in Oracle BICS Modeler

Question

Summary

Content

Hi all,

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

Thanks.

SantoshKumarBhairi · Answer

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.

Saud · Answer

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 · Answer

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.