Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi @User_E4X3H, Thanks for the details. Yes, your understanding is correct. If you are looking for all the available objects, lineage etc. please take a look into the following posts. Hope this help. Cheers,
-
Hi @User_E4X3H, Can you please provide some more details regarding your requirement & query so that fellow community members can help you. Cheers,
-
Hi Giorgia, Glad you are able to solve the issue, that's great news. Thank You! Cheers,
-
Hi @Vishnu.R, Please take a look into the following Oracle notes which might be useful. Hope this help. Cheers,
-
Hi @Sumanth V -Oracle, Very informative & very helpful information. Thank you very much! Cheers,
-
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!