---
title: Custom attribute for relationships in Advanced Reporting
description: Advanced Reporting supports custom attributes for relationships in its reports. When an administrator creates a custom relationship in the native IDM console for the user identity object, the relationship is available in Advanced Reporting (custom reports) and filters.
component: pingoneaic
page_id: pingoneaic:reports:use-cases/custom-attributes-for-relationship-in-advanced-reports
canonical_url: https://docs.pingidentity.com/pingoneaic/reports/use-cases/custom-attributes-for-relationship-in-advanced-reports.html
keywords: ["Advanced Identity Cloud", "Reports", "Template", "Custom attributes", "Relationships"]
section_ids:
  steps: Steps
  create-a-custom-relationship: Create a custom relationship
  create-a-custom-report-with-custom-relationship: Create a new report using the custom relationship
  generate-the-custom-relationship-report: Generate your custom relationship report
---

# Custom attribute for relationships in Advanced Reporting

Advanced Reporting supports custom attributes for relationships in its reports. When an administrator creates a custom relationship in the native IDM console for the `user` identity object, the relationship is available in Advanced Reporting (custom reports) and filters.

A relationship represents a connection between two identity objects, such as users, devices, groups, or roles. Relationships define how these entities interact, enabling hierarchical structures, access controls, and delegation of responsibilities.

|   |                                                                                                                                                                                                                                                                         |
| - | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
|   | Advanced Identity Cloud add-on capabilityContact your Ping Identity representative if you want to add Advanced Reporting to your PingOne Advanced Identity Cloud subscription. Learn more in [Add-on capabilities](../../product-information/add-on-capabilities.html). |

## Steps

In this example, you have a user who is a developer lead with an `Analyst` role. The user supervises other developers in the company.

The tenant administrator creates a relationship, `custom_alpharoles` in IDM that represents the connection between two identity objects, `alpha_user` and `alpha_role`.

The general steps are:

* [Create a custom relationship](#create-a-custom-relationship)

* [Create a new report using the custom relationship](#create-a-custom-report-with-custom-relationship)

* [Generate your custom relationship report](#generate-the-custom-relationship-report)

### Create a custom relationship

1. Sign on to Advanced Identity Cloud admin console as as tenant administrator.

2. Add a custom relationship:

   1. Go to Native Consoles > Identity Management.

   2. Click Configure > Managed Objects and click Alpha\_user.

   3. On the Alpha\_user page, click [icon: add, set=material, size=inline] Add a property.

   4. Scroll down to the bottom of the page and enter the following:

      * For Name, enter `custom_alpharoles`.

        |   |                                                                                                                                                                                                   |
        | - | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
        |   | Custom relationships must be prefixed with `custom_`. Learn more about custom relationships at [Create a relationship between two objects](../../idm-objects/relationships-between-objects.html). |

      * For Type, select Relationship.

   5. Click Next.

   6. In the Add Resource modal, select alpha\_role for Resource.

   7. For Display Properties, select name.

3. In the Advanced Identity Cloud admin console, go to Identities > Manage and click Alpha realm - Users.

   1. Locate and click your test user to open the Details page.

   2. On the Details page, select the Analyst role in the Custom\_alpharoles field.

   3. Click Save.

### Create a new report using the custom relationship

1. In the Advanced Identity Cloud admin console, go to Reports.

   1. Click [icon: add, set=material, size=inline] New Report.

   2. In the New Report modal, enter the following:

      * Name: Enter a descriptive name for the new report.

      * Description (optional): Enter a general description for the report.

      * Who can run: Select Users.

   3. Click Next.

2. Click [icon: add, set=material, size=inline] Data Source.

   1. In the Add a Data Source modal, select Users and click Next.

   2. On the draft report page, select the properties in the right pane you want to appear in the report. For example:

      * Username

      * First Name

      * Last Name

3. On the same page in the right pane, scroll down to Related Data Sources.

   1. Next to Custom\_alpharoles, click [icon: add, set=material, size=inline] and then click [icon: add, set=material, size=inline] Add as Data Source.

   2. Scroll down to users/custom\_alphaRoles and click Role Name.

      |   |                                                                                   |
      | - | --------------------------------------------------------------------------------- |
      |   | You can rearrange the columns by dragging and dropping them in the desired order. |

   3. Click Save.

### Generate your custom relationship report

1. On the Reports page, locate your custom report and click Run.

2. On your report page, click Run Now.

3. After your report has generated, click View Report.

   The report displays all users with a custom relationship.

4. Review your report if you are satisfied with the results, click [icon: ellipsis, set=fa]> Publish to activate it.

   ![An example of a generated custom report using a custom relationship.](../_images/custom-relationship-report-example.png)