You can use any parameter for BI Publisher, but users will have to ensure they enter the value correctly, or the SQL statements in the data template will fail. Using supported parameters will allow you to provide a user interface to enter the values for parameters. Supported parameters for P6 fall into one of three categories:
- Enumeration parameters allow users to pick parameters from static lists.
- Dynamic parameters will generate the list at run time. For example, when focusing on Project ID, users will see a project list that pulls the current projects from the P6 EPPM database.
- Primitive parameters support basic selections. For example, if a parameter is a boolean, an option will appear for users to select or clear a text box instead of typing true or false.
The following are the supported parameters for P6, grouped by category:
Enumeration Parameters
- Activity Priority
- Assignment Proficiency
- Activity Status
- Activity Type
- Constraint Type
- Duration Type
- Percent Complete Type
- Project Status
- Rate Source
- Rate Type
- Resource Type
- Risk Status
- Risk Type
Dynamic Parameters
- Activity Code Value
- User Defined Activity Code (type and value)
- Cost Account
- EPS
- Expense Category
- Funding Source
- Portfolio
- Project
- Project Code Value
- User Defined Project Code (type and value)
- User Defined Resource Code
- Resource Code Value
- Resource Team
- Resource ID
- Responsible Manager
- Risk Category
- Role
- Role Team
- Timesheet Period
- User
Primitive Parameters
- Date
- Boolean
- Integer
- Float
Custom Parameters
- List of Values