Skip to Content
avatar image
Former Member

SAP Hana handling Distinct Count on a Formula


Hi Experts,

Here is my requirement.

I have two columns "Shipment_number" and "Shipment_Reason" in table.

- Create Calculation View1 for below 3 points.

1. Need to create Distinct Counter on "Shipment_number" which I have done to get the unique count of "Total Shipments Count".

2. Need to create the calculated column "Late Shipments" filtering the "shipment Reason" != 'ON TIME' which I have done.

3. Need to create the Distinct counter on calculated column "Late Shipments" which is unique count of late shipments "Late Shipments Count". This also I have done.

- Created Calculation view2 consuming Calculation View1 to create

"Late Shipments Percentage" for 4th Point.

Issue is on below 4th Point:

4. Now I want to create the calculated column "Late Shipments Percentage" using both the counter calculated columns using below formula

"Late Shipment Count" / "Total Shipments Count".

Now I executed the Data Preview of Calculation View2 and in Analysis tab dropped the Year and Plant dimensions, then dragged and dropped "Late Shipment Count" column and I am getting the error as "Error SAP DBTech JDBC: [2048]: column store error: [34023] Instantiation of calculation model failed;exception 306103: Count distinct on formula is not allowed on any other node except than top aggregation node '$ARG3$' ".

kindly Check and provide your inputs.

Thanks in Advance,


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers