Join Agent Analytics Semantic Data Model with User Table to Build User Dimensions report

Step 1: Access the Semantic Layer in Data Cloud

1. Open App Launcher

2. Navigate to Data Cloud

3. Look for the Semantic Layer tab

If the Semantic Layer tab is not visible

You need to enable tab visibility.

Enable Semantic Layer Tab

1. Go to Setup

2. Navigate to Users → Profiles

3. Search for and select System Administrator

4. Click Edit

5. Search for Semantic Layer Tab

6. Set it to On by Default

7. Save

The Semantic Layer tab should now be visible in the Data Cloud App

Step 2: Create a Data Stream for the User Object

This step ingests User data from Salesforce CRM into Data Cloud.

1. Navigate to Data Cloud App

2. Click the Data Streams tab

3. Click New

4. Under Connected Sources, select Salesforce CRM

5. Click Next

6. Select the Salesforce Org from which agent usage metrics are required

7. Click View Objects

8. Search for and select the User object

9. Click Next

10. Select the required fields

11. Click Next

12. Select the Data Space

13. Click Deploy

This creates:

• A Data Stream

• A User Data Lake Object (DLO)

Note: It may take some time for the Data Stream and DLO to become active.

Step 3: Map User DLO to User DMO

If fields are not mapped, data model object will not appear in DMO.

Check Field Mapping

1. Open the User Data Lake Object (DLO)

2. In the Data Mapping section, click Start

3. Click Select Object under Data Model Entities

4. Search for and select User (DMO)

5. Click Done

Field Mapping

• Auto-mapping occurs for fields with matching names

• Manually map additional fields if required

6. Click Save

This passes data from User DLO → User DMO
DMO readiness may take some time.

Step 4: Create a Semantic Layer Model

1. Navigate to the Semantic Layer tab

2. Click New

3. Choose From Existing Model

4. Click Next

5. Select EmployeeAgentAnalytics SDM or Agentforce Analytics Foundations
   (You can choose a different agent model as per requirement)

6. Click Next

7. Enter a Model Name

8. Click Create

Step 5: Add User Data Object to the Semantic Model

1. Open the newly created Semantic Model

2. Click New → Add Data Objects

3. Search for User under:

   • Data Model Objects (DMO), or

   • Data Lake Objects (DLO)
     (Both are 1:1 mapped)

4. Click Save

Step 6: Define Relationship with AI Agent Session Participant

1. In the Semantic Model, locate the User object

2. Click the Plus (+) icon

3. Select AI Agent Session Participant

4. Under Select Matching Data Object Fields, click +

5. Define the relationship: User.Id = AI Agent Session Participant.UserId

6. Click Add

7. Click Apply

Mapping is now complete.

Step 7: Create the Report

1. Go to Reports

2. Click New Report

3. Select Semantic Data Models

4. Search for and select your Semantic Model

5. Click Start Report

Report Configuration

• Group rows by: Full Name

• Columns:

  • Unique Interactions

  • Unique Sessions

Filters

• AI Agent Session Participant Role = User

6. Click Save & Run

The report now displays user interactions with the AI agent, based on Semantic Layer analytics.