Hi @Abhishek Bagh, Glad it worked for you. Would you mind selecting the best answer that resolved your issue so that it'll help fellow community members in future? Cheers,

Hi @Abhishek Bagh , The formulas are really interesting, thanks for sharing. Would you mind using formula like below? Values will be on Float: CAST(TIMESTAMPDIFF(SQL_TSI_DAY, "Worker"."Enterprise Seniority Date", CURRENT_DATE) AS FLOAT) / 365 without decimal: TIMESTAMPDIFF(SQL_TSI_DAY, "Worker"."Enterprise Seniority Date",…

Hi Abhishek, Would you give some more details like what Tenure you are looking to calculate here? Perhaps you can attach your report xml / catalog if that's better. Cheers,

Hi Abhishek, I'm glad it worked & you find it useful. Can you please select the Best Answer that solved your issue? It'll help fellow community members in future. Cheers,

Hi Abhishek, There's a 'Manager Flag' inside 'Manger' Folder under 'Worker' Folder in Assignment SA, Person SA etc. BUT this is not a mandatory field in UI, as result it might not have always correct data. If your ORG has made that field as mandatory and making sure while creating data / transactions the values are entered…

Hi Abhishek, Try the following fields inside 'Manger' Folder under 'Worker' Folder in Assignment SA, Person SA etc. Also PFA a sample XML. Hope this help. Cheers, XML - Manager Assignment Status.txt

Thank you very much Mandeep. Appreciate your help. Cheers,

Hi AjayKumar Maddipati, If you want all the formatting that you did in Report to show you in downloaded version then you have to use the 'Formatted' way and then download in excel or your preferred options. If you use Unformatted / CSV then raw data will be downloaded irrespective of any format that has been applied in the…

Hi Volodymyr, Have you tried clearing cache both browser & BI? If the issue still persisting after clearing cache, can you please check if you execute the report with the user what result it is giving in both summary & detailed level? Also was that report previously working fine for the same user in both level? if there's…

Hi Chukwuemeka Aniukwu, It means security is restricting you. You need to have the roles like HR View All to view all data. By default it will allow you to see only your own data or in case if you are a Line Manager then your own team's data. Make sure you have the correct role. It should give you all data. Hope this help.…

Hi Can you please check the following? The OTBI analysis based on "Workforce Management - Accrual Real Time" subject area does not show all the accrual plans for a given employee: Document 2306225.1 (oracle.com) Hope this help. Cheers,

Hi Chukwuemeka Aniukwu, Please try the following Subject Area. You should be able to find most of the data items that you are looking for. Workforce Management - Person Real Time Hope this help. Cheers,

Satyabrata Nanda, Glad it worked for you. Thank you. Cheers,

Can you check with the word 'Custom' as you can't assign the OOTB BI Admin Role, it needs to be custom role which will be having BI Admin. Hope this help. Cheers,

Hi Virginia M. Calvi, Would it be possible for you to share the Report XML or Catalog so that it can be looked into more details. Cheers,

Thank you very much Gaurav. Appreciate it.

Hi @Gaurav Bharadwaj-Oracle , Thank you very much. Appreciate your help. Cheers,

Hi @Satyabrata Nanda , Can you please check the attached XML if it provides the info you are looking for? It will give you the Line Manager and it's initial Day. Hope this help. Cheers, XML -- LM - Start Date.txt

Hi @Mirza_Adeel , You can select a Dashboard Page to be delivered from the 'Delivery Content' Tab as shown below: Hope this help Cheers,

Hi @Heather Schultz , I tried combining both subject areas and it is bringing data for me. We need to make sure that we select both Dim & Fact Entry from both SAs. Here is an example XML & corresponding data that I'm receiving. Please let me know in case you are facing a specific issue while combining both SAs. Payroll…