How to Restrict Business Units based on user access in OTBI parameter lov

Question

Is there any way to restrict the Business Unit based on the User access in OTBI parameter

Example: If user A is assigned with US BU USD and US MFG BU USD Business unit in manage data access in fusion, then in the OTBI report parameter LOV that user should be able to see the BU's which are assigned to them in Manage data access

Nathan CCC · Answer

Hi, Yes most subject areas in ERP for the job roles you have that include this data security policy use security context Business Unit from page Manage Data Access for Users. But the designer of the subject areas has tended to put the data security only on the facts measures but not on the dimensions themselves. So if in a list of values on your prompt your analysis in OTBI or report in OTBI if you have only selected the attribute column it may display all business units even if you are not allowed to view transactions for some of them. Including a measure column will let you see only the business units your are allowed to see that have at least 1 transaction.