BIRT (Business Intelligence and Reporting Tool) is an open source technology platform used to create data visualizations and reports that can be embedded into rich client and web applications. BIRT reports are made of objects and data sources that can be used in your report and can create different data sets.
Please note that BIRT Templates can be created by Customer, Partner or SAP Premium Reporting Team and not by Cloud Product Support (CPS).
This KBA is an additional reference to guide Customers and Partners through the steps to create a sample BIRT template and upload it to Ad Hoc.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental
SAP Success Factors Workforce Analytics (ANA) - All versions
Edit the report then export the Dataset from the Data Sets drop down list via Save As. Save the file to a location and take note of it as you will need this file to build your BIRT report.
Next step is to run BIRT tool. You can do this by clicking on the eclipse.exe file from your downloaded folder.
Create a new project and save it to desired location.
You can proceed to create your first report as follow:
Log into SuccessFactors and select Analytics from the main menu
- Select Reports sub-tab then Ad Hoc Reports
- You can create a new report or use an existing one from the report list
- For this example we use the Custom Employee Profile x BIRT Demo report
When BIRT opens your new report in the Eclipse workspace, Right Click on Data Sources then to New Data Source
Select the folder where you saved the csv file in.
The New Data Source is now created
You can then proceed to build and test your new data set by right clicking on Data Sets and select New Data Set
Select the desired columns by moving them across to the box on the right then check the Output columns you just selected.
When done, you can drag and Drop the Data Set to create a new table with the selected fields.
You can customise the report layout using the Editor. For example, by adjusting the headers font size, background colour etc.
At any time you can preview the report output by selecting the preview tab
To add a chart to the report you right click on the report design then select Insert and Chart from the list
Choose the chart type you want to use.
For the Data tab you can chose the desired fields for the Y and X series. In this example, you can select the username, for the Y series, and the aggregate expression count.
Drag and drop the location column to the x field.
You can customise the Chart area as you wish via the Format Chart tab
To view the report result select preview at any time.
Once you are happy with the BIRT report you can upload the newly created BIRT Template to the Ad Hoc Report as follow:
- Choose File->New->Report. The new report dialog appears.
- In the tree view, choose the project we just created: My Reports.
- Enter the desired file name: for example, Customers.rptdesign.
- Click Next.
- Select the location and file Name: Custom_Employee_Profile_x_BIRT_Demo.rptdesign
You can then see the report output by running the report online, export to excel or by generating it, when in edit mode.
- Edit the report you have downloaded the data set from
- From the People scope tab click on Data Sets then upload template
- Browse to the folder where you saved the rptdesign file
- Select open
- Save the report
BIRT template, Ad Hoc report, Data Sets, Eclipse , KBA , birt , data sets , premium , eclipse , birt template , LOD-SF-ANA-BIR , BIRT Reports , How To
SAP SuccessFactors HCM Suite all versions