OpenAir Enhancements

July 19, 2008

Overview

Projects
Specify loaded costs for Earned Value Management metrics calculations
Select which loaded costs to use in the calculation of EVM metrics including Primary, Secondary, Tertiary, or job code costs.

EVM metrics display at task level and are available values in project baselines
Earned Value Management metrics display at the task level, and metrics can be selected to baseline a project.

Create form permission rules for issue stages
Establish form permission rules and apply them to issue stages. Hide, make read-only, or require entry on edit form fields based on rule information and user role.

OpenAir Projects Connector: Pull OpenAir resource schedules into Microsoft Project and populate work hours at the assignment level
Pull OpenAir resource schedules into Microsoft Project. The accuracy of both company schedules and resource schedules is maintained when leveraging the OpenAir - Microsoft Project integration.

Duplicate multiple copies of a task
Make multiple copies of a task and place them within the same project.

Allow assignment group members to edit a locked project
Establish an assignment group for projects and allow group members to edit a locked project.

Send email to assignment groups and project/client owners
Designate assignment groups or a project/client owner to receive emails for billing or recognition results

Copy custom fields related to billing rules and recognition rules when copying tasks
Copy custom fields related to billing rules and recognition rules when copying tasks from one project to another.

Details ...

Resources
Maintain user skill profiles
Use the Bulk user change wizard to copy user skill profiles from one user to another.

Details ...

Account
Limit viewing of cost levels by role
Define roles that have permission to view different user cost levels.

Details ...

Timesheets
Filter timesheet report by project
Project approvers can now select a specific project on a timesheet report and see only the hours related to that project.

Details ...

Expenses
Transfer hidden, required, and text field length characteristics from Expense Receipt to Expense Grid
Hide a field, require input, and specify text field length on Expense Receipts and have it respected in the Expense Grid.

Details ...



Details

Projects
Specify loaded costs for Earned Value Management metrics calculations
When using EVM metrics to monitor a project's progress, specify which loaded cost best drives the calculation of a project's cost and performance. This may be a job code loaded cost or any one of the three levels of cost structure: Primary, Secondary, or Tertiary. For example, the job code loaded cost could provide more meaningful information than a user's primary loaded cost. Job code loaded costs can also be leveraged to restrict users from seeing cost of another user. The following guidelines apply:

  • If one of the three levels of cost structure is used, any project and task cost overrides are respected regardless of the loaded cost selection.
  • If the user's job code loaded cost is used, there are no overrides.
The "EVM metrics user costs are from" option selected is used for all EVM metrics.

To enable the selection of loaded costs for EVM metrics, users with required role privileges navigate to Account > Company > Settings. Scroll to "Projects Options" and select the loaded cost option for "EVM metrics user costs are from." Selections include "Primary loaded cost," "Secondary loaded cost," "Tertiary loaded cost," or "Job code."

Note: To enable three levels of cost structure, please contact OpenAir support.

EVM metrics display at task level and are available in project baselines
The following earned value management (EVM) metrics can be displayed at the task level:
  • Planned Value (PV) = Planned hours multiplied by the user's cost
  • Earned Value (EV) = Earned Value % complete multiplied by the project's total Planned Value
  • Actual Cost (AC) = Hours worked multiplied by the user's cost
  • Cost Variance (CV) = Earned Value (EV) minus Actual Cost (AC)
  • Schedule Variance (SV) = Earned Value (EV) minus Planned Value (PV)
  • Budget Variance (BV) = Planned Value (PV) minus Actual Cost (AC)
  • Cost Performance Index (CPI) = Earned Value (EV) divided by Actual Cost (AC)
  • Schedule Performance Index (SPI) = Earned Value (EV) divided by Planned Value (PV)
To enable the display of some or all of the metrics, users with required role privileges navigate to Projects > Projects and select a project. Click on "Outline view" and click on the "customize" link. The "List layout" window displays. Select the metrics to display from the Available Items and click "Add selected items." Click OK.

To use EVM metrics in creating a project baseline, users with required role privileges navigate to Projects > Projects and select a project. Click on "Baseline" and click on the "customize" link. The "List layout" window displays. Select the metrics to display from the Available Items and click "Add selected items." Click OK. To create a baseline, click Create > Baseline. The metrics display under "Project changes" in the baseline comparison report.

Create form permission rules for issue stages
The "Edit the issue" form can be modified to hide, make read-only, or require entry on edit form fields based on information set up in permission rules. Use the "Modify the form permissions" link to access the new "Permission rules" pop-up window. Specify fields that display on the "Edit the issue" form based on issue stage, define conditions for hide, read-only, or required, and designate user roles to which they apply. For example, for an issue that is in the issue stage "Resolved", a rule can be set up such that the "Issue severity" field may be designated as hidden when the user role is equal to "Project manager".

To enable form permission rules for issue stages, please send an email request to support@openair.com.

