Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Check this: Could not establish connection. Connection to Microsoft Azure SFTP server is not supported at this time. (Doc ID 2983577.1)
-
If my response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for
-
Hello Craig W NNL, Please check the below: SQL for Current approver of AP Invoice — Cloud Customer Connect Try this: SELECT ai.invoice_id, ai.invoice_num, aiah.approver_id, fu.user_name AS approver_user_name, aiah.approval_history_id, aiah.action_date, aiah.history_type, aiah.approver_action FROM ap_invoices_all ai JOIN…
-
If my response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for
-
Try the below: Suppress Blank Lines with <?if:condition?>...<?end if?> Use inline formatting like: <?if:FIELD!=''?><?FIELD?><?end if?> Check the below: Setting Report Processing and Output Document Properties
-
Ho @Anil Pandey-Oracle, Try the below:Use normalize-space() in the RTF Template Wrap your field expression like this: xml Avoid fo:bidi-override Unless Necessary While fo:bidi-override helps with left-to-right formatting, it can introduce Unicode control characters. If your data is already left-to-right (e.g., numeric…
-
Hi @Mark Stoker, 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
-
Try running the below: Run the “Refresh Manager Hierarchy” Process Run “Synchronize Person Records”
-
Hi @AVorster-Oracle, As I mentioned earlier, 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
-
Hi @User_KNFCO , Please try the below: SELECT ID, Test_Date, Test_Type, Test_Result, COUNT(*) OVER ( PARTITION BY ID, Test_Type ORDER BY Test_Date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) AS Attempts FROM ( SELECT *, MIN(CASE WHEN Test_Result = 'Pass' THEN Test_Date END) OVER (PARTITION BY ID, Test_Type) AS…
-
Hi @AVorster-Oracle, Please check this: Delivered Reports in Fusion HCM — Cloud Customer Connect What all are the standard reports available in Oracle Fusion HCM? — Oracle Analytics You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance. Thanks,…
-
Hi @Amit Kumar Sah , You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance. Check this: Preview Invoice Report Thanks, Riyaz Ali
-
Hi @Anjum Saeed , If my response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Thanks, Riyaz Ali
-
Please check below: Create a Chart from an OTBI Analysis Graph Data in Analyses
-
If you are not getting the "Bar width" , "Bar gap" or "Cluster width".Try the below:Change the Graph Type Switch between Vertical Bar, Horizontal Bar, or Clustered Bar. Clustered Bar graphs naturally introduce spacing between categories. Limit the Number of Categories Fewer categories on the X-axis = more space between…
-
Hi @User_63K6C, Try the below:To ensure the correct order of operations, you need to calculate Total Feet Shipped at the item level first, then aggregate that result by Month. Create a Calculated Field at the Granular Level Name: Item-Level Feet Shipped Formula: {Quantity Shipped} * {Item Length} This ensures the…
-
Hi @User_HCKQU, Try the below:Rename Columns Without Special Characters Change "Actuals/Targets" to a simpler alias like "ActualsToTargets": sql select A.*, case when ActualsToTargets >= 1 then '>=100%' when ActualsToTargets >= 0.75 then '>=75-100%' when ActualsToTargets >= 0.5 then '>=50-75%' when ActualsToTargets >= 0.25…
-
Hi @KDR, Try the below:Instead of using the “Generate RTF layout” button, follow this approach: Create Report from Data Model Go to your Data Model. Click Create Report. Use the Report Wizard to generate a basic layout. Save the report and download the sample XML data. Design RTF Template Manually Open Microsoft Word with…
-
Hi @Anjum Saeed , Try the below:Use CSV Format Instead: Export the report as Data → CSV. CSV files don’t have the same row limit and can handle hundreds of thousands of rows. You lose formatting, but you retain all data. Split the Report Output: Modify your report logic to split data into multiple sheets or files. For…
-
Hi @Amit Kumar Sah , Please check the below: Preview Invoice Report Fusion Applications BI Publisher : How Should We Create New BI Publisher Reports or Customize Existing Seeded BI Publisher Reports? (Doc ID 1926322.1) Thanks, Riyaz Ali