how to create a counter measure in SAP HANA Calculation view ?

[former_member195433]

hi,

I have created a "counter" for distinct count on column1,column2 & column3 at aggregation node. (cm_count_total)

and i am trying to create another restricted measure on cm_count_total ( where "BRAND_APR_STATUS" = 'Withdrawn') > i have used Restricted measure at aggregation node with no luck and i have tried to create another Calculated column using the below formula with no luck

if ("BRAND_APR_STATUS" = 'Withdrawn',"cm_count_total",0)

Can you help me how can i achieve another measure to get results as below (annotated in red)

[former_member607745 · Accepted solution]

Hi Promod,I think it is not allowed to consume counter in expression in calculated or restricted measures.However you can create a calculated column of type Integer and try to put expression : if ("BRAND_APR_STATUS" = 'Withdrawn',1,0).

[p244500]

Hi Promod,

You can create counters for multiple attribute columns at a time. For example, if you create a counter for two columns, the counter displays the count of distinct combinations of both columns.

Procedure

1. Open the required calculation view in the view editor.
2. Select the default aggregation node or the star join node.Note You can create counters for attribute columns in the default aggregation node or star join node only.
3. In the editor toolbar, choose (Expand Details Panel).
4. In the Calculated Columns tab, choose (Add) and select the Counter menu option.
5. Define the counter.
   1. Select and expand the new counter.
   2. In the General section, provide a name and description for the new counter.
   3. If you want to hide the counter for data preview, select Hidden.
   4. In the Counter section, choose + (Add).
   5. In the value help list, choose an attribute column.

https://help.sap.com/viewer/3746eb56b77943b699df025ab2bc7552/Cloud/en-US/6a8ed77c21964031aa05849d63b...

Regards,

Nawa