How to set up form permission rules for issue stages:
  1. Users with required role privileges navigate to Projects > Projects and select a project.
  2. Click on "Issues" and select an issue. The "Edit the issue" form displays.
  3. Click the link to "Modify the form permissions."
  4. Scroll down to "Permission rules" and click "Create." "Create a new rule" window displays.
  5. Type the Rule name. For example, type Issue Stage Resolved.
  6. Select the Available field and click "Add selected items." For example, select Issue stage.
  7. Select the option that defines conditions and indicate "Any of the following" or "All of the following." For example, select All of the following.
  8. Select the field to be defined as well as related attributes. For example, select "Issue stage" and "equal to" and "Resolved."
  9. Click [add rows] and select the number of rows to add.
  10. Select additional fields and define them. Multiple fields can be used in one rule. "User role" is a field and it is defined as "equal to" or "not equal to" a role such as "User" or "Admin."
  11. Select the action the rule will perform on the specified fields: Hide, Read-Only, or Required.
  12. Click Save to exit "Create a new rule" and Save again to exit "Modify the form permissions." When the defined conditions are met, the actions are performed on the specified fields for designated user roles and the "Edit the issue" form changes to reflect the application of the rule.

OpenAir Projects Connector: Pull OpenAir resource schedules into Microsoft Project and populate work hours at the assignment level
Pull OpenAir company schedules and resource schedules into Microsoft Project. Pulling OpenAir schedules eliminates the need to manually create calendars in both applications. Accuracy between the two software products is maintained and mismatches caused by exceptions are eliminated. " Also, when you pull an OpenAir project, if assignment level planned hours is enabled in OpenAir, the hours are set as work hours in Microsoft Project.

Navigate to Account > Exchange > OpenAir Projects Connector. Download version 2.24 and install it. Open Microsoft Project, click on the OpenAir toolbar, select "Account Settings" and log in. Click the OpenAir toolbar and select either "Pull OpenAir resources" or "Pull from OpenAir." When prompted to export OpenAir schedule information, click Yes.

Duplicate multiple copies of a task
When the same task is performed at different intervals throughout a project, it can now be duplicated and used as many times as needed in the same project. All task information is copied. Edit the duplicate copies and move them to different phases.

Users with required role privileges navigate to Projects > Projects and select a project. Click on the "Outline view" or "Edit tasks/phases" and select a task. The "Edit task" form displays. Scroll down and locate "Copy or move this task to another project or duplicate it within this project" and click "duplicate." A Duplicate task "task name" window displays with the name of the task in the "New task name" text box. Type the number of duplicates to create and click Save. Click on each of the duplicated tasks and edit as necessary.

To enable the ability to duplicate multiple tasks at once, please send an email request to support@openair.com.

Allow assignment group members to edit a locked project
Establish an assignment group and then enable project editing for group members. This feature provides increased project management flexibility and control for your company.

To create an assignment group, users with required role privileges navigate to Account > Account and select "Assignment groups" under Projects. Click Create > Assignment group. The New assignment group form displays. Type the group Name and select the users that make up the group, click "Add selected items" and click Save. Navigate to Projects > Projects and select a project. Click Edit project. Under the Project Status section, select the option for "Allow only the project owner or administrator or the selected users to edit the project" and click "Create." The "Users allowed to edit the project" form displays. Select the Assignment group and click "Add selected items." Click OK. Group members are now allowed to edit the project.

To enable the ability to specify users for editing a locked project, please send an email request to support@openair.com.

Send email to assignment groups and project/client owners
When configuring project auto-run settings for billing and recognition, select the option to email results to members of an assignment group or the project owner for all new projects or on a project-by-project basis. This new option allows flexibility in designating who receives billing/recognition results on which projects and when. If the OpenAir metavalue [Project owner] or [Client owner] is chosen, the user specified as "Project owner" or "Client owner" receives the billing/recognition results.

How to send email results for new projects to assignment groups and the project owner:
  1. Users with required role privileges navigate to Projects > Options and select "Project billing options" or "Recognition options." The option form displays.
  2. Click "Create" located next to "Users to email." The "Users to email" form displays.
  3. Select the metavalue [Project owner] and/or scroll down and select one or more [Assignment group]. Click "Add selected items" and click OK. The options form refreshes and the term Create changes to Edit.
How to send email results for existing projects to assignment groups and the project owner:
  1. Users with required role privileges navigate to Projects > Projects and select a project.
  2. Click on Billing or Recognition. The rules list displays.
  3. Click on Auto-bill or Auto-run for billing and recognition respectively. The Auto-bill or Auto-run form displays.
  4. Click "Create" located next to "Users to email." The "Users to email" form displays.
  5. Select the metavalue [Project owner] and/or scroll down and select one or more [Assignment group]. Click "Add selected items" and click OK. The Auto-bill or Auto-run form refreshes and the term Create changes to Edit.
How to establish an assignment group:
To establish an assignment group, users with required role privileges navigate to Account > Account and select "Assignment groups" under Projects. Click Create > Assignment group. The New assignment group form displays. Type the group Name, select the users that make up the group, click "Add selected items" and click Save.

