When you edit a Credential Profile, you will see a ‘requisite attributes’ list that lets you filter the available profiles according to the actual values of user attributes. By default, a small set of attributes are listed. To add more though, you need to use the Project Designer tool, open your project file, find the attribute that you want to include and set the ‘In Profile’ check box.
Then save the attribute and project file and generate the SQL scripts as normal.