Aaron, You can do a cross subject area report using work relationship real time and assignment event real time. The 'HR Action' and 'HR Action reason' folders in assignment event real time will have the attributes that you have mentioned. I have done a sample using assignment event real time only. Thanks Raghu

Please refer the attached word doc.

Shashi, I assume, you want to join multiple subject areas with a custom defined join between them if yes, then i agree, this will be a good enhancement Thanks Raghu

Ashish, from what i could understand, you need report prompt on 'Department' that filters based on the already selected value based on 'Business Unit' prompt This can be done using the 'Prompts' tab in the analyses itself let me know if you meant anything else? for now, i would mark it as already existing Thanks Raghu

Hi Craig, yes, this is in-line with what we were planning to incorporate. Thanks Raghu

Hi @Lea B yes, we will add this measure, any other key metrics that you want to add? you can suggest something that is not available in OTBI also Raghu

Hi @Craig Stevens * If a requisition has been in suspended state multiple time during its lifecycle until it reaches the filled state, you want to have the cumulative suspended duration? I think the answer is yes, but wanted to confirm * Do you plan to use this(requisition suspended duration) in conjunction with the…

@Vivek_Gautam09052022 Vivek, can you please provide some additional details on this? * Can you please post a screenshot of this column from the application? * Is this available in any of the OTBI subject areas currently? * If possible, how do you plan to use this in the report? Raghu

Hi Priyanka, have you tried leveraging the subject area HCM - Workforce Gains and Losses? In this you could track the people movement by Job, Manager, Grade, Location, Business Unit, Position etc. This you can analyze by HR Action and Reasons too. Raghu

Robert, this is a possibility even now. You could combine the two subject areas mentioned above. I hereby attach a sample, fyi. - Raghu

Hi @JoanaFalcao , did you mean, if there is a way to export the data from an OTBI analysis to a spreadsheet without running the analysis? In the catalog, just below the report, you find the 'more' button . You click on that to find an 'export' option, which on clicked will export the analysis output to the file Raghu

Ravi, excellent, this is a must bookmark, thank you - Raghu

Kalyan, This is not yet available for reporting. The relevant information is stored in the BPM tables, not in the HCM application. This is part of our roadmap but no ETA yet. - Raghu

Agnel, you should employ 'Expression Filter' to add your condition and limit the respective prompt by the expression filter. I have illustrated the steps in the attached document, please check. My requirement is as below 1. Get me all managers in the prompt that have the SOC >= 15 For this, 1. I create an expression filter…

Naeem, you could do this using data sets. * Create a data set with required columns from the FAW subject area and create a project of it. * Add the second data set which could be from a different subject area or a spreadsheet * Add the join between the two columns in the Data tab * In the Visualize tab, modify the data…