If you want to ...

Perform these steps ...

Identify which profile values are available in your SAI360 database.

To find out which Profile values CAN be included in a report,

• navigate to Main Menu Admin Profiles
• note down the Profile Names, for example:
  - Department
  - Area
  - Person
• Any of these profile values can be referenced in a report as an "Environmental Variable".
• The syntax is:
  =ENV("session:Profile_<NameOfProfile>")
• Example:
  =ENV("session:Profile_Person")
  

Add a profile value to a report.

To include a profile value in a report, edit the report in the Report Designer and

• Add a "Text Field"
• To add the expression, select Attributes common value.
• Click on the '+' sign next to value.

Edit the Expressions

Create the expression as follows:

• Make sure that the field "Selected Expression" = Open Formula (Common)
• Paste the following string into the edit window:
  
  =ENV("session:Profile_<NameOfProfile>")
  
• Update the placeholders for NameOfProfile with the name of the profile you intend to use, for example
  
  =ENV("session:Profile_Person")
  
• Click OK

Make the report available in SAI360.

Since a SAI360 system variable is used, you cannot test the hyperlink directly in the Report Designer. You will need to publish this report first, and then test it in the SAI360 Web Application.

Test the report.

Run the report in the SAI360 Web Application.

The configuration is correct when the report shows the value of the profile.