Export position data from the instance from Admin Center –> Import and Export Data and find the file for position matrix relationships.
2. Filter the file for the particular position that you want to remove in column positionMatrixRelationship.relatedPosition.code
3. Please note that there may be a position code present more than once under the column “code”.
4. For each position code, consider only the record with the latest date. A new record should be added to this position with effective date after the latest date in the file. This new record should not have the current position mentioned in the Matrix Relationships field.
5. Once step 4 is completed for all the codes, the position can be made inactive with effective date after the latest date for all the codes. In our example, the effective date should be after 6/19/2015 and we should use DELIMIT operator to achieve our objective. The Position Matrix Relationship import can be done from Admin Center –> Import and Export Data.
FAQ:
- Only the DELIMIT operator should be used for this action.
- If you wish to remove the Matrix Relationship in all records, you should DELMIT it in the first record you wish to remove and then it will be removed from all other records via future propagation. Do not include all records in the import file.
Are the modifications done to Matrix Manager replicated into People Profile?
Unlike the replicaiton betweeen Job Info and position, the visible section in People Profile is not a different databased replciated. Instead is the object Position-Matrix Relationship. So the modificaitons done though the import in “import and export data” Position-Matrix Relationship object will be immediately vissible in PP3.
