Skip to Content
-1

how to run calculation view

Jan 22 at 07:53 AM

86

avatar image

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

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

2 Answers

Steve Guo
Jan 22 at 09:51 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
ANIRUDDHA SHINDE Jan 22 at 02:03 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded