Access BU in BIP based on UI Roles
Summary:
I have a client who has requested a specific functionality for displaying Business Unit (BU) names in the Business Intelligence Publisher (BIP) List of Values (LOV) based on the roles assigned to each user. The requirement is as follows: if a user has the "Payables" role but not the "Receivables" role, they should only see a specific BU in the LOV when generating a BIP Report for Payables, and this specific BU should not be available for selection in Receivable Reports.
I am currently in need of a query that can fulfill this requirement. It's important to note that the client expects all roles based on modules to be visible in the BIP application, just like how they can see the BU name in the Billing Dashboard or Payable Dashboard. Consequently, the BIP report should also accurately reflect the corresponding BU.