• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Ten Six Consulting

Project and Earned Value Management, Primavera P6 & Deltek Cobra & Acumen Services

703-910-2600
  • Training
    • Primavera P6 Training
    • Deltek Training
    • Microsoft Project Training
    • Project Management Training
    • Earned Value Management Training
    • Open Training Class Dates
    • Customized Video Training Classes
  • Consulting
    • Project Management
      • Assessments and Health Checks
      • Organizational Change Management
      • Project Governance
      • Project Management Tool Selection
      • Risk Analysis Services
      • Scheduling Services
      • Project Management Staff Augmentation
    • Project Management Office (PMO)
      • PMO Pulse Check
      • PMO Implementation Planning
      • PMO Organization Change Management
      • PMO Project Manager Leadership Development
      • PMO Planning Best Practices
      • PMO Scheduling Best Practices
      • PMO Enterprise Tool Training
      • Program Manager Challenges
    • Earned Value Management
      • EVMS RFP Support
      • EVMS Assessments
      • Earned Value Management Tool Selection
      • EVMS System Description and Process Development
      • Integrated Baseline Review (IBR) Preparation and Conduct
      • EVM Certification Support
      • Integrated Master Schedule (IMS) Health Check
      • Action Plan Development for Progress Assessment Reviews
      • Earned Value Data Analysis and Reporting
      • WBS Guidelines for Government Acquisition Programs (MIL-STD 881D)
      • EVMS Staff Augmentation
    • Risk Management
      • Risk Management Support and Consulting
      • Risk Management Maturity Assessment® (RMMA)
      • Risk Management Checkup Services (RMCS®)
      • Risk Management Training and Workshops
    • Portfolio Management
      • IT Portfolio Management
      • Corporate Governance Portfolio Management
      • Product Portfolio Management
      • Public Sector Portfolio Management
      • New Product Development Portfolio Management
    • ISO 21500 Assessment
  • Software
    • Primavera P6
      • Primavera P6 Application Consulting
      • Primavera P6 BI Publisher Services
      • Primavera P6 Technical Consulting
      • Primavera P6 Integration
      • Primavera P6 Knowledge Transfer, Mentoring and Coaching
      • Primavera P6 Staff Augmentation
    • Primavera Unifier
    • Deltek Cobra
      • Deltek Cobra Application Consulting
      • Deltek Cobra Knowledge Transfer, Coaching and Mentoring
      • Deltek Cobra Integration
      • Deltek Cobra Staff Augmentation
    • Microsoft Project
      • Building an Integrated Master Schedule (IMS)
      • Integrating Microsoft Project with Deltek Cobra
      • Migrating From Microsoft Project To Oracle Primavera P6
      • Microsoft Project to Primavera P6 Conversion Service
  • Blog
    • Deltek Acumen
    • Deltek Cobra
    • Earned Value Mgmt
    • Microsoft Project
    • PMO
    • Primavera P6
    • Project Management
    • Risk Management
  • Clients
  • About Ten Six
  • Contact Us

3 Brilliant Cobra Reporting Hacks

You are here: Home / Deltek Cobra / 3 Brilliant Cobra Reporting Hacks

December 2, 2020 By TheCobraGuy

Cobra Reporting Hacks

Cobra Reporting Hacks

Deltek Cobra’s reporting capabilities are vast. The out of the box reports only scratch the surface of what you can do with the Cobra reporting engine. With the ability to write your own custom report templates, the sky is the limit. But there are some Cobra reporting hacks you can do the through the basic reports screens that can change how you use reports. In this post, we will look at three simple Cobra reporting hacks to increase the reporting functionality without having to touch a report template.

1. Increase Maximum Sub-Total Levels

Brilliant Cobra Reporting HacksYou can do a lot with the out of the box reports like the Time Phased report. Reports like this are incredibly flexible in terms of how you can group data and selecting down to whatever level in the project structure you want to report data at. But “out of the box” reports typically allow you to only select up to four sub-totals.

