Hi @Josue Jimenez, Try the below:Instead of embedding the image directly, you can reference the image URL dynamically in the RTF template using BI Publisher’s url:{} syntax. Steps to Implement Construct the Image URL in Your Query You already have this part mostly done. Ensure the final URL looks like:…

Hi @User_P6HYL, Try the below:Create Condition-Based Columns First Go to your OTBI analysis. Add a column from the subject area. Click the gear icon next to the column → Edit Formula. Write your condition-based logic using SQL expressions like: Save the column with a meaningful name. sql CASE WHEN "Employee"."Department" =…

Hi @Narendar Rao Naineni, Please try the below: Open the OTBI Report: Navigate to the OTBI report that contains the bar graph you want to modify. 2.Edit the Graph View: Click on the graph view (not the table or pivot view). Choose Edit View to open the graph configuration. 2. Access Graph Properties: In the graph editor,…

Hi @Narendar Rao Naineni, Please try the below:Open the OTBI Report: Navigate to the OTBI report that contains the bar graph you want to modify. 2.Edit the Graph View: Click on the graph view (not the table or pivot view). Choose Edit View to open the graph configuration. 2. Access Graph Properties: In the graph editor,…

Hi @AVorster-Oracle, Please check this : Platform Reports Library Opens Reports and Books Directly in Excel Exporting Formatted Reports to Excel Thanks, Riyaz Ali

Hi , Please check the below as it might be helpful: Line Manager not able to view the direct reportees — Cloud Customer Connect Fusion Global HR: Line Manager is not able to access direct reports in My Team (Doc ID 2303898.1) Thanks, Riyaz Ali

Hi @Varun Dhondea , Check this: BICC PVO for privileges and their link to roles — Cloud Customer Connect Thanks, Riyaz Ali

Hi @User_B857U , Try the below:Create the Dashboard Prompt: Go to New → Dashboard Prompt. Select a subject area that contains the column you want to prompt (e.g., Business Unit, Department). Add the column as a Column Prompt. Set it to populate a presentation variable, e.g., P_BU. Modify Each Query in the Union Analysis…

Hi @skhan, The problem arises because the TopN filter is applied before the prompt value is processed, causing the report to default to a specific Business Unit and ignore user selections. Try the below:Use a Presentation Variable in the Filter: Instead of hardcoding the TopN filter, use a presentation variable tied to the…

Hi @Ivony Ann Paula Salango , Extra Spaces or Characters. These often come from: Concatenated columns with manual spacing. Hidden HTML tags or formatting in text columns. Null values being replaced with placeholders. Try the below:Use TRIM() and REPLACE() functions in your OTBI column formula: sql…

Hi @User_MHPVE, XCC_BALANCES Stores budget balances including consumption and available funds. XCC_BUDGET_DIST_ACCTS Contains distribution account details for budget entries. XCC_CONTROL_BUDGETS Holds control budget definitions. XCC_BUDGET_TRANSACTIONS Captures individual budgetary control transactions. SELECT…

Hi @Luke.Findex , You can by try by using presentation variables in your dashboard prompts. Here's how to set it up so that users select a Display Name, but the system uses the corresponding Person ID behind the scenes to filter multiple analyses—even across different subject areas. Create a Dashboard Prompt Go to New →…

@Amrish_Amradkar, Try the below:Edit the OTBI Dashboard. Add a new section to the dashboard page. Insert a Text object into that section. In the Text object, add the following HTML: Hide the section so it doesn’t interfere with the dashboard layout. <META HTTP-EQUIV="REFRESH" CONTENT="60"> This refreshes the dashboard…

Hi @Ivony Ann Paula Salango, Thanks a lot. Thanks, Riyaz Ali

Hi @Dinesh T , You can use a WHERE clause like this in your BI Publisher SQL: WHERE prb.effective_date BETWEEN TO_DATE(:start_date, 'YYYY-MM-DD') AND TO_DATE(:end_date, 'YYYY-MM-DD') AND ppa.action_status = 'C' -- Only closed payroll actions SELECT prb.balance_value, prb.effective_date, pdb.balance_name, ppa.action_status…

Hi @Jose Angel RuizMen You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance. Thanks, Riyaz Ali

Yes, it is absolutely possible. Please review the below KM note: How To Restrict Access To Custom and Other Folders in Reports and Analytics As All Users Have BI Consumer Role (Doc ID 2764614.1)

Hi @Srinivas_Buddharaju, Try the below and see if it helps:Reinsert the Image as a Supported Format Delete the existing logo/image. Reinsert it using Insert > Picture > From File in Word. Use PNG or JPG format. Save the RTF again and test in BI Publisher. Ensure the Image Is Embedded (Not Linked) In Word, right-click the…

Hi @Arun P_Kumar , Please check the below URL: Including User Information Stored in System Variables in Your Report Data Thanks, Riyaz Ali

Hi Prateek, Check below URL for more details: Creating a Business Intelligence Cloud Extract Thanks, Riyaz Ali