How to Understand the HANA Generated CalculationScenario

[kirankumar440]

Hi All,

I have below design 

HANA CVs(Ex: CV1,CV2 ) With Input Parameters >> Used as Sources In HANA BW HCPR (EX:CP1) >> Generate External CV for HCPR CP1

The Generated CV ( "_SYS_BIC"."system-local.bw.bw2hana/CP1" with Input Params ) Internally use some generated object as Source which will be in this pattern :  "<Schema-Name>"."0BW:BIA:CP1"  

When I open that object , It has some script which seems to be called as Calculation Scenario.

Questions:
a) How can we under stand that Calculation Scenario Script , As its not SQL.

b) When I use this Generated CV ("system-local.bw.bw2hana/CP1") of CP1  as Source in any further CV , Will that Input Params gets pushed back to the Base CV's ( CV1,CV2 base nodes ) Via CalculationScenario Script ? 

Br

Kiran K

[Savio_Dmello]

The script you're referring to in the generated object (e.g., "<Schema-Name>"."0BW:BIA:CP1") is a Calculation Scenario. Calculation Scenario is the underlying runtime model that SAP HANA uses to represent complex calculations and data flows. When you create a Calculation View in SAP HANA (e.g., CV1 or CV2), what you design graphically in the SAP HANA Modeler or Web IDE is transformed into a Calculation Scenario.These Calculation Scenarios consist of nodes (e.g., aggregation, join, projection) and parameters that define the data flow and computation.

If you need to analyze the execution or logic of a Calculation View, SAP HANA provides tools like PlanViz, which allows you to see how the view is processed at runtime. This visualization helps you understand performance, the data flow, and where calculations are pushed down.

Regarding your 2nd question:

yes, In SAP HANA, input parameters are an integral part of the Calculation View design, and their values are passed along the chain of views and nodes during query execution.

Generated Calculation View (system-local.bw.bw2hana/CP1): This view corresponds to the HCPR (CP1) and includes input parameters that are linked to the underlying HANA CVs (e.g., CV1, CV2).
Input Parameter Propagation. When this generated view is executed (either directly or indirectly via another CV), the input parameters are passed down the hierarchy.
Input parameters from the higher-level Calculation View (CP1) will be propagated to its underlying nodes, which in your case are the base CVs (CV1, CV2).
If the underlying views (CV1, CV2) are designed with input parameters, these parameters will receive the values provided at the higher level (in CP1), enabling parameter-driven filtering, aggregation, or calculations.

[kirankumar440]

Thanks @Savio_Dmello for the response.
Do you mean that IP manage mapping option that we do manually do at Semantic layer of top CV to get them passed to lower CV's is automatically handled by the HANA in that Calculation Scenario of the Generated CV for HCPR ?

As we can not see them Graphically in the Generated CV of HCPR , because the source projection node in that CV would be a CalcScenario "<Schema-Name>"."0BW:BIA:CP1" & Nothing shows under Manage Mapping Section

br

Kiran 

[Savio_Dmello]

Correct. IP is passed by HANA in that Calculation Scenario. It won't show up in manage mapping section