Hi All,
I have an enumeration in a table. There are multiple entry for the different enumerations in the table. Now i want to get the count of record for each enumeration values in a workflow. But I am facing issue in the group by clause where I must add primary key in the group by condition. bt that defeats the purpose as primary key is unique.
Please Suggest.
Happy Campaigning,
Sumit
Solved! Go to Solution.
Hi Sumit,
You need to 'Disable automatic adding of the primary keys of the targeting dimension'.
I have created an example counting the number of residents of each city in the data mart:
Here is the result:
Let me know if this is what you are trying to do.
Linda
Hi Sumit,
You need to 'Disable automatic adding of the primary keys of the targeting dimension'.
I have created an example counting the number of residents of each city in the data mart:
Here is the result:
Let me know if this is what you are trying to do.
Linda
Linda,
Thanks for the update. But I actually figured removing the primary key functionality in a query activity.
But again thanks for the resolution.
Regards
Sumit
Views
Replies
Total Likes