Microsoft EPM Project & SharePoint Workspace Automated Archive & Recovery Solution (ARS)– April Bonanza!!

Author: David Smith (Project Solution Ltd - Business Development Manager )

- Are you struggling with the numerous manual steps for archiving completed projects and associated SharePoint Workspaces?
- If you are using categories to hide/deny projects? what about access to important project artefacts?
- Wasting too much time and effort when you could be focusing on other key areas of your business?
- Are you experiencing system performance issues as result of amount of data/structure of data? Is this affecting adoption of EPM/SharePoint?

Want EPM Project Archive & Recovery processes to be completely automated? Want a simple solution that aligns with your Work/Project Management business processes? Payback within approximately 1year?

Microsoft EPM ARS 2007/2010 is one of the Business productivity add-on solutions/tools for Microsoft EPM/SharePoint which completely automates the entire process for Archiving and Recovery. simple and ease to use.
- Make the most of your existing investments in Microsoft EPM/SharePoint.
- Helps improve adoption of the overall Microsoft EPM/SharePoint Solution.
- Manage complete project life cycle including archiving completed projects.
- End-user self-service capability for archiving & recovery without losing access to associated project workspaces/artefacts.
- Improve system performance by keeping live data streamlined.

Check out the demonstration video below and find out more!!

Microsoft EPM Project & SharePoint Workspace Automated Archive & Recovery Solution (ARS)

April 2011 is going to an exciting month for all of us here in UK. We have the Easter break and the Royal Wedding on 29th April to look forward to. The whole nation will be celebrating. We at Project Solution will be participating by offering a massive 25% discount and FREE lifetime technical support and maintenance (including upgrades for 2010) for all our Business productivity add-on solutions/tools, on all orders during the month of April 2011, including ARS.  Offer valid until mid night 30th April. Contact us today on +44 (0) 1223 597 940 or [email protected]  quoting eCode ‘April2011’.

Where have my changes gone? Creating local project views

Have you every inserted a column/field in ‘Gantt Chart’ view within Project professional only to find that this no longer exists next time you re-open your project from project server? If you spent a couple of hours configuring a project view and this happened, then you may not be pleased! Perhaps you may vent your frustration and anger on your computer……

The reason this happens is because Enterprise Views such as ‘Gantt Chart’ can only be modified by the administrators who have access rights to modify Enterprise Global.

If you want to keep local project configuration changes i.e. for views, tables filter and groups, you must ensure that these local project entities are named differently to Enterprise entities. For example create a copy of the Enterprise Table ‘Entry’ and rename to ‘Contoso_Entry’ before modifying.

How do I create a local project view?

It is important to remember that a View comprises of;

1. Table

2. Group

3. Filter

(click picture to enlarge)

Some users do not appreciate this and simply create a custom view not understanding that the associated Table is still an Enterprise Table.

Recommended steps to create local project views

Here are recommended steps for creating a new local view from scratch. In the example below, we will create a custom view for scheduling timephased costs for cost type resource ‘Consultancy’.

Step (1): Make a copy of an existing Enterprise Table for example Usage.

- Navigate to View > Task Usage View

- Select ‘More Tables’ from View > Table menu

- Select ‘Usage’ and Click ‘Copy’

- Name the new Table appropriately.

- Tick show in menu

- Within Field Name you can insert new fields or remove existing fields. Note: I prefer to do this after the table is created and associated with the new view. See step (5) below.

- Click ‘Ok’

Step (2): Make a copy of an existing Enterprise view for example Task Usage.

- Navigate to View > Task Usage View

- Select More Views from View menu

- Select Task Usage and Click Copy

- Name the new View appropriately.

- Associate the new table created in step (1) above.

- Leave default Group ‘No Group’. See note below.

- Select a built-in filter for example ‘Incomplete Tasks’. See note below.

- Tick show in menu

- Click ‘Ok’

Note: just as you can create a custom table, you can create a custom filter or group. I will post some additional info regarding this later.

Now we are ready to make some finishing touches.

Step (4): Select newly created view from the View menu.

Step (5): Modify newly created view and associated table

- Right click on field/column ‘Work’ and click ‘Insert Column’.

- Within the ‘Column Definition’ dialog box select field name ‘Cost’

- Align Title and Data as required.

- Click ‘Ok’

- Next, we need to add timephased assignment field ‘Cost’. This is done by right clicking on the right-hand side of the splitter bar and then selecting ‘Cost’

That’s it!! We can now start adding timephased costs for Cost Type Resource e.g. ‘Consultancy’ in our newly created local custom view.
 

Save and Check-in your Enterprise project.

Considerations

It is important to remember that a custom local project configuration will remain with the Enterprise project. This will not be available to other users or your other projects unless you choose to copy this configuration from project to project.

 

If there is a requirement to share the best practice configuration then the options are;

1. Migrate/configure the required view in Enterprise Global. Note: If you do not have appropriate access right, then pass on your local project file copy to your administrator to migrate the configuration to the Enterprise so that others can benefit.

 

2. If the above option is not feasible simply because there will be very many Enterprise views and/or different nature of works undertaken by various divisions, then the alternative is to migrate or create the local view within divisional Enterprise Project Template(s). This way, only the projects created from the divisional template will inherit the division specific project pro views.

Resource Types - Codes

For developers creating queries and SQL reports, this might be useful to know;

‘Res_TYPE’ field values in Published DB

1 - User NOT resource

2 - WORK Enterprise Resources

20 - Generic WORK Enterprise Resource

21 - MATERIAL Enterprise Resource

26 - COST Enterprise Resource

51 - BUDGET COST Enterprise Resource

101 - Inactive User (not resource)