Require the of different value in a table

[#1]

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

[#2 · Accepted 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

[#3]

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