A way to insert/ update enumeration, enumeration values and enumeration alias using a workflow. | Community
Skip to main content
J
jayeshb_jb
Level 2
December 18, 2019
Solved

A way to insert/ update enumeration, enumeration values and enumeration alias using a workflow.

  • December 18, 2019
  • 2 replies
  • 8085 views

Hello everyone,

 

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/concepts-and-methodology.html#calculating-and-using-aggregates). 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.

 

Regards,

Jayesh

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Milan_Vucetic

Hi Jayesh,

 

possible solution for you can be the following:

  • Instead of using enums, you may create a new table with desired values and link it to the target table using FK link. The new table  may be updated via workflow you mentioned.

If you want to use enum, I think you have to update schema and publish the changes.

 

Regards,

Milan

2 replies

Milan_Vucetic
Milan_VuceticAccepted solution
Level 9
December 18, 2019

Hi Jayesh,

 

possible solution for you can be the following:

  • Instead of using enums, you may create a new table with desired values and link it to the target table using FK link. The new table  may be updated via workflow you mentioned.

If you want to use enum, I think you have to update schema and publish the changes.

 

Regards,

Milan

    J
    jayeshb_jbAuthor
    Level 2
    January 15, 2020

    Hi Milan,

     

    Apologies for the delay in response. Yes, the enumeration type is set to open. I understand that we will have to add the enumeration values manually and these values will reflect in the cube. But in our case, we won't be aware when any new value is added to the column that is used for binning. Thus unless we add the new value manually to enumeration, it won't reflect in the cube. We want to add the new values to enumeration whenever they are inserted into the schema. We tried using workflow and update the values in enumeration schema, but that did not work. Is there any possible solution to do this? Kindly let me know if you want me to explain this use-case in more detail.

     

    Regards,

    Jayesh

    J
    jayeshb_jbAuthor
    Level 2
    March 6, 2020

    Hello everyone,

     

    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.

     

    Regards,

    Jayesh

    Terms & ConditionsAccessibility statement

    Loading footer...