Length Of Service /Age Story Reports
Story Reports are being the frequent word hearing from the SAP SuccessFactors HXM Suite.
The Story type of report in Report Centre is part of the People Analytics solution, and it’s based on the integration of SAP SuccessFactors HXM Suite with SAP Analytics Cloud. After you create a story, you can add and edit pages, sections, and elements. You can share your story with others to enable them to use the report you’ve created. It is a presentation-style report that uses charts, visualizations, text, images, and pictograms to describe data. A story mainly involves building a query, and using the query to create the report.
This blog is going to take you through the complete story report creation.
Requirement: Story Report on Employee Length of Service & Age should be created
1.Navigate to Report Centre and Select New
2.Choose Story from the available options and click on select.
3.Select a connection here. There are 2 types of connection
- SAP SuccessFactors Learning
- SAP SuccessFactors Reporting
Choose SAP SuccessFactors LMS for LMS related reports and SAP SuccessFactors Reporting for all the other modules data.
4.Now a Query Designer page will be loaded as below.
5.Choose the entities as per the requirement.
- As we have to calculate age of employee, drag and drop Personal Information —->Biographical Information entity from Available data
2.As we have to calculate Length of Service for employee, drag and drop Employment —>Job Information entity from Available data.
6.Select the fields which has to be shown on the story report by click on the Add Columns
As per the above select columns option in Biographical Information and select Date of Birth & Person ID. In similar way select columns in Job Information Date of Joining /Start Date.
7.Select Preview Query to see the selected columns for the story report.
System will request for the variables like As of Date for which data has to be reported.
Preview Query looks as below.
Now create a calculated column for Length of service and Age.
Select Calculated Column and Provide an ID and description. Now enter the condition as below for Length of Service.
ISNULL ([Employment#Job Information#Last Working Date]),
(DAYS_BETWEEN ([Employment#Job Information#Joining Date],CURRENTDATE())/365) ,
(DAYS_BETWEEN ([Employment#Job Information#Joining Date],[Employment#Job Information#Last Working Date])/365) )
Again, Select Calculated Column and Provide an ID and description. Now enter the condition as below for Age.
DAYS_BETWEEN([Person#Biographical Information#Date of Birth],CURRENTDATE())/365
Now Click OK and Finish.
Give a name to the Data Source and set the As of Date as per your requirement to report the data.
Now Select which object you wanted to report the story on.
As per the requirement here we are choosing Table. And we have to add the columns on to the design.
Selected columns will appear on the story report as per the calculation.
Now Click on SAVE. Story Report Successfully created.
Current Limitations for Stories in People Analytics
- The schemas for Recruiting Marketing, Recruiting Posting, and Onboarding 1.0 aren’t supported. However, the schema for Onboarding, which replaces Onboarding 1.0, is supported.
- Currently, the Recruiting schema for Stories in People Analytics doesn’t support the Status Audit Trail table for Application Status.
- The option to configure timestamps in the time zone of the user running a Story isn’t available.
- The JDM (Job Description Manager) schema isn’t available.
- Objects (other than Employee Central and Benefits) that include custom fields configured as generic objects or foundation objects (type of reference object under DataType) aren’t currently supported. Employee Central and Benefits objects support custom fields configured as generic objects or foundation objects.
- Quickcard isn’t supported in story content. You can use the hyperlink functionality as an alternative approach.
- Transient data (for example, fields calculated in real time in the UI such as salary or compa ratio) isn’t supported.
- Exporting to Microsoft Word format isn’t supported for Story reports.
- The languages Arabic, Hebrew, and Vietnamese are currently not supported.
- Action Search shortcuts don’t apply for Story reports.
- Scheduling SAP SuccessFactors Learning stories isn’t supported.
- SAP SuccessFactors Learning isn’t integrated with other modules of SAP SuccessFactors.
- Due to low usage, support for the Intelligent Services schema in Story reports hasn’t been planned.
- Data from Stories isn’t available for use in the Insights panel.
- Story reports that you create using Performance Management, Goal Management, 360 Reviews, Career Development Planning, Compensation, or Recruiting based schemas might not work properly when transferred from one environment to another (using the Import and Export functionality).
- Stories in People Analytics doesn’t support the use of Proxy URL to access the SAP SuccessFactors tenant. This means, you won’t be able to use Story reports, if you use a Proxy URL to access the SAP SuccessFactors tenant.
- Boolean cannot be used a filter on the Story designer page.