Hello Experts,
This is a weird limitation, where we cannot segment the customers based on Opt out or customers who doesn't have any subscriptions.
When i saw the view - CA_D_IC_NEWSLETTER_SUBSCRIPTION, there was a filter on the subscription. I am unsure why it has been build like that.
But what i have done is - I have updated the custom view by removing the filter and try to upload the view in SMC, now i am getting the error as - Key field DB_KEY of CUAND_CE_IC_ROOT, INTERACTIONCONTACTUUID, PARENT_KEY of CUAND_CE_IC_FCET or CUAND_CE_IC_RE, CONTACT_KEY of CUAND_CE_IA_RT, ROOT_KEY of CUAND_CE_IC_FT_D is not part of the view;Import not possible,chec
I was aware that this is applicable for calculation view(CUBE), but since the view - CA_D_IC_NEWSLETTER_SUBSCRIPTION is a dimension view, i am not sure why the message is popping up.
Regardless to above, i want to know how i can resolve the above error or how can I meet the requirement using standard behaviour. anyone can assist or done a similar thing please let me know.