I have a transaction list with all employees in the Workforce planning and in the same application we created the Employee ID with various properties mapped to this dimension like country, department etc. I would say classic Employee ID dimension block with a mapping.
Now we have a need to add additional dimension property at the Employee Id level for a respective department which can be added manually employee by employee by the other team who makes the allocation of sales forces in the other application i.e. it’s not a Workforce app.
What type of block we should create to have a kind of a table where we have a list of employees and then column with the list of properties for the allocation?
PS. We don’t want to do it at the transaction list level due to security and also this infotramtion will never be available in our HR system to import it. Thanks!
Best answer by BenoitView original