Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hello Helen, We do this for our common reports where we want to limit the data for a particular user based their BU. The easiest way is to set a report prompt and then in that prompt you select the Default BU to be retrieved based on the users Session Username. I use the following SQL: SELECT "Business Unit"."Business Unit…
-
This would allow us to rapidly identify fields which may be impacted by a Quarterly Release change. It would also allow us to identify fields being used which need modification e.g. through the use of formulas, or removing and replacing with a different field. Our dashboards may be built up with hundreds of individual…