Skip to Content
0

Error: SAP DBTech JDBC: [7]: feature not supported: key figure can't be defined without aggregation

Feb 24, 2017 at 06:33 AM

128

avatar image

I have a calculation view created but when I click on data preview after activating the calculation view in SAP HANA the following error is generated: SAP DBTech JDBC: [7]: feature not supported: key figure can't be defined without aggregation

When I opened the SQL editor the final query is:

SELECT "PRODUCT_LINE_ID", "PRODUCT_LINE_DESC", "YEAR", sum("Precentage_Growth") AS "Precentage_Growth",

max("NET_SALES_REVENUE") AS "NET_SALES_REVENUE", sum("PLANNED_REVENUE") AS "PLANNED_REVENUE"

FROM "_SYS_BIC"."GBI_077.B17/ACTUALREVENUE_VS_PLANREVENUE_CV_077" GROUP BY "PRODUCT_LINE_ID", "PRODUCT_LINE_DESC", "YEAR"

where percentage_growth, net_sales_revenue and Planned_revenue are key figures. Can somebody help me on this as I still a beginner in SAP HANA.

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

1 Answer

Abdul Mushfiq Feb 24, 2017 at 11:53 AM
1

check you semantics , have u properly defined your measures and attributes? And also check which column has been defined as key

Share
10 |10000 characters needed characters left characters exceeded