https://community.oracle.com/products/oracleanalytics/discussion/24591/how-to-combine-purchasing-real-time-and-requisitions-real-time-subject-areas-in-a-single-analysis Hi @Jose Renato Salvador, Please find below Best Practices to combine the Multiple OTBI SAs: You should have common dimension in the subject areas used in…

https://community.oracle.com/products/oracleanalytics/discussion/comment/63811#Comment_63811 Hi @Mark MacFarlane, Glad to hear that. Can you please select the answer that help you to resolve the issue, it'll be helpful for fellow community members in future. Thank You! Cheers,

Hi @Mark MacFarlane, Please find below another good example. How to use MAX Date in OTBI — Cloud Customer Connect Hope this help. Cheers,

https://community.oracle.com/products/oracleanalytics/discussion/24583/learning-report-to-show-the-most-recent-record Hi @Mark MacFarlane, Have you tried using 'MAX BY'? Please take a look into the following post which might be useful. How to report on training with active reassignment rules & multiple records per…

https://community.oracle.com/products/oracleanalytics/discussion/comment/63718#Comment_63718 Hi @MohammedAmeenmfp10, Can you please check what settings are there in your env for following? Also: Have you tried the same report with different browsers after clearing the browser cache & cookies? Are you able to get similar…

https://community.oracle.com/products/oracleanalytics/discussion/24559/how-to-only-show-workers-who-have-multiple-managers Hi, Can you please try the following XML? It should bring all EMPs who is having more than 1 Manager. https://us.v-cdn.net/6037859/uploads/YHMXFA83PDCM/xml-emps-having-more-than-1-mgr.txt It is only…

https://community.oracle.com/products/oracleanalytics/discussion/24556/how-to-fetch-the-first-start-date-and-latest-end-date-from-multiple-rows-in-otbi Hi @MohammedAmeenmfp10, Have you tried using some aggregate functions like MIN / MAX etc using with those dates? Thank You!

https://community.oracle.com/products/oracleanalytics/discussion/24557/how-to-restrict-otbi-dashboard-report-output-when-user-field-isnt-in-subject-area Hi @Fiona Marran, Can you please send some more details like: Which SA are you trying here? If possible attach your report XML / Catalog. It'll help to replicate the issue…

https://community.oracle.com/products/oracleanalytics/discussion/24546/does-enabling-dff-in-otbi-make-it-available-in-pvo-in-bicc Hi @Nipun Suri, Please take a look into the following doc which might be helpful to understand what are the things available and if not available how to create the extension.…

https://community.oracle.com/products/oracleanalytics/discussion/comment/63653#Comment_63653 Very helpful information. Thank you very much @Mike Durran-Oracle & @Brendan T!

https://community.oracle.com/products/oracleanalytics/discussion/24543/stardard-fdi-controls Hi @Stefano_Mazzocca, Please take a look into the following Oracle document for detailed understanding. It has some detailed tables outlining the comparison among various roles.…

https://community.oracle.com/products/oracleanalytics/discussion/comment/63648#Comment_63648 Hi, Thanks for the details. I was using the attached catalog in our instances and it is working fine. I tried multiple non production environments and it was not throwing any error. Can you please try your report in any other…

https://community.oracle.com/products/oracleanalytics/discussion/24542/how-to-fetch-recipient-details-from-leave-donation-real-time-subject-area Can you please provide some more information like: Is it an existing Report that you are trying to extend? Which subject area has been used here? If possible attach your report…

https://community.oracle.com/products/oracleanalytics/discussion/comment/63645#Comment_63645 Hi, In that case, please handle the NULL conversion in the Data Model it self.

https://community.oracle.com/products/oracleanalytics/discussion/24540/cannot-handle-null-cells-in-calculated-columns-from-layout-editor-in-bip Can you please try replacing NULL with 0 in the calculation. something like: COL3 = (IFNULL(COL1, 0) - IFNULL(COL2, 0)) Hope this help. Cheers,

https://community.oracle.com/products/oracleanalytics/discussion/comment/63640#Comment_63640 Glad you found it useful. Can you please accept the answer / answers that helped you, it'll be very helpful for fellow community members in future. Thank You!

https://community.oracle.com/products/oracleanalytics/discussion/comment/63624#Comment_63624 Hi @Molly P, Regarding point2, would recommend to perform the activities in Non-Prod first like DEV to TEST etc. Please take a look into the following post where there's a good video describing the entire process.…

https://community.oracle.com/products/oracleanalytics/discussion/comment/63624#Comment_63624 HI @Molly P, Regarding point 1, I think it should prompt you whether to take data or not. Please take a look into the following note which might be useful.…

https://community.oracle.com/products/oracleanalytics/discussion/24531/is-there-a-way-to-copy-production-to-test Hi Molly, Please take a look into the following notes which have all the details and might be useful. Migrate content across environments using a content bundle in Oracle Fusion Data Intelligence:…

https://community.oracle.com/products/oracleanalytics/discussion/comment/63602#Comment_63602 Very helpful explanation. Thank you very much @Bret Grinslade - Oracle Analytics-Oracle!