Skip to Content
-1

how to run calculation view

Hi Everyone,

We have one requirement where we have to extract ECC tables in HANA studio and further creation of calculation view. we are open with both option BODS and SLT provisioning method.

i want to understand how calculation view will trigger via any job.

Scenario 1- If i am extracting ECC tables using BODS and by scheduling batch job i can receive tables in schema in HANA studio.now i have created calculation view (not sql / table function/ HDB procedures) Is there any way to create a job that will trigger calculation views to populate data on report.

Scenario 2- how we can achieve the same requirement with SLT provisioning when we start receiving real time data in HANA studio.

Thanks,

Ashutosh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 22 at 09:51 AM

    Hi ASHUTOSH SHRIVASTAVA

    The result of calculation view is computed on demand. So generally there is no need to run it as a background job. Just write sql to it and select from it.

    If it is really slow and even experts cannot optimise it more. You can use cache feature of calculation view.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 22 at 02:03 PM

    Hi Ashutosh

    HANA Studio is HANA Database accessing Client tool , data is not stored in HANA Studio but in HANA Server in HANA Database.

    BODS/SLT are going to be your ETL tool to extract data from Data Source which ERP in your case, I assume your Calculation views that you will model would be based on top of those ECC mirror SAP HANA tables. BODS/SLT can manage to extract full/delta data load into your SAP HANA tables. Your calculation view is built on top of these HANA Tables for your further transformation of your data such as aggregation. These Calculations views are then fed into Composite provider and your AFO report is created on Bex query created on top of composite provider or you can use that calculation view directly for AFO report creation. This is case of AFO report.

    As Calculation View is consumed by Report it would automatically get triggered to show the desired/transformed data into report.

    Add comment
    10|10000 characters needed characters exceeded