SAP UI – how to create custom UI for Reports
SAP IDM UI – how to create custom UI for Reports:
In order to create a needed functionality for a customer, I had to do additional development for IDM UI.
The case was:
- · I had to create a custom UI for Reporting
- · The generated reports are : User’s data, Privileges attached to the users, Roles attached to the uses and report for the created requests
- · Export Person Data:
- Ø Export Person is used to choose from a list with users
- Ø File name is used to set the name of the file for export
- Ø Check for export is used to specify the files for export
- · Export Privileges Data and Export Role Data are on the same principle as Export Person Data
- · Export Request is more complex, because of ValidFrom and ValidTo added to set a range for the report:
- What I did to create the UI above was:
- I added a new entry(CCH_EXPORT_UI_DATA) to hold the information for this UI:
- Because this is an Entry type that create a new entry, I have to add a mandatory
attribute to hold a MSKEY of the user executed the Report
- Ø Only after the comment is added the user can successfully make a Report.
- I added a couple of tasks to react on the check box(Check for export).
- Ø If a check box is selected I have a script to check and execute a next task on TRUE, if not – nothing happens
- I used a task to set the file name and the trigger that exports the files
- To make possible for users to search for a Person, I added in the attribute (in Attribute Values) a SQL query
- ØIf you want to have a report for all user, you just execute the report with(“_%” in the field – Export Person) and the
generated files will have an information for all users. - The tricky part was how to export the correct data. So I added a flag to check, if
the export is executed or not . If (yes) I deleted the flag and for this report won’t be generated more than one file. - For the file name I have made a script, to check if we have a file name, if not I generate one.
- I have a problem also with a select made for exporting Requests, after I added
ValidFrom and ValidTo attributes. At first, when I tried to set a date and
export it, the exported data wasn’t correct until I made the attributes Data type – Datetime
- Finally in the Job folder I execute the jobs that are exporting the files:
- Ø As you can see here, Check for export is selected, only this way you can generate a
report for the needed information.
Overview: A custom IdM UI implementation that allows you to easily export users, roles, privileges data to Excel. This includes a full export of user’s data (attributes from MX_PERSON entry type). Additionally roles and privileges can be exported with the respective assigned users to them
Hope you like it 🙂
Simona Lincheva
Very useful article! Thank you, Simona.
Hi Simona
thanks for this article. I am also trying to generate the reports, receiving some issues in the UI screen. Can you kindly help me with the below queries in designing the UI screen
1 . I have a requirement to create three kinds of reports. how to get three tabs differently.
2 . I have a drop down field, when selected an value from that drop down, is there any possibility to display the below data according to selection.
for example, i have selected option as A in the drop down then the radio button needs to be visible, if i select check option as B then check box and text box should be visible.
Regards,
DP
Hi DP,
If you are using the standard IdM UI, you won't have the option to dynamically generate the UI's properties. As for the separate tabs, you will need for the different reports, this is just a setting in the UI task.
But if you have the option to use SAPUI5(depending on the IdM version you have), the dynamic generation won't be a problem and the UIs/reports will have additional functionalities.
BR,
Simona
For 2), maybe this is an option. Does not fulfill 100% your use case, but maybe it is still useable: IdM Thoughtplace: Linking pulldown attributes in NW IDM 7.1
Thanks Matt Pollicove