https://community.oracle.com/products/oracleanalytics/discussion/28094/permissions-information-in-oracle-reports-and-analytics-across-sub-folders-and-items Hi Naveen, Welcome to Oracle Analytics community. There is an idea already submitted for same with more votes. I will advise you to evaluate the existing idea nd upvote…

https://community.oracle.com/products/oracleanalytics/discussion/28087/to-add-custom-extension-to-email-bursting-output Hi Vinay, Welcome to Oracle Analytics community. Is this a query or you are submitting an idea for product enhancement? This forum is an idea lab where you have posted your query, If it is a question,…

https://community.oracle.com/products/oracleanalytics/discussion/28091/oracle-bi-ee-otbi-query-multi-select-query Hi Mahesh, Welcome to Oracle Analytics community. You can try like below: AND (paaf.organization_id IN(:Department) OR (LEAST(:Department)IS NULL)) Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/74920#Comment_74920 Hi, Welcome to Oracle Analytics community. I have many BIP reports scheduled in our HCM environment with multi value parameters. But the values use semi colon (;) as a delimiter: Will it be possible for you to share a screen shot…

In addition to above, check below as well: Activate the Oracle Fusion Data Intelligence Subscription Thanks.

Upvoted. Much needed.

This will be a great enhancement. We are also looking for this functionality.

Upvoted !!!

https://community.oracle.com/products/oracleanalytics/discussion/comment/74995#Comment_74995 Please evaluate and upvote below idea: Ability to see output of an OTBI agent - Page 4 — Oracle Also, you can explore below:…

This is one of the most common requirements from many customers which is pending for delivery from Oracle side. From a customer perspective, they should have access to agent outputs/ recipients similar to BIP job reports history.

https://community.oracle.com/products/oracleanalytics/discussion/28080/access-run-history-older-report-outputs-of-otbi-scheduled-reports HI Ameya, Unfortunately for OTBI, there is no view history option available. You can only view the last run date using OTBI Usage Real Time subject area. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/74884#Comment_74884 Hi, Did you enable the BI enabled checkbox on the DFF attribute level setup? Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/28179/employee-address-historical-data Hi Ultika, I don't think you can pull address history in OTBI. You will need to build a BIP report. Person Address History — Cloud Customer Connect Worker Address History in OTBI! — Cloud Customer Connect Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/27989/how-to-fetch-the-fetch-the-content-id-based-on-ess-job-request Hi Prasad, Is the ESS job bursting the file to content server? Thanks.

Upvoted. Must have feature.

Upvoted. This will be useful.

https://community.oracle.com/products/oracleanalytics/discussion/27969/analytics-report-shows-pervious-direct-reports-for-the-manager Hi Shaily, I think this report is fusion OTBI analytics but details are missing as highlighted by Gianni. But on the looks of it, it looks like manager hirearchy refresh is missing. Can you…

https://community.oracle.com/products/oracleanalytics/discussion/27911/which-table-stores-parent-child-relationship-of-account-hierarchy-in-oracle-fusion I think this data is created as dependent value sets, so you should get it in the value set tables only. Thanks.

This is a much-needed functionality. It becomes tiresome to figure out when an end user reports about a missing expected email.

https://community.oracle.com/products/oracleanalytics/discussion/27910/how-to-call-dbms-crypto-package-from-oracle-bi-publisher Hi, As per my knowledge, you won't be able to use this directly in select clause. You can try to explore the procedure call method in BIP and see if that works: PL SQL block from Fusion BI Report…