📋

Description

This error indicates an attempt to use the `CE_CALC` function, which is part of the attribute engine in SAP HANA, directly within an SQLScript context where it is not supported. It typically occurs when developing or migrating calculation views, signaling an incorrect approach to performing calculations within SQLScript procedures or functions.

💬

Error Message

ERR_SQLSCRIPT_CALC_ATTR_NOT_ALLOWED

🔍

Known Causes

4 known causes

⚠️

Direct CE_CALC Use in SQLScript

Attempting to call `CE_CALC` directly within a SQLScript block, procedure, or function, which is an attribute engine function not designed for direct SQLScript consumption.

⚠️

Misuse in Calculation Views

Incorrectly using `CE_CALC` within script-based calculation views or custom SQLScript nodes where SQLScript-native functions should be employed instead.

⚠️

Legacy View Migration Issues

Problems arising during the migration of older SAP HANA views or logic that previously leveraged `CE_CALC` in a context that is no longer supported or recommended in newer HANA versions.

⚠️

Incompatible Function Calls

Trying to combine attribute engine functions like `CE_CALC` with standard SQLScript operations in a way that the SAP HANA database does not permit.

🛠️

Solutions

3 solutions available

1. Refactor Calculation Views Using CE_PROJECTIONS medium

Replace CE_CALC with CE_PROJECTIONS and define calculations in the projection node.

1

Identify the Calculation View causing the error. This typically involves looking at the stack trace or logs associated with the error.

2

Open the Calculation View in the SAP HANA Modeler (e.g., SAP Business Application Studio or Web IDE for SAP HANA).

3

Locate the node where `CE_CALC` is being used. This is usually a graphical node representing a calculation.

4

Replace the `CE_CALC` node with a `CE_PROJECTIONS` node. You can do this by deleting the `CE_CALC` node and adding a new `CE_PROJECTIONS` node.

5

In the `CE_PROJECTIONS` node, define the required calculations using the `DEFINE` clause. This is where you would specify the expressions that were previously in `CE_CALC`.

DEFINE column_name = expression;
DEFINE another_column = another_expression;

6

Connect the preceding node to the new `CE_PROJECTIONS` node and the `CE_PROJECTIONS` node to the subsequent node (or the final output node).

7

Save and activate the modified Calculation View.

8

Redeploy or re-execute the application or process that triggered the error to verify the fix.

2. Leverage Column Views for Complex Calculations advanced

Move complex calculations from Calculation Views to Column Views, which support more advanced SQL expressions.

1

Analyze the Calculation View and identify the specific `CE_CALC` usage that is problematic.

2

Determine if the calculations within `CE_CALC` can be effectively moved to a lower-level data source, ideally a Column View.

3

Create a new Column View in SAP HANA Modeler. This Column View will serve as a replacement or enhancement for the data source used by the problematic Calculation View.

4

In the new Column View, define the necessary calculations directly within its definition. Column Views offer more flexibility for complex SQL expressions.

SELECT
    base_column_1,
    base_column_2,
    (base_column_1 * base_column_2) AS calculated_field_1,
    CASE WHEN condition THEN value1 ELSE value2 END AS calculated_field_2
FROM
    your_base_table_or_view;

5

Modify the original Calculation View to use the newly created Column View as one of its data sources. Remove the `CE_CALC` node and incorporate the calculated fields from the Column View.

6

Save and activate both the new Column View and the modified Calculation View.

7

Test the application or process thoroughly to ensure data integrity and performance.

3. Utilize Analytic Views for Aggregations and Calculations advanced

Consider using Analytic Views for scenarios involving aggregations and more complex business logic where `CE_CALC` might have been used.

1

Identify the Calculation View and the specific `CE_CALC` construct causing the error.

2

Evaluate if the calculations performed by `CE_CALC` are primarily for aggregation or involve complex business logic that aligns with the capabilities of Analytic Views.

3

Create a new Analytic View in SAP HANA Modeler. This Analytic View will encapsulate the logic that was previously attempted with `CE_CALC`.

4

Define measures and attributes within the Analytic View, incorporating the necessary calculations as part of the measure definitions or through calculated attributes.

5

Modify the calling Calculation View (or other consuming objects) to use the newly created Analytic View instead of the problematic Calculation View or its internal `CE_CALC` logic.

6

Save and activate the Analytic View and any modified consuming objects.

7

Conduct comprehensive testing to confirm the correctness of the calculations and the overall application behavior.

🔗

Related Errors

5 related errors

SAP S/4HANA Error 1322: CE_CALC Not Allowed in SQLScript