Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi Cade, while exporting use the option excel instead of data, fyi Raghu
-
Hi @Hussain Ghuloum try this - https://community.oracle.com/customerconnect/discussion/718525/pending-in-progress-transaction-approval-records Raghu
-
Riti, easier using classic. Pivot view cannot be aggregated using non-numeric columns in dv. You can re-create using the attached analysis xml Raghu
-
Hi @Orange yes, you are right. Currently, the subject area renders only the workers and their goal plans that have at least one goal under them. Does not provide the Goal Plan Assignment details. The subject area can be enhanced to include the goal plan assignment details. I shall keep you posted. You could also post this…
-
Hi Tyler, you need to add the following data role to your line manager role Succession Supervisor Data Role Raghu
-
Hi @Mohit Kr Srivastava which subject area are you using for this? Raghu
-
Please post your question in the following forum - https://community.oracle.com/customerconnect/categories/hcm-taleo-enterprise
-
Please post this in the OTBI forum https://community.oracle.com/customerconnect/categories/hcm-reporting-and-analytics-for-hcm
-
Hi Claudia, i cannot think of any other reason why it can be blanked out for a few reports. Can you login as an administrator and explicitly select this check box if it is unchecked and see if you are able to get the schedule option? Also, if possible, you can run Reload Files and Metadata from the Administration page Raghu
-
Hi Claudia, can you check if the logged in user has access to schedule the report? 'Schedule Publisher Report' Raghu
-
Hi @JobDeLuna this requirement is possible with slight changes. You should use two date parameters to pass the two different dates instead of using a single column. I have worked out an example where the headcount is displayed for the two dates selected and also provides the delta between the two. Import the attached dv…
-
Hi @Job21 fyi. I have used the 'Time.Date' column. If you are using any other subject area to create this parameter ensure you have a filter on some metric in the query to fetch default value. Raghu
-
Hi @User_6H96B In the link that you have shared above, there is a section related to Employee Configuration. The Job category gets that data from there. Refer the following screenshot from the cloud application Raghu
-
Hi @Raesah Kachwala which subject area you using? Raghu
-
Hi @Mykol Sutton can you please archive and share your analysis here? Raghu Note: Please post your questions on OTBI in the following forum. - https://community.oracle.com/customerconnect/categories/hcm-reporting-and-analytics-for-hcm
-
Hi Richard, we do not have the benefits module as yet in FAW. It is in the roadmap of FY24. Raghu
-
Hi @Mykol Sutton which subject area are you using for this? You can actually use the headcount column and filter it by respective assignment status type along with the month column, it will give you end of the mpnth headcount value. for ex: Filter(Headcount USING Assignment Status Type IN (Active, LOA)) Raghu
-
Hi @Mykol Sutton is this in FAW or OTBI? Can you provide the name of the subject area and if possible, please archive and post the analysis here? Raghu
-
Hi @Raesah Kachwala These data reside in two different subject areas Create a report with person number, assignment number, assignment start date, assignment type. Have a filter criteria like below Count(Distinct Assignment Number BY person number) = 1 and Assignment Type = 'P' You can pass this person number obtained in…
-
Hi, you can use the below formula TIMESTAMPDIFF(SQL_TSI_DAY, <Task Assigned Date> ,CURRENT_DATE) Raghu