Skip to Content
0

HANA Calculation Views and Temporary tables

Dec 12, 2017 at 02:41 PM

89

avatar image
Former Member

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.

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

1 Answer

avatar image
Former Member
Dec 12, 2017 at 09:35 PM
0

Hi,

you can try something like this in a procedure:

upsert"SCHEMA"."TABLE"

select a, b,

from VIEW

where .....

groupby .......

end;

Best regards

Thorsten

Share
10 |10000 characters needed characters left characters exceeded