[Feature] Multiple reference to the same foreign model but with different "roles" #1851
Description
Is this your first time submitting a feature request?
- I have read the expectations for open source contributors
- I have searched the existing issues, and I could not find an existing issue for this feature
- I am requesting a straightforward extension of existing metricflow functionality, rather than a Big Idea better suited to a discussion
Describe the feature
We would like to have the possibility, in a semantic model, to reference a foreign entity multiple times, with different "roles".
Let me share an example: let's say we have a semantic model for all potential and closed deals (Salesforce Opportunities) and another semantic model with all company employees.
Let's say also that on a deal there are multiple employees that collaborate for its success: account executives, solution building consultants, VP sponsors, etc. Every SFDC Opportunity stores the employee id for each role, meaning every opportunity has an account_executive_id, solution_building_consultant_id, vp_sposor_id.
Now, in the semantic model for Salesforce Opportunities, we would like to define different foreign entities that point always to the employee semantic model but with different roles. Unfortunately, today this is not possible.
As a workaround, we had to replicate the employee semantic model, creating one dedicated to account execs, one for SB consultants, one for VP sponsors, etc.
This is very inconvenient, it adds entropy, code replication, code maintainance.
Describe alternatives you've considered
No response
Who will this benefit?
No response
Are you interested in contributing this feature?
No response
Anything else?
No response