That might be fine for the basic project, but even with all that flexibility, you can quickly find yourself wanting more in terms of the number of sub-totals you can select. This is especially true if you take full advantage of the codes in Cobra that can be assigned to the Control Account, Work Package or Resource Assignments. So how can you expand your choices? Simply update the Report Properties to change the maximum number!

Report Properties

Find the report you want to update, for example the Time Phased report on the Reports view of the Cobra Explorer, right click and then select Properties.

Deltek Cobra Explorer PropertiesFrom the Properties window you can click on the Report Definition tab. This is where all the settings for the report are stored in an xml format. This view can be a little tricky to read, but we will walk through finding the line we are looking for.

First, click anywhere in the middle of the screen. This will jump you down to the bottom of the screen. Not sure why it does this, but for what we need this is perfect because the setting we are looking for is at the bottom of the script.

Look for the line that starts with <Property Name=”MaxNumberOfCriteria”. When you follow that line out, you’ll see that the value for that line is set to 4. We can update that number to be what we want, say 10. So the line would look like this after the update: <Property ame=”MaxNumberOfCriteria” DataType=”Int32” ReadOnly=”>10</Property>.

Click Apply or OK and then run the report on a project. You will notice when you get the Sub-Totals page you can now enter as many as 10 levels!

Increase Sub Totals to 10

2. Produce a Data Tab Only Report

For all the things you can do with formatting in the Cobra reports, sometimes you just want to dump the data out. This is particularly helpful if you want to pivot on the data in Excel. You can accomplish this with the reports just the way they are, but you end up ignoring or removing the Report and Calendar tabs which is just wasted effort.

Worse, all that formatting makes the report run slower. If in the end you just want a tabular format for your data based on your selections those extra steps and the slower response time can be frustrating.

The quick answer is to modify the Report Properties to just include the Data tab. We are going right back into the Report Properties like we did above, but this time you are going to want to save a copy of the standard report, making the Sub-Total, etc. selections you want to include. Now you can modify the properties of this new report without impact the standard report.

Modify Cobra Report Properties

In the Report Definition tab of the Report Properties dialog you want to look for and find the “DisplayDataWorksheets” property. It will probably be around the middle of the screen.

The line is highlighted here in the example. By default, that entry will be set to ‘0’, which includes all the tabs. But if you change that entry to 2 and apply the change you will tell Cobra to not produce the Report tabs (Report & Template).

The resulting report will default to the Data tab and you will be ready to pivot or link to this report (plus it will run faster).

Cobra default to the Data tab

Bonus hack: If you set that same Parameter to 1 you will only see the Report tab, no Data or Calendar tab!

3. Filter Based on Thresholds

Filter Based on Thresholds

Thresholds in Cobra are a powerful tool for helping you know when your project is going off course and help focus project management resources on just the areas of the project that need its attention.

They drive the color coding in everything from the Project View in the Cobra Explorer to the Analysis tool and even the highlighting in the IPMR reports. But you can focus the report further by having the content of the report filtered down to just the elements that break a threshold without having to create a filter in Cobra. This is particularly helpful for Variance Analysis Reports (VARs) where this option will filter the report down to just the elements that require a VAR instead of having to wade through all the elements regardless of whether they break a threshold or not.

Filter Based on Thresholds

You can go to, you guessed it, Report Properties for a report like the IPMR Format 5 and select the Report Definition tab. This time we are looking for the “ApplyThresholdFilter” property, usually at the top of the Report Definition list.

By default this option is set to 0 which means don’t filter the results. Changing this option to 1 turns on this filter so that only elements that break a defined threshold will be included in the report. No additional filters need to be set at the time of running the report.

The resulting output will be focused down to just the elements that need to be addressed.

Before:

Deltek Cobra ApplyThresholdFilter

After:

Deltek Cobra Reporting Hacks

These three Cobra reporting hacks to your report properties, open lots of new possibilities with Cobra’s reports all with three simple changes and we have not even covered all of the things you can do with the Report Properties.

