Datamining Tiers - Reporting Tiers

Modified on Tue, 20 Jan at 1:49 PM

TABLE OF CONTENTS


Reporting Tiers


Reporting Tiers add direct, reportable information about module items. This includes standard detail fields, custom form fields, defects, tasks, surveys, and other related data.

Reporting Tiers also define how module items are linked together in a report. For example, they enable reports such as User-to-Application or User-to-Device-to-Application views.


Top-Level Reporting Tier

Every Datamining Report (DMR) starts with a single top-level Reporting Tier. This tier always corresponds to the module from which the report is launched.

For example, launching a Datamining Report from the Applications grid will automatically add the Applications Reporting Tier as the top-level tier.


Standard Module Reporting Tiers

The top-level Reporting Tier provides access to:

  • Standard Detail Fields
  • Custom Form Fields

Some default fields are pre-selected automatically.

Standard Reporting Tiers are available for the following modules:

  • Applications
  • Users
  • Devices
  • Mailboxes
  • Bespoke
  • Deployment Units
  • Tasks
  • Defects


Field Visibility and Discovery

  • Show Hidden Fields (Build Report tab) displays all available Detail and Custom Form fields.
  • Two “filter as you type” search boxes allow quick discovery of fields by name.


Reporting Tier Options

Each Reporting Tier includes an options panel, collapsed by default and expandable using the eye icon.

Available options may include:

  • Adding counts of linked module items (for example, linked Users or Devices on an Application report)
  • Including all Custom Form Fields automatically (useful for Power BI endpoints and future-proofing reports)
  • Adding Notes columns


Application-Specific Options

The Applications Reporting Tier includes additional options to:

  • Display the original Application name (if renamed)
  • Display rationalisation information (source Application)


History Fields

Enabling Show History Fields in the Build Report tab activates history tracking for selected fields.

When enabled, each selected field adds three additional columns:

  • Previous value
  • Date changed
  • User who made the change


Additional Reporting Tiers

Additional Reporting Tiers extend a top-level tier by joining related data. They cannot exist independently and must always be linked to a top-level tier.

Each additional tier appears as a collapsible panel next to the top-level tier and has its own configuration options.


Dependencies Reporting Tier

Lists dependencies for each top-level module item. Each dependency is displayed on a separate row.

Common dependency fields can be enabled via checkboxes (such as dependency name, Process, and dependency depth).

To include additional fields (for example, a Device serial number), enter the field’s internal name (such as Devices_SerialNumber) in the Expand Dependency Fields textbox.

Available Fields

True Parent Id, Parent Project Id, Parent Module Id, Parent Instance Id, Project, Module, Item Name, Title, Instance Id, Module Id, Project Id, Process, Sub Process, Process Status, Process Id, Sub Process Id, Process Status Id, Is Locked, Is Archived, Is Deleted, Is Depend Of, Depth, Is Top Level


Contacts Reporting Tier

Lists Contacts linked to the module item. Multiple Contacts appear as separate rows.

Includes standard contact details and an option to include Contact Type (for example, “UAT” or “Application Owner”).

Available Fields

Title, First Name, Last Name, Sam Account, Domain, Organisation, Job Title, Phone Work, Phone Mobile, Email Work, Email Home, Contact Id, Website, Office Site, Address, City, Country, Post Code, Note


Surveys Reporting Tier

Adds Portal Forms (formerly Surveys) to the report, including user responses, completion dates, pass/fail results, and comments.

Survey results can be displayed for all surveys (one row per response), or a specific survey can be selected. Multiple Survey Reporting Tiers may be added to the same report.

Available Fields

Survey Id, Is Enabled, Title, Survey Name, Internal Name, Survey Url, Comments, Fail Reason, Is Locked, Is Locked Date, Is Archived, Test Sign Off Url, Page Visit Count, Page Last Visit Date, Email Statistics


Testing Reporting Tier

Adds test results (such as Application UATs) to the report.

Multiple test results for the same item (for example, repeated UATs) appear as separate rows. Filtering by test type is not currently supported.

Available Fields

Test Result Id, Survey Id, Contact Id, First Name, Last Name, Email, Test Type, Title, Is Global Sign Off, Notes to Tester, Test Window Start, Test Window End, Device Name, Completed By, Complete Results, Complete Date, Comments, Fail Reason, Is Locked, Is Locked Date, Is Archived, Test Sign Off Url, Page Visit Count, Page Last Visit Date, Email Statistics


Attachments Reporting Tier

Displays information about files attached to the module item.

An optional Download Url column can be included to allow direct file downloads, which is useful for portal-exposed reports.

Attachment type filtering is not available in this panel, but can be applied using the Advanced Filter and Sort tab.

Available Fields

Attachment Id, Attachment Type, File Name, Comment, Content Type, File Extension, File Size KB, Download Url, Internal Name, Last Modified Date, Last Modified By


Email Reporting Tier

Displays email activity related to the primary module item.

Email templates must be registered to the module and explicitly selected in the Reporting Tier.

Available Fields

Email Name, Email Category, To Address, CC Address, BCC Address, Template Subject, Email Subject, Last Sent Date, Last Opened Date, Open Count, Send Success


Self Schedule Reporting Tier

Reports on Deployment Unit self-scheduling activity and completion status.

Available Fields

Instance Id, Self Schedule Is Locked, Allow Expired Self Schedule, Is Scheduling Exception, Link Expiry Date, Schedule Url, Page Visit Count, Page Last Visit Date, Request Email Sent, Reminder Email Sent, Complete Email Sent, Update Email Sent, Cancel Email Sent



Reporting Tiers – Canonical Rules

  • Every Datamining Report has exactly one top-level Reporting Tier.
  • The top-level Reporting Tier is determined by the module from which the report is launched.
  • Additional Reporting Tiers cannot exist independently and must join to a top-level tier.
  • Each additional Reporting Tier may produce multiple rows per top-level item.
  • Reporting Tiers control what data is displayed; they do not affect readiness calculations.


Reporting Tiers – Frequently Asked Questions

Why do I see multiple rows for the same item?

Additional Reporting Tiers (such as Dependencies, Surveys, or Tests) create one row per linked record. Multiple linked records result in multiple rows.


Why can’t I add a Reporting Tier by itself?

Reporting Tiers must be joined to a top-level module. They cannot exist without a primary module context.


Why don’t I see a field I expect?

The field may be hidden by default. Enable Show Hidden Fields in the Build Report tab to display all available fields.


Why did new Custom Form fields not appear in my saved report?

Unless the option to include all Custom Form Fields is enabled, newly added fields must be manually selected in existing reports.


How do I download attachments from a report?

Enable the Download Url field in the Attachments Reporting Tier to allow direct downloads.


Can I filter attachments by type?

Attachment type filtering is not available in the Reporting Tier panel. Use the Advanced Filter and Sort tab instead.


Do Reporting Tiers affect Readiness?

No. Reporting Tiers only control data visibility. Readiness is calculated exclusively by Readiness Tiers.


Common Support Scenarios

Scenario: My report suddenly has more rows than expected

Check for additional Reporting Tiers that introduce one-to-many relationships, such as Dependencies, Surveys, or Testing tiers.


Scenario: Power BI reports break when new Custom Form fields are added

Enable the option to include all Custom Form Fields so new fields are automatically added to future report outputs.


Scenario: Email data is missing

Confirm that the correct Email Templates are registered to the module and selected in the Email Reporting Tier.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article