01 May 2017
Poorly Named Data Elements in Your P6 Global Dictionary Causing Confusion?
A Project Code Called EPS!
Project codes in the global dictionary are an important part of an organization's enterprise data in P6. Needless to say, keeping this dictionary (as well as other global data dictionaries) clean and well-organized is an essential task for the application administrator, as well as for other admin superusers. Incorrectly named project codes and project code values result in confusion and translates into unproductive time for the users, which ultimately results in losses for the company.
Last week I was working on preparing a Primavera P6 web basic training course for one of our clients. I was creating projects for the practice sessions using the customer's staging environment (an exact copy of the production database).
All of a sudden, when grouping by the EPS structure on the EPS page in the Projects section, I was getting the following error on my screen: EPS 407, No EPS!
It took me a while to realize (not without assistance from my colleague) that there was a project code in the database called EPS - in the project codes dictionary:
What happened was that instead of the EPS structure data element being used for grouping, the selection switched to the EPS Project Code and, as a result, the grouping bands displayed on the screen did not make any sense.
The EPS structure is often used as a grouping criterion for enterprise-wide reports, global layouts and views in the client and web applications. Can you imagine the effect this mistake could have on reports distributed to a large group of internal and external project stakeholders?
In my five-years of experience working at Emerald I have seen (unfortunately) numerous examples of poorly managed global data dictionaries in P6. The example described above may not have been very obvious to catch but at least it was quick and easy to fix.
If i can share one key takeaway it is this - security settings should never allow regular users to have write access to global data dictionaries. In the case that regular users do have the security privilege to Add/Edit/Delete Project Codes, they should thoroughly think before adding new or editing/deleting an existing data element(s) in the dictionary.