Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 24, 2017 at 11:53 AM

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

    Add comment
    10|10000 characters needed characters exceeded