cancel
Showing results for 
Search instead for 
Did you mean: 

HANA Calculation Views and Temporary tables

Former Member
0 Kudos

Is there a way to keep the results provided from a calculation view into a temporary table?

The idea here would be to have a parent calculation view that invokes several children calculation views, keeping their results stored in temp tables so it can be heavily manipulated in the parent calculation views.

When trying to write the results to a temp table I get: "DDL is/are not supported in read-only procedure" I understand that as a view, it cannot write data, but I wonder if there is any other strategy to save a aggregation result so it can me manipulated later on.

Accepted Solutions (0)

Answers (1)

Answers (1)

D039507
Advisor
Advisor
0 Kudos

Hi,

you can try something like this in a procedure:

upsert"SCHEMA"."TABLE"

select a, b,

from VIEW

where .....

groupby .......

end;

Best regards

Thorsten