Hi Giorgia, It seems from the error message that the user who is trying to execute the report has no access to the report or the report folder ('/Custom/XX_xxxxxxxxxx/xxx_xxx_xx_xx.xdo'). Please check the existing security / permissions currently present at the above folder and either add the user on existing groups that…

Hi @Stefano_Mazzocca, No problem at all. Thanks for the details. Yes, you can certainly do it. Just define few Exception (Data Quality) reports based on your requirement. These reports will only return data if that particular condition occurs. Here's an example for you using OTBI SA: Workforce Management - Worker…

Hi @Stefano_Mazzocca, Thank you! In this case you have to have a look into the Oracle HCM Person Record and correct the data accordingly there. Here's an example: Say, there was no Date of Birth for Bhaskar Konar which is returned by the FDI Report. Now if you check into the HCM Application the same person has no Data of…

Hi @Stefano_Mazzocca, Quick Question: What is your source application (Transactional System) here?

Hi @Stefano_Mazzocca, Thanks for the details. You can create some exception / data quality reports in your FDI instance based on the area that you want to check. i.e. You can create a report which will give you all persons details for whom Birth Date is NULL or Salary not present. Now based on those data you can correct /…

It'll be very helpful. Thank you very much @Daniel C Mohan-Oracle!

Hi @User_PGUES, Please take a look into the following article which might be useful. Hope this help. Cheers,

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. 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. Also, please take a look into the following blog which might be helpful to understand the concept for customizing any security config. Hope this…

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!