Table of Contents

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:

  1. Configure the webpart to have a fixed height.
  2. Minimize and expand the parameter area.
  3. 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.
Edit this page