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 the report. Add at least one Measure/Fact/Metric from each subject area on the report. Click on the Advance tab of the Analysis report --> Scroll down till you see…

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,

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 employee? — Cloud Customer Connect Hope this help. Cheers,

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 report from other subject areas? Thank You!

Hi, Can you please try the following XML? It should bring all EMPs who is having more than 1 Manager. It is only having Employee Name, Number & Manager Count. Please check if it is working for you and if it is working then feel free to extend as per your requirement. Hope this help. Cheers,

Hi @MohammedAmeenmfp10, Have you tried using some aggregate functions like MIN / MAX etc using with those dates? Thank You!

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 at our end also will help to find any resolution. Thank You!

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://www.ateam-oracle.com/post/bi-cloud-connector-custom-object-data-extraction Hope this help. Cheers,

Very helpful information. Thank you very much @Mike Durran-Oracle & @Brendan T!

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.…

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 non-prod environment to see if it is working there. Also can you please try this report with an…

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 xml / catalog. It'll help to replicate the issue in our end and will help to find potential root cause or any resolution. Thank You!

Hi, In that case, please handle the NULL conversion in the Data Model it self.

Can you please try replacing NULL with 0 in the calculation. something like: COL3 = (IFNULL(COL1, 0) - IFNULL(COL2, 0)) Hope this help. Cheers,

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!

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/kb/articles/23-faw-tech-tips-fusion-analytics-bundles…

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.…

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://blogs.oracle.com/analytics/post/faw-migrate-oac-content-kpis-and-decks-using-a-content-bundle Migrate Your Content:…

Very helpful explanation. Thank you very much @Bret Grinslade - Oracle Analytics-Oracle!