Build a dimension with Pigment

So I have not done this but I have some ideas for where to start.
 

I’d likely have an auto ID dimension that then allows the user to select properties for GL, Supplier, and Project. It would then create the combo name via formula. Then I’d use Pigment to Pigment(P2P) so that the actual used dimension isn’t the same one being edited by users.
 

I think there are likely many other ways to do this depending on who the users are and security but I think this may be simplest.

Hi ​@ChrisAHeathcote, 

As ​@ClareHutton_QueBIT suggested,

the simplest way to do this in Pigment is usually with a list-to-list import configuration. I’ve linked a knowledge base article below that shows how to set it up.

A few design considerations as you build it:

• Add validation properties to make sure all required source dimensions are selected before import.
• Use staging properties to build the concatenated unique ID and store any additional user-entered attributes.
• Decide whether previously created members should remain available for review or audit history.
• Think through security, especially on dimensions like Supplier or Product. For example, a user may only be allowed to create and view items related to Supplier ABC.

Set Up List-to-List Import