Skip to Content
0

SAP Hana handling Distinct Count on a Formula

Jun 28, 2017 at 03:27 PM

128

avatar image

hana-distinct-counter-error.jpghana-distinct-counter-error.jpg

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,

Parasuram

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers