I used this method but it didn't work.
@Salma Ashraf - Does your data have null values as well for Person_number? If yes, that could be the issue, as Oracle BI EE connection doesn't handle NULL values. Please refer below thread where they have suggested how the null values should be handled.
Hi @Salma Ashraf,
Could you try like this instead of the SQL statement you used for Person number? Since you use NULL values as passed radio button, I doubt it would pass 'All' back to the query. It will send NULL. Try revising the statement like this and let know if it works.
AND (person_number IN (:person_number) OR LEAST(:person_number) IS NULL)
Thanks ,
Abhilash
Hi @Abhilash K - Deloitte USI
Oracle BI EE often enforces security restrictions that might prevent using functions like NVL or LEAST directly in the presentation layer.
also when i put this statement AND (PERSON_NUMBER IN (:person_number) OR 'All' IN (:person_number || 'All')) in my query it gives me this error when i run the query
Thanks in advance
Salma Ashraf
Hi, We are scheduling a report to be sent out every week. We were wondering if it was possible to keep the latest date that the report ran as a parameter somewhere so that we could use that to only fetch the values in the report which have a latest update time of after the last run of the report? This way we'd only be…
Hi everyone, I'm using Oracle BI Publisher version 12c and recently I notice a strange error: when I schedule some reports that use excel templates (.xls), their output can not be opened without the error message "The file format and extension of <report_name> don't match. The file could be corrupted or unsafe. Unless you…
Hi everyone, We configured a SOAP connection in Oracle Integration Cloud (OIC) using OAuth authentication. However, when we run our integrations, the SOAP invocation fails intermittently. Some integration iterations fail. Most iterations succeed. Sometimes, all iterations complete successfully without any issues. When we…
OTM/GTM Product is currently using OAC for reporting. We wanted to know what is the limitation for oracle BI Publisher rtf template size. We already have verified the documentation : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/top-faqs-design-publisher-reports.html But wanted to know if this generic figures…
Hi, We are trying to retrieve the complete history Bip report of assignment updates where the same assignment record has been modified multiple times with an unchanged Effective Start Date. We are currently using PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_M_; however, the data returned does not consistently reflect all…
