Entity Reference Cubes

These cubes represent the core organizational structure of your GuideMode deployment. They primarily serve as dimension tables for filtering and grouping data in other cubes, but also provide basic count metrics.

Projects Cube

Source Table: projects Description: Project information including local projects detected by the desktop app and connected repositories from GitHub/GitLab.

Key Dimensions

Dimension	Type	Description
`id`	string	Unique project ID
`projectName`	string	Local project name (from desktop)
`gitRemoteUrl`	string	Git remote URL
`detectedProjectType`	string	Detected type (typescript, python, etc.)
`sourceType`	string	How project was added

Provider Integration Dimensions

Dimension	Type	Description
`provider`	string	Source provider (github, gitlab, etc.)
`externalId`	string	Provider’s ID
`name`	string	Repository name
`fullName`	string	Full name (org/repo)
`owner`	string	Repository owner
`url`	string	Repository URL
`apiUrl`	string	API URL
`defaultBranch`	string	Default branch
`isPrivate`	string	Private repository flag

Sync Settings Dimensions

Dimension	Type	Description
`syncIssues`	string	Sync issues enabled
`syncPullRequests`	string	Sync PRs enabled
`syncDeployments`	string	Sync deployments enabled
`lastSyncedAt`	time	Last sync timestamp
`connectedAt`	time	Connection timestamp

Timestamp Dimensions

Dimension	Type	Description
`createdAt`	time	Record creation time
`updatedAt`	time	Last update time

Measures

Measure	Description
`count`	Total projects

Key Relationships

The Projects cube connects to:

Join	Relationship	Description
`Teams`	belongsToMany	Teams assigned to project
`TeamProjects`	hasMany	Junction table entries
`Issues`	hasMany	Issues in project
`PullRequests`	hasMany	PRs in project
`Deployments`	hasMany	Deployments from project
`DiscoveryFlow`	hasMany	Discovery flow facts
`DeliveryFlow`	hasMany	Delivery flow facts
`DeploymentFlow`	hasMany	Deployment flow facts

Use Cases

Project Inventory: List all connected projects
Sync Status: Monitor sync settings and timing
Provider Distribution: Count projects by provider
Type Analysis: Group projects by detected type

Teams Cube

Source Table: teams Description: Team structure information, including GitHub team integration details.

Key Dimensions

Dimension	Type	Description
`id`	string	Unique team ID
`name`	string	Team name
`slug`	string	URL-safe team identifier
`description`	string	Team description
`privacy`	string	Privacy setting (secret, closed)

GitHub Integration Dimensions

Dimension	Type	Description
`githubTeamId`	number	GitHub team ID
`githubOrgLogin`	string	GitHub organization login
`githubOrgName`	string	GitHub organization name
`avatarUrl`	string	Team avatar URL

Timestamp Dimensions

Dimension	Type	Description
`createdAt`	time	Record creation time
`githubCreatedAt`	time	GitHub team creation time
`lastSyncedAt`	time	Last sync timestamp

Measures

Measure	Description
`count`	Total teams

Key Relationships

The Teams cube connects to many other cubes for filtering:

Join	Relationship	Description
`Projects`	belongsToMany	Projects assigned to team
`TeamMembers`	hasMany	Team membership entries
`TeamProjects`	hasMany	Team-project assignments
`Issues`	belongsToMany	Issues via projects
`PullRequests`	belongsToMany	PRs via projects
`Deployments`	belongsToMany	Deployments via projects
`SurveyResponses`	belongsToMany	Surveys via members
`DiscoveryFlow`	belongsToMany	Discovery via projects
`DeliveryFlow`	belongsToMany	Delivery via projects
`DeploymentFlow`	belongsToMany	Deployments via projects

Use Cases

Team Directory: List all teams
GitHub Sync Status: Monitor team synchronization
Cross-Cube Filtering: Filter any cube by team

Common Filter Pattern

Teams is the most commonly used filter dimension:

// Filter any cube by team
filters: [
  { member: "Teams.id", operator: "equals", values: ["team-uuid"] }
]

// Or by team name
filters: [
  { member: "Teams.name", operator: "equals", values: ["Engineering"] }
]

Users Cube

Source Table: users Description: User information for all users in your organization, filtered by tenant membership.

Key Dimensions

Dimension	Type	Description
`id`	string	Unique user ID
`name`	string	Display name
`username`	string	Username
`email`	string	Email address

GitHub Integration Dimensions

Dimension	Type	Description
`githubId`	number	GitHub user ID
`avatarUrl`	string	Profile avatar URL

Activity Dimensions

Dimension	Type	Description
`createdAt`	time	Account creation time
`firstSessionUploadedAt`	time	First session upload

Measures

Measure	Description
`count`	Total users

Key Relationships

Join	Relationship	Description
`Teams`	belongsToMany	Teams user belongs to
`TeamMembers`	hasMany	Team membership entries

Security Note

The Users cube automatically filters to users in the current tenant via the tenant_users junction table. You’ll only see users who are members of your organization.

Use Cases

User Directory: List organization members
Onboarding Tracking: Monitor first session uploads
Activity Analysis: Track user activity via sessions
Cross-Cube Filtering: Filter by user in other cubes

Filtering Patterns

Filter by Team

Most cubes support team filtering via joins:

// Sessions by team
{
  measures: ["Sessions.count"],
  dimensions: ["Teams.name"],
  filters: [{ member: "Teams.id", operator: "equals", values: ["team-1"] }]
}

Filter by Project

// Issues by project
{
  measures: ["Issues.count", "Issues.openCount"],
  dimensions: ["Projects.name"],
  filters: [{ member: "Projects.id", operator: "equals", values: ["proj-1"] }]
}

Filter by User

// Assessments by user
{
  measures: ["Assessments.count", "Assessments.thumbsUpPercentage"],
  dimensions: ["Users.name"],
  filters: [{ member: "Users.id", operator: "equals", values: ["user-1"] }]
}

Combined Filters

// PRs by team and project
{
  measures: ["PullRequests.count", "PullRequests.medianCycleTimeDays"],
  dimensions: ["Teams.name", "Projects.name"],
  filters: [
    { member: "Teams.name", operator: "equals", values: ["Frontend"] },
    { member: "Projects.provider", operator: "equals", values: ["github"] }
  ]
}

Entity Hierarchy

Organization (Tenant)
├── Teams
│   ├── TeamMembers → Users
│   └── TeamProjects → Projects
├── Users
│   └── TeamMembers → Teams
└── Projects
    └── TeamProjects → Teams

Work Tracking Cubes - Issues, PRs, Deployments
Sessions & AI - Session analytics
Analytics Overview - Understanding the analytics system

Entity Reference Cubes

Projects Cube

Key Dimensions

Provider Integration Dimensions

Sync Settings Dimensions

Timestamp Dimensions

Measures

Key Relationships

Use Cases

Teams Cube

Key Dimensions

GitHub Integration Dimensions

Timestamp Dimensions

Measures

Key Relationships

Use Cases

Common Filter Pattern

Users Cube

Key Dimensions

GitHub Integration Dimensions

Activity Dimensions

Measures

Key Relationships

Security Note

Use Cases

Filtering Patterns

Filter by Team

Filter by Project

Filter by User

Combined Filters

Entity Hierarchy

Related