Auto Parameters
Some parameters are automatically filled by Reporting Hub. They are hidden from the user if they are found.
- Project Id
- GUID of the current project.
- Only on PDP pages.
- Example:
9186c1ad-2e73-4d78-8176-cc527a9ac447
- SSRS Parameter names: "projuid", "projid", "projectid", "projectuid"
- Current User Email
- SharePoint Mail of the user rendering the report.
- Example:
fabian.schmidt@sensei.cloud
- SSRS Parameter names: "currentuser", "currentuser_email", "currentuser_mail", "cu", "cu_email", "cu_mail"
- Current User Id
- SharePoint User id of the user rendering the report
- Example:
30
- SSRS Parameter names: "currentuser_id", "cu_id"
- Current User Login name
- SharePoint Login name of the user rendering the report.
- Example:
i:0#.f|membership|fschmidt@sensei.cloud
- SSRS Parameter names: "currentuser_loginname", "currentuser_login", "cu_loginname", "cu_login"
- Current User Title
- SharePoint Title of the user rendering the report.
- Example:
Fabian Schmidt
- SSRS Parameter names: "currentuser_title", "currentuser_name", "cu_title", "cu_name"
- Current User Id
- SharePoint User id (Name Id) of the user rendering the report.
- Example:
10033fff95968328
- SSRS Parameter names:"currentuser_userid", "cu_userid"
- Current User Id issuer
- SharePoint User id (Name Id) Issuer of the user rendering the report.
- Example:
urn:federation:microsoftonline
- SSRS Parameter names: "currentuser_useridissuer", "cu_useridissuer"
- Current Resource Id
- Project Online resource Guid.
- Example:
b037e043-2a9b-e611-80cd-00155de4d408
or Guid empty when not found (00000000-0000-0000-0000-000000000000
) - SSRS Parameter names:"currentresource_id", "cr_id"
Current User Project Permissions
- To which project does the current user have "Open Project" permissions. This is cached by Reporting Hub up to 15 minutes.
Can have two different formats based on the report settings.
If parameter is single value string.
- JSON array of project Uid.
- This is recommended for larger customers. As Multi Value with a lot of values have a known limitation (above 1000 values).
Example:
["00000000-0000-0000-0000-000000000001","00000000-0000-0000-0000-000000000002","00000000-0000-0000-0000-000000000003"]
SQL Usage:
SELECT MSP_EpmProject.ProjectUid FROM MSP_EpmProject JOIN OPENJSON(@currentuser_readpermission) WITH (ProjectUid uniqueidentifier N'$') AS perm ON perm.ProjectUid = MSP_EpmProject.ProjectUid
When the current user has no permissions the result is
[]
If parameter is "Multi Value" string.
- Array of project Uid
SQL Usage:
SELECT ProjectUid FROM MSP_EpmProject WHERE ProjectUid IN (@currentuser_readpermission)
When the current user has no permissions the result is
00000000-0000-0000-0000-000000000000
- SSRS Parameter names: "readpermission", "currentuser_readpermission"
See example Report for an SSRS report using all parameter.
Known issues
Problem: When using multi value parameter the drop-down menu does not extend over the parameter area.
Solutions: a) Configure the webpart to have a fixed height. b) Minimize and expand the parameter area. c) Use single value parameter.
Problem: WSS Data not removed from Deleted sites
This is due to a Microsoft bug that is not consistently firing events on SharePoint site deletion.
Additional limits to be aware of:
- Enterprise Project Types are not removed from the reporting Hub Database for data integrity reasons.
- Renaming of Lookup table entries are not propogated to projects until the project is next modified.
- Engagements are not synchronised in real-time due to the lack of Support from Microsoft. They are synchronised approximately every hour.
- Integration Hub is not available with SharePoint application authentication method.