3625701 - unexpected behavior of window function in calculation view with filtering in SAP HANA

• The output obtained from a window function node or rank node in a calculation view differs from the result obtained when performing the same window function operation using SQL.

• When a filter is applied in the SQL query (e.g., "WHERE Column A= 'some value'"), the filter is evaluated before the ranking. Thus no records will be removed after ranking and the ranks will be complete.

• Using variables for filtering instead of input parameters causes the ranking to differ between ranking with SQL and calculation views.

• HANA Cloud Database 
• SAP Business Application Studio

window function, calculation view, sap hana cloud, dense_rank, ranking issue, sql filtering, input parameter, variable filtering, inconsistent ranking, hana cloud services, calculation view execution order , KBA , HAN-CLS-HC , HANA Cloud Services HANA Cloud , HAN-BAS-EDT-MOD , Calculation View Editor in Business Application Studio , Problem