Skip to Content
avatar image
Former Member

HANA Calculation Views and Temporary tables

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 12, 2017 at 09:35 PM

    Hi,

    you can try something like this in a procedure:

    upsert"SCHEMA"."TABLE"

    select a, b,

    from VIEW

    where .....

    groupby .......

    end;

    Best regards

    Thorsten

    Add comment
    10|10000 characters needed characters exceeded