Automate Dimension Load
Our client has a requirement to automate loading a particular dimension (Vessel) without preparing the dimension load csv file manually.
Client is a port authority and it has a source system which generates vessel ids (about 500 vessel ids daily/1500 vessel ids per month) and should load these vessel ids into PCMCS daily as dimension members of the vessel dimension. How can i do this without any user involvement.
Highly appreciate your expertise advice on this requirement.