Welcome to the Oracle Analytics Community

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

Melissa-67834 Rank 1 - Community Starter

Comments

  • I used the following expression to populate zero for employee number null values. In the report, if employee number does not exist on the profile, 0 is returned. If employee number does exist, employee number is returned. IFNULL("System User - Personal Information"."User Employee NO",0) -Melissa
  • Reporting folders can have security applied and visibility restricted to a specific user group. 1. Create user group which should have access to the confidential reports 2. Create a folder in OBI and place the confidential reports in this folder 3. Navigate to the Welcome Center / Table of Contents, access Configuration >…
  • Try editing the formula for historical status to select the max date. Max("Submission CSW Status - Historical"."Submission Historical Status Start Date")