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!

https://community.oracle.com/products/oracleanalytics/discussion/24527/dunning-letters-seeded-report-questions-on-senddunningbatchprocess-report Hi @Terri Norris, Can you please check the following Oracle Notes for the issue in point1? https://support.oracle.com/knowledge/Oracle%20Cloud/2490437_1.html Cheers,

https://community.oracle.com/products/oracleanalytics/discussion/comment/63591#Comment_63591 Very helpful information. Thank you very much @Federico Venturin!