Copy custom fields related to billing rules and recognition rules when copying tasks
Copy tasks from one project to another project and select the option to "Copy associated billing rules and recognition rules." When billing and recognition rules are associated with a task, this feature also duplicates the billing/recognition rule custom fields and related values.

Users with required role privileges navigate to Projects > Projects and select a project. Click on "Edit tasks/phases" or "Outline view" and select a task. Scroll down and locate "Copy or move this task to another project or duplicate it within this project" and click "copy." A Copy task "task name" window displays with the name of the Current project and a drop-down list of projects. Select the new project and the check box for "Copy associated billing rules and recognition rules." Click Save. The associated billing rules and recognition rules as well as any custom fields and values are copied to the new project.

Note: To allow associated billing rules and recognition rules as well as custom fields and values to be copied when a task is copied, please send an email request to support@openair.com.
Up
Resources
Maintain user skill profiles
Maintain user skill profiles quickly and easily. Copy the skill profile of one user to another user or multiple users. Specify whether to add unique profiles or overwrite selected users' profiles. In addition, allow for the duplication of attribute values or comments as appropriate. The bulk user change wizard allows you to efficiently make changes or additions to many user skill profiles at one time.

How to copy profiles from one user to another user:
  1. Set up a profile in a user account to use for duplication. Navigate to Resources > Resources and select a user. If you are copying user skill profiles to a new user, set up the user first. To set up a new user, go to Account > Account and click on "Users." Click Create > User.
  2. Navigate to Dashboard > Overview > Wizards and select "Bulk user change wizard." The form for Step 1 displays.
  3. Select the "User to copy from" using the drop-down list or search function.
  4. From the "Available Information" list, click on "Profile" and click "Add selected items."
  5. Select the "Copy to" option for "Users."
  6. Click Next.
  7. Select the "User to copy to" from the list of "Available user." CNTRL click to make multiple selections. Click "Add selected items" or "Add all items."
  8. Select the "Profile Duplication Method." Options provide for adding unique profiles to a user or overwriting user profiles.
  9. Select "Profile Attributes." Options for the ability to duplicate attribute vales and comments.
  10. Click "Run." When the profiles have been copied to the specified users, the Dashboard displays with a message indicating the update is complete and listing the users who were updated.
Up
Account
Limit viewing of cost levels by role
While OpenAir allows up to three levels of cost information to be established for users, it isn't always appropriate for this information to be widely available for viewing. Please contact OpenAir support and request three levels of cost such as primary, secondary, and tertiary. Once enabled, this terminology can be tailored in Account > Company > Terminology to something such as salary, salary and bonus, and fully loaded costs. This feature allows for the defining of roles that can view the cost structure information for users.

To limit viewing of cost levels by role, users with required role privileges navigate to Account > Account and select "Roles" under Account data. Click on a role. Under the General Settings section, select the option for one or all of the following: "View all user costs," "View primary loaded cost," "View secondary loaded cost," and "View tertiary loaded cost." Click Save.

To hide costs on edit forms based on a role, use "Modify form permissions." For example, navigate to Account > Account > User and select a user. Click the "Cost" link and scroll down to hints and click "Modify form permissions." Scroll down to "Hidden divider sections" and select the check boxes of the loaded costs you would like hidden for the roles you specify. Select one or all of the loaded cost levels: primary, secondary, and tertiary.
Up
Timesheets
Filter timesheet report by project
Project approvers who have the ability to view multiple projects on one timesheet report can now use the "Project filter" to view hours for a specific project. The timesheet report refreshes and displays only the hours for the project selected. This provides a quick way to ascertain the number of hours on a timesheet applied against a specific project.

How to configure project level approvals for Project filter on Timesheet reports:
  1. Users with required role privileges navigate to Projects > Projects and select a project.
  2. Click "Edit project."
  3. Scroll to the "Project approvers" section and select the role or user who approves timesheets for the project.
  4. Click Save.
  5. Users with required role privileges navigate to Timesheets > Timesheets and select a timesheet.
  6. Click on "Timesheet Report."
  7. To see only the hours related to a specific project, use the "Project filter:" drop-down list and select the project. The Timesheet Report is refreshed and displays only the hours for the project selected.
Note: To enable project filtering on timesheet reports, please send an email request to support@openair.com.
Up
Expenses
Transfer hidden, required, and text field length characteristics from Expense Receipt to Expense Grid
Use the "Modify the form permissions" feature to identify fields in the Expense Receipt form as read-only, hidden, required, or to specify text field length. Previously, only read-only specifications were respected in the Expense Grid. With this enhancement, hidden and required fields as well as the length of text fields also transfer from the Expense Receipt to the Expense Grid. To enable the ability to specify text field length in "Modify the form permissions," please send an email request to support@openair.com.
Up
Would you like to see previous OpenAir updates?
View previous OpenAir updates ...

Suggestions, problems, or questions?
Contact us at support@openair.com or 888.367.1288 (outside the U.S. and Canada, call 617-351-0226). We take pride in the outstanding care we give our customers. Please let us know how can we improve your experience with OpenAir.