The Reporting User is an optional field and it has use cases attached to the Insight Power BI User IDs only.
When utilizing the Configurable Inquiry functionality, a User Mapping table needs to be populated with the Advantage User Name mapped with the Insight Application User Name, so that all the security related aspects of the Insight users are included while fetching the data from Insight.
Reporting user details can be populated from the Reporting User field on the User Information (SCUSER) page, which then populates the BI_USER_MAPPING table and the same would happen while a new user is being created.
Sites can populate the values on the User Information (SCUSER) page so that the BI_USER_MAPPING table is populated with the appropriate mappings.
Table Name: R_SC_USER_INFO
REPORTING_USER |
Advantage Insight User Id for the Advantage User. |
Table Name: BI_USER_MAPPING
USER_ID |
Advantage User Id. This is an optional field and only have use cases with Advantage Insight users. |
REPORTING_USER |
Advantage Insight User Id (that is, Power BI User Id). |