Count Dimension irrespective of Case - SAC

[Former Member]

Hello,

I have a dimension that gives City names for each transaction - the same city could be spelt in CAPS or small letters.

When I create a Calculated field to count number of Cities, it counts such cities twice.

E.g. BHOPAL and bhopal are counted as 2 different cities. How can I get a unique count of cities irrespective of Case?

Thanks.

[N1kh1l · Accepted solution]

Former Member

You can achieve it in 2 steps. First create a calculated dimension to either convert all to Uppercase or Lowercase. In below example I have converted to upper case

UPPERCASE([d/"SAP_CEP_SALES_PLANNING":SAP_CEP_PRODUCT].[p/ID])

Now use this dimension for dimension count and in Report

Output:

For comparison I created the count on original product dimension - Product Count

Hope this helps.

Please upvote/accept if this helps you.

Nikhil

[Former Member · Accepted solution]

thanks! this worked..

[sourabhpaul]

Hi,

For this, you have to use aggregation as count on the dimension.