Interested in more Cobra Report Properties settings? Click here and we’ll send you an expanded list of properties and their function.

Click here for more articles written by The Pungi

Primary Sidebar

  • This field is for validation purposes and should be left unchanged.
  • Facebook
  • LinkedIn
  • Twitter

Categories

  • Deltek Acumen
  • Deltek Cobra
  • Earned Value Mgmt
  • Microsoft Project
  • PMO
  • Primavera P6
  • Project Management
  • Risk Management

Archives

Footer

Upcoming Classes

Primavera P6 Professional Fundamentals

Primavera P6 EPPM Fundamentals

Primavera P6 EPPM Administrator

Oracle Primavera P6 BI Publisher Fundamentals Training Class

EVMS Training

Deltek Cobra Fundamentals Training

Deltek Cobra Advanced Training Class

Deltek Acumen Fuse Training Class

Copyright © 2021 · Ten Six Consulting, LLC · 703.910.2600

  • Training
    ▼
    • Primavera P6 Training
    • Deltek Training
    • Microsoft Project Training
    • Project Management Training
    • Earned Value Management Training
    • Open Training Class Dates
    • Customized Video Training Classes
  • Consulting
    ▼
    • Project Management
      ▼
      • Assessments and Health Checks
      • Organizational Change Management
      • Project Governance
      • Project Management Tool Selection
      • Risk Analysis Services
      • Scheduling Services
      • Project Management Staff Augmentation
    • Project Management Office (PMO)
      ▼
      • PMO Pulse Check
      • PMO Implementation Planning
      • PMO Organization Change Management
      • PMO Project Manager Leadership Development
      • PMO Planning Best Practices
      • PMO Scheduling Best Practices
      • PMO Enterprise Tool Training
      • Program Manager Challenges
    • Earned Value Management
      ▼
      • EVMS RFP Support
      • EVMS Assessments
      • Earned Value Management Tool Selection
      • EVMS System Description and Process Development
      • Integrated Baseline Review (IBR) Preparation and Conduct
      • EVM Certification Support
      • Integrated Master Schedule (IMS) Health Check
      • Action Plan Development for Progress Assessment Reviews
      • Earned Value Data Analysis and Reporting
      • WBS Guidelines for Government Acquisition Programs (MIL-STD 881D)
      • EVMS Staff Augmentation
    • Risk Management
      ▼
      • Risk Management Support and Consulting
      • Risk Management Maturity Assessment® (RMMA)
      • Risk Management Checkup Services (RMCS®)
      • Risk Management Training and Workshops
    • Portfolio Management
      ▼
      • IT Portfolio Management
      • Corporate Governance Portfolio Management
      • Product Portfolio Management
      • Public Sector Portfolio Management
      • New Product Development Portfolio Management
    • ISO 21500 Assessment
  • Software
    ▼
    • Primavera P6
      ▼
      • Primavera P6 Application Consulting
      • Primavera P6 BI Publisher Services
      • Primavera P6 Technical Consulting
      • Primavera P6 Integration
      • Primavera P6 Knowledge Transfer, Mentoring and Coaching
      • Primavera P6 Staff Augmentation
    • Primavera Unifier
    • Deltek Cobra
      ▼
      • Deltek Cobra Application Consulting
      • Deltek Cobra Knowledge Transfer, Coaching and Mentoring
      • Deltek Cobra Integration
      • Deltek Cobra Staff Augmentation
    • Microsoft Project
      ▼
      • Building an Integrated Master Schedule (IMS)
      • Integrating Microsoft Project with Deltek Cobra
      • Migrating From Microsoft Project To Oracle Primavera P6
      • Microsoft Project to Primavera P6 Conversion Service
  • Blog
    ▼
    • Deltek Acumen
    • Deltek Cobra
    • Earned Value Mgmt
    • Microsoft Project
    • PMO
    • Primavera P6
    • Project Management
    • Risk Management
  • Clients
  • About Ten Six
  • Contact Us