We are trying to dynamically add bins to a cube using enumerations (Reference : https://docs.adobe.com/content/help/en/campaign-classic/using/reporting/designing-reports-with-cubes.... What we want to do is when ever there is a new value in a particular column that is used for binning, a bin should be created automatically in the cube. This can be done by using enumerations (refer the about link). But then again we will have to insert the value manually in the enumeration. So is there any way to insert/ update enumeration, enumeration values and enumeration alias using a workflow? I have tried to do it using update activity(on xtk enumeration values schema) and it indicates that the values have been updated/ added once the workflow is finished. But when I check in the enumeration, no changes can be seen. Any suggestion would be helpful.
Just for future reference in case someone else whats to implement the same thing, here is what we did:
So the Enumeration is divided into 3 schemas Enumeration, Value of enumeration and Alias of an enumeration value. Alias of an enumeration value has foreign keys for the other two schemas, while the Value of enumeration has the foreign key of Enumeration schema. So to insert a value in an enumeration we had to update the values as well as the foreign key in the respective schemas so that these values are linked with their corresponding values in other schemas.
To simply state, we updated the Primary key of the Enumeration schema against the foreign key in the Value of enumeration schema. Next, we updated the Primary key of the Enumeration schema and Primary key of Value of enumeration schema against the respective foreign keys in Alias of an enumeration value schema.
Kindly ask if you find this explanation confusing.
Thanks Milan, for pointing us in the right direction.