Publish Group on the S2 // Diagnostics Tab

Use the commands in this group to publish analysis results.

Executive Briefing

Publish a Diagnostic Executive Briefing report of the current ribbon view.

Field Description
To Word Publish a Diagnostic Executive Briefing report of the current ribbon view to a Microsoft Word document.
To PDF Publish a Diagnostic Executive Briefing report of the current ribbon view to an Adobe Acrobat document.

To Microsoft Excel

Publish the current ribbon view to a Microsoft Excel report. The report includes Ribbon View, Ribbon Analysis, and Phase Analysis tabs. If you want a report that includes activity details and control account/work package metric details, publish a Fuse Analyst Report instead.

Fuse Analyst Report

Publish the current ribbon view, including activity details and control account and work package metrics, to a Microsoft Excel report. The report includes activity details and control account / work package metrics if they are part of the current ribbon. The report displays the columns selected for each metric on the metric's Define Columns tab.

The Excel file includes the following tabs:
  • Ribbon View tab
  • Ribbon Analysis tab
  • <Project Name> tab: This includes metric details for the entire project.
  • <Phase> tabs: A tab is included for each phase on the S2 // Diagnostics timeline. For example, if the Timeline displays years, the Excel spreadsheet includes one tab for each year in the timeline. Each phase tab lists metric details for that time period.

You can define the columns that display for each metric on the Define Columns tab (Metrics tab).

Fuse Summary Metric Report

Publish a summary of all metrics that have the Publish Metric option selected on the Metrics tab. The results are published to a Microsoft Excel workbook and the data for each ribbon view (group of metrics) displays on a separate tab.

In addition to the ribbon view tabs for each group of metrics, this report includes summary tabs based on the metric folder structure of the included metrics. For example, if you set all of the Industry Standards » GAO metrics to be included in the Summary report, the report will include tabs with summary results for each of the GAO metric folders.

When you publish metrics, the report combines metrics based on the folder hierarchy on the Metrics tab. For example, if you have a GAO metrics folder with a 1 Activities sub-folder on all of the Metrics forms, Acumen consolidates the data in the 1 Activities folder on all metrics forms into a single tab when it generates the report. Each report tab is then sorted using the ID entered on the Metric form.

To ensure that all metrics are grouped correctly, you can click Sync Groups in the Metrics menu group on one of the Metrics forms to synchronize the folder structures across all of the Metrics forms (Metrics, Work Package Metrics, and Control Account Metrics).

The metric exception tables are grouped so that the metric information is visible but the details of the exceptions are collapsed by default. The rows that were not exceptions in the previous period are shaded.

The Program Summary 2 tab includes a one line summary of all metrics groups that are also shown vertically on the Program Summary tab. It also includes a one line summary of all of the published metrics that are also shown on the detailed tabs. These one line summaries provide an easy way to copy and compare multiple projects in Excel.

If you don't have identical structures across the Metrics forms, the report will include more tabs since less data will be consolidated.

All metrics that have the Publish Metric option selected on the relevant Metric form are published.

The report includes:

  • Hyperlinks to folder summaries (for example, a link from the Program-Summary tab to the Organization tab) and links to ribbon view summaries.
  • A Details table for each metric in a group, regardless of whether the metric passes or fails the test for the current period.
  • A detailed tab for each metric group, regardless of whether or not it has a tripwire.

Fuse Detailed Metric Report

Publish a detailed report of all metrics that have the Publish Metric option selected on the Metrics tab. The results are published to a Microsoft Excel workbook.

Each project has its own tab with control accounts, work packages, and activities listed down the left and all metrics across the top. You can use the Detailed Reports tab in Metrics to specify whether you want a tripped metric to display an X or a specific field value. For example, you can set an activity metric to display an X so that you know it tripped, or you may want to display the budget associated with the activity or control account that caused it to trip. You can set this individually for each metric. When you publish the report, the row directly under the metric and percentage indicates whether the column displays the count or a specific field.

The manual DECM metrics display a -1 value or a -1% (percentage) in gray to indicate that they have not been evaluated.

You can filter by any column on the report. Click the down arrow on the right side of any column and select the data by which you want to filter.

When you select the report, a Detailed Metric Report Options dialog box displays, allowing you to select one or more of the following to include in the report:

  • Control accounts
  • Work packages
  • Activities
  • A Metric Record Count. This is the count of items in the metric after the filters and inclusions have been applied (that is, the count of items that are eligible for the metric).
  • Passed Metrics. When you deselect this option, the report only includes the metrics that fail as determined by the metric threshold setting. If the metric result is in the threshold marked as "Fail" (the Fail checkbox is selected on the Metric Tripwire Thresholds tab), Acumen includes it in the report. This makes it easier to identify and address the issues. If you run the report and exclude passed metrics and there are no failed metrics, Acumen displays a message letting you know that no failed metrics were found.

Fuse Metric Validation Report

Publish a detailed validation report of selected metrics (DCMA) from one or more projects or snapshots that includes all of the data considered (Y) that trips a metric (X). You can use this report to verify for each metric that its inclusions and filters are evaluating the data that it should be evaluating.

The report includes a Summary tab with a column count on the far right that displays the metric record count. Each metric has its own tab labeled with the text from the Acumen Metrics tab ID field. The grid columns on the tab are defined in Acumen Metrics on the metric's Define Columns tab and you can use the filter arrows on the column headers to filter the data. The first column is titled Metric Trip and displays TRUE for each record that tripped the metric.

When you select this option, a dialog box displays where you can select the projects or snapshots that you want to use. Next, a Browse for Folder dialog box displays where you select the destination folder. Results are published to a separate Excel workbook for each project. All metrics that have the Publish Metric option selected on the Metrics tab in Acumen are published. This means that you can use this report with any set of metrics that has the Publish flag to True.

Data filtering is turned on by default and the report includes filter arrows on the column headers of the individual metric tabs.

Hover over a cell in the Formulas Defined row to view the Primary, Secondary, Tripwire, or Secondary Tripwire formula details in the Comments popup. You can edit or copy the formula by clicking Edit Comment on the Excel Review tab.

Fuse Metric History Report

Publish a detailed history report of selected metrics (DCMA) that shows the metrics vertically and the history of results for snapshots as columns so you can see months/years of data.

The report includes the metric ID and name as well as the values for all included snapshots of the project being reported. Scenarios are not included in the report.

When you select this option in the menu, a dialog box displays so that you can select the project you want to use. You can run the report for one project at a time and the results are published to a Microsoft Excel workbook. All metrics that have the Publish Metric option selected on the Metrics tab in Acumen are published.

  • A red cell with a T (true), number, or percentage indicates that the metric failed.
  • A green cell with an F (false), number, or percentage indicates that the metric did not fail.
  • A gray cell with -, 0, 1%, or -1% indicates that the data that was needed for the evaluation wasn't available. The metric didn't pass or fail - it wasn't even evaluated.
  • The X and % columns are the results for the Primary and Secondary formulas respectively. This is the same data that you see on the S2 // Diagnostics tab

Deltek wInsight Analytics

Export the DCMA metric results to wInsight Analytics. Publish all metrics that have the Publish Metric option selected on the Metrics tab for import into wInsight. The file saves as a Deltek Cost Data Exchange File (.dcde). You can use this data in wInsight to display a dashboard with drilldown capability from control account to work package to activity.

All metrics that have the Publish Metric option selected in the relevant Metric view are published.

Select the Fail check box on the Metrics Tripwire Thresholds tab next to each relevant threshold to display failed metrics in wInsight Analytics.

When you publish the report, Acumen includes the metric record count; the count of items in the metric after the filters and inclusions have been applied (that is, the count of items that are eligible for the metric).

Metrics results to a Deltek Data Source

You can export all metric results that have the Publish Metric option selected on the Metrics tab to a database using the data source specified on the Deltek Acumen Options Platforms (Deltek) page. This is helpful when you want to share your results with other people or import them into another program.

To use this feature, you must complete the following steps on the Deltek Acumen Options dialog box Platforms (Deltek) page:

  1. In order for Acumen to be able to publish metrics to a database, you must define a valid data source. Click Manage Data Sources on the Platforms (Deltek) page to specify the data source that Acumen should use. See the Acumen Installation guide for more information about setting up a database for use with Acumen.
  2. Select Metrics results to a Deltek data source on the Platforms (Deltek) page and use the drop-down list to specify which of the available data sources Acumen should use when publishing to the database.

This menu option only displays on the Publish menu after you have completed the above steps.

Copy to Clipboard

Copy a portion of the screen as an image. Select from the following options:
  • All
  • Intersection Chart
  • Phase Chart
  • Ribbon Chart
  • Activity Browser

Create Custom Reports

Develop custom reports for third-party applications using the Deltek Acumen API.