Hi Mark, Can you please try below? $if{ (:p_agg_pic_acc == Yes) }$ $if{ (:p_agg_zero_supp == Yes) }$ SQL Statement $endif$ $else{ SQL Statement }$ $endif$ Thanks.

Welcome to Oracle Analytics Community. As per my knowledge, this is not supported for most of the transactions. Normally we schedule the extracts to sync the DWH. Thanks.

Hi, Can you schedule the report and check approx how much time it is taking to run? The error while editing, can you try it in incognito mode? I have seen this happening where there was a lot of code in one of MY BIP reports. Thanks.

From there, it is not possible currently. Thanks.

Hi @User_VOGVU Welcome to Oracle Analytics and AI community. @Raghavendra Raghunath-Oracle , can you please help here? Thanks, Mandeep.

Hi Abdul, Welcome to Oracle Analytics community. You can try using RANK function: Can someone help me how to apply Pivot in my OTBI Analysis? — Cloud Customer Connect Thanks.

Hi Rosita, If your filters are at query level, then there is no restriction. Thanks.

Hi Mohammad, Please check the query on below thread: https://fusionhcmconsulting.com/2025/01/bip-report-to-extract-bip-scheduled-jobs/ In this query, you can pull data from ess_request_property where name = 'CONTROL_XML'. Value for this name will give you data that you are looking for. Thanks.

Excellent, thanks for sharing !!!

This is awesome. A great visualization.

This is wonderful. Quite innovative.

Congratulations all !!!

Thanks for the reference but it seems the issue is still there in 26A while the knowledge base article talks about 22a/22b only. Thanks.

Thanks for the update, Roger.

There is no specific code for a scheduled trigger. It will be similar to your main query but will return true/false to indicate if the data will be returned by main query or not. Check below links for working examples: Skip Schedule using Schedule Triggers in BI Publisher Creating Schedule Triggers Thanks.

Hi, Welcome to Oracle Analytics and AI community. As your query is more specific to Fusion SaaS, I would suggest you to post your query on clous customer connect (a sister community) for better traction and response: Reporting and Analytics for ERP — Cloud Customer Connect Thanks.

Hi, Can you check if there is no change in the setup of GL KFF in your production system? Compare the setup of these segments in Test and Prod and then check? Thanks.

Thanks for confirming. It has always works well for me. Oracle BI EE OTBI Query multi Select query — Oracle Can you explain what issue you are facing? Thanks.

Hi Rosita, Welcome to Oracle Analytics and AI community. There is no such things as filter disappearing from BI reports. It is mostly that for some people the condition is failing. Can you check the values of co_attribute1 and legalentity_identifier and then execute your iNSTR function standalone for those specific users…

Hi Sara, Welcome to Oracle Analytics and AI community. This is currently not supported in OTBI and only way to get this information is to use BIP. Thanks.