To force FluentPro Formulas to use specific user account to read data from project server you need to configure the Secure Store Target Application to use proper credentials to access to the Project Server data. Please note you need to have permissions to do so.
To create a Target Application:
- Go to Central Administration → Application Management → Manage Service Applications - > Secure Store Service
- Click New button on the ribbon
- Type FluentPro.Formulas into the 'Target Application ID' field
- Type FluentPro Formulas into the 'Display Name' field
- Type a contact e-mail
- Select “Group” from the “Target Application Type” drop down list and click Next
- Leave all fields unchanged and click Next
- Type a Farm administrator account into the “Target Application Administrators” field
- Type the account name that runs “Microsoft Project Server Events Service” Windows service into “Members” field
- Click OK
- Select FluentPro.Formulas from the list and click “Set Credentials” from the drop down list
- Type a user name and password of a user who has PWA administrator rights to “Windows User Name” and “Windows Password” fields and click OK