{"id":1554,"date":"2020-01-14T17:27:31","date_gmt":"2020-01-14T22:27:31","guid":{"rendered":"http:\/\/www.foxquestsystems.net\/foxblog\/?p=1554"},"modified":"2024-12-07T15:00:29","modified_gmt":"2024-12-07T20:00:29","slug":"the-enterprise-reports-module","status":"publish","type":"post","link":"https:\/\/www.foxquestsystems.net\/foxblog\/2020\/01\/14\/the-enterprise-reports-module\/","title":{"rendered":"The Enterprise Reports Module"},"content":{"rendered":"\n

The Enterprise Reports Module\ncontains a collection of reports that analyze, monitor and report system wide\nand Global related issues within your P6 environment. <\/p>\n\n\n\n

In this module, there are multiple reports covering different Enterprise Level issues. This article provides a brief overview of each topic and report so that you can understand how each item individually helps to maintain a \u201cclean, lean & mean\u201d Enterprise Level environment. This module will also help those that need to keep the overall database environment under a certain file size limit.<\/p>\n\n\n\n

Whether you\u2019re a Z\u00fcmmer user or not, this article is a must read to understand some of the necessary maintenance techniques and issues that must be implemented in order to keep a healthy Enterprise Level system in P6.<\/p>\n\n\n\n

In Z\u00fcmmer, the Enterprise Reports Module is accessed by clicking on the Enterprise Module toolbar button as shown below:<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

The Enterprise Reports Module\ncontains a collection of reports that analyze, monitor and report system wide\nand Global related issues within your P6 environment. <\/p>\n\n\n\n

In this module, there are 14\ndifferent reports covering 12 different Enterprise Level issues. This article\nprovides a brief overview of each topic and report so that you can understand\nhow each item individually helps to maintain a \u201cclean, lean & mean\u201d\nEnterprise Level environment. This module will also help those that need to\nkeep the overall database environment under a certain file size limit.<\/p>\n\n\n\n

Whether you\u2019re a Z\u00fcmmer user or\nnot, this article is a must read to understand some of the necessary\nmaintenance techniques and issues that must be implemented in order to keep a\nhealthy Enterprise Level system in P6.
\n<\/strong><\/p>\n\n\n\n

    \n
  1. Global Activity Code Usage<\/strong><\/li>\n<\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    The Global Activity Code Usage by Code and Usage by Project reports ensure that Global Activity Codes are not propagating or inheriting down to the Project level. Most construction specifications categorically state that Global Activity Codes are not included as part of any Project CPM submittals.
    <\/strong><\/p>\n\n\n\n

    2. Global Calendar Usage<\/strong><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    The Global Calendar Usage by Calendar and Usage by Project reports ensure that Global Calendars are not propagating or inheriting down to the Project level. Most construction specifications categorically state that Global Calendars are not included as part of any Project CPM submittals.<\/p>\n\n\n\n


    <\/strong>3. Orphaned Baseline Projects<\/strong><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    When a Project is assigned or Maintained as a Baseline\nProject, and later, the Original Project is deleted, the P6 database does not\nalways trigger the deletion of the associated Maintained\/Assigned Projects. These\nProjects become orphaned and are not easily detectable and cannot easily be\ndeleted. The Orphaned Baseline Projects reports those Projects that are not\nassigned to any Project viewable in the EPS module. <\/p>\n\n\n\n

    To delete Orphaned Baseline Project, follow the procedures detailed in P6 Oracle Doc ID 2216405.1 – “How to Delete Baseline in PROJECT Table When the Original Project Has Been Deleted.”<\/p>\n\n\n\n


    <\/strong>4. POBS Record Count<\/strong><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    The POBS Record Count report\nchecks for an anomaly within the P6 database systems where the POBS table is\npopulated with possibly thousands of unusable or useless records. <\/p>\n\n\n\n

    This anomaly appears to have be resolved in recent P6 releases. However, it is possible to inadvertently import an .XER containing thousands of useless POBS records. It\u2019s important to resolve this issue within your P6 database. Especially if you submit .XER to outside entities. The POBS Record count anomaly acts like a virus possibly depositing itself into other unsuspecting P6 Users.<\/p>\n\n\n\n


    <\/strong>5. Project Calendars Inheriting from Global<\/strong><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Whenever you create a Project\nCalendar, P6 displays a dialog box asking you to \u201cSelect a Calendar To Copy\nFrom\u201d. By default, a list of Global Calendars is displayed. When the Global\nCalendar is selected, P6 automatically assigns that Global Calendar as the\nCalendar to inherit holidays and exceptions from. In other words, the Work,\nNonwork and Standards days for the new Project Calendar are the same as the\nselected Global Calendar.<\/p>\n\n\n\n

    Since the new Project Calendar is now inheriting holidays and exceptions from an assigned Global Calendar, changes to that Global Calendar will automatically be reflected in the Project Calendar. This may have unintended consequences since recalculating a previous schedule update may yield different dates if the inherited Global Calendar is later changed.<\/p>\n\n\n\n

    In general, Project Calendars should not be inheriting from Global Calendars. To change this, open the Project Calendar and change the “inheriting” option to “<none><\/strong>“.<\/p>\n\n\n\n

    This report lists all Projects that have Project Calendar that is inheriting information from a Global Calendar.<\/p>\n\n\n\n


    <\/strong>6. Project Templates<\/strong><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    When P6 is installed, it usually\npopulates the data tables with default settings, records and other information.\nSome of this data relate to Project Templates for various industries.\nTherefore, there are records that exist in multiple tables across the P6 database\nthat are never used and cannot be deleted or seen directly from P6. These\nadditional records only take up space and should be deleted especially where\ndatabase space is limited.<\/p>\n\n\n\n

    To delete Project Templates, apply the same procedures detailed in P6 Oracle Doc ID 2216405.1 – “How to Delete Baseline in PROJECT Table When the Original Project Has Been Deleted.” To remove Project Templates.<\/p>\n\n\n\n

    <\/p>\n\n\n\n

    7. Projects with Baselines
    <\/strong><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    After a Project that is existing in the\nEPS has been assigned as a baseline to another Project, the assigned Project\ndisappears from the EPS list. Therefore, you must remember where the assigned\nProject is maintained if you decide to restore the original Project. <\/p>\n\n\n\n

    Since P6 allows Projects to be copied\nalong with their assigned baselines, database file size can increase\nexponentially as update are routinely copied repeatedly. The result is multiple\nversions of the same Project in the P6 database. <\/p>\n\n\n\n

    For these reasons and others, many P6\nprofessionals prefer to minimize Project Baselines. In other words, the\npreferred procedure is to \u201cRestore\u201d an assigned Baseline to the EPS immediately\nafter the variance analysis complete.<\/p>\n\n\n\n

    This report finds Projects embedded as a Baseline, then later, you can restore or delete as necessary.<\/p>\n\n\n\n


    <\/strong>8. Projects with Global Default Calendar <\/strong><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Every Project has an assigned Default Calendar. The setting for the Default Calendar for a Project, can be seen in the Project\u2019s Default Page in the Project\u2019s Details window as shown below.<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    The Default Calendar for any Project should be a Project<\/strong> Calendar, not a Global Calendar. To make this change, first Open the Project, then change the Default Calendar to one of the Project Calendars.<\/p>\n\n\n\n

    This report lists all Project with a Global Calendar assigned as its Default Calendar. The report is sorted by Project ID and displays the Project ID, Project Name, Data Date, Default Calendar Name and Default Calendar Type.<\/p>\n\n\n\n


    <\/strong>9. Projects with No Tasks<\/strong><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    In P6, adding a new project for\nthe first time is typically performed via a P6 wizard. However, at the\ncompletion of the wizard process, no tasks are automatically added to the newly\ncreated project. Therefore, it is incumbent upon the P6 immediately proceed to\nopening the new project and inserting tasks.<\/p>\n\n\n\n

    If adding tasks to new projects\nis overlooked, the EPS could contain multiple instance of Projects with No\nTasks. Finding project with no tasks using P6 alone is a difficult tasks especially\nif there are scores of Project in the EPS module.<\/p>\n\n\n\n

    This report lists all Project with a that have no Tasks assigned. The report is sorted by Project ID and displays the Project ID, Project Name, Data Date, Default Calendar Name and Default Calendar Type.<\/p>\n\n\n\n


    <\/strong>10.Resources with Global Calendar<\/strong><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    When Global Calendars are assigned to Resources and those Resources are\nassigned to activities, then sending or receiving a Schedule will cause the second\nparty to inherit that Global Calendar into their P6 System. To avoid this\nissue, Personal (or Resource) calendars should be created for each Resource.<\/p>\n\n\n\n

    This report list Projects that are using Resources assigned to a Global Calendar.<\/p>\n\n\n\n


    1<\/strong>1. Risk Categories Record Count<\/strong><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    The Risk Categories Record Count\nreport checks for an anomaly within the P6 database systems where the Risk\nCategories table is populated with possibly hundreds or even thousands of\nunusable and useless records. <\/p>\n\n\n\n

    For large .XER files, it is\nstrongly recommended to open the file using a text editor such as Notepad to\nbrowse and inspect the file for any possible Risk Categories records. Look of\nan entry line starting with %T Risk Category then multiple entry lines\nbeginning with %R.<\/p>\n\n\n\n

    This report displays the Risk\nCategories Record Count indicating that the P6 Database contains multiple Risk\nCategories Records.<\/p>\n\n\n\n

    If you encounter this issue, contact your Database Administrator to remove all records from the Risk Categories table. There are third-party tools that will also assist in removing Risk Categories records from any .XER file.<\/p>\n\n\n\n


    <\/font><\/strong>12. Suspect Project ID\u2019s<\/strong><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    In general, Project ID’s should use generic filename characters.\nCharacters like: “\\ \/ : * ? < > |#” or blank spaces should not\nbe used.<\/p>\n\n\n\n

    The Project ID name is often used in “behind the scenes” SQL\nqueries and in some isolated instances, the SQL Query can fail if they contain\nblank spaces or the special characters mention above.<\/p>\n\n\n\n

    The Suspect Project ID report list possible offending Project ID’s sorted by Project ID and list the Project ID, Project Name and Data Date. For each suspect offending Project ID, a comment is provided to explain the offending issue. <\/p>\n\n\n\n

    Copyright \u00a92020 FoxQuest Systems, Inc. – All Rights Reserved.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Maintaining Enterprise Level Data can be just as important as maintaining Project level Data.<\/p>\n","protected":false},"author":2,"featured_media":1538,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","om_disable_all_campaigns":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[18],"tags":[],"class_list":["post-1554","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-enterprise"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/02-Enterprise-Report-Selection.jpg?fit=624%2C312&ssl=1","_links":{"self":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts\/1554","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/comments?post=1554"}],"version-history":[{"count":5,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts\/1554\/revisions"}],"predecessor-version":[{"id":2040,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts\/1554\/revisions\/2040"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/media\/1538"}],"wp:attachment":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/media?parent=1554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/categories?post=1554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/tags?post=1554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}