SAP HANA Calculation VIEW RANK NODE ERROR (GRAPHICAL)

[former_member280546]

Hi Experts,

I am facing a issue while trying to activate a Graphical Calculation View using a RANK node. I have seen that there are many others views in the same SYSTEM that are using RANK.

Bellow is the error:

Repository: Encountered an error in repository runtime extension;Model inconsistency. Incomplete window function in rank nodeRepository: Encountered an error in repository runtime extension;Model inconsistency. Incomplete window function in rank node

Bellow is the RANK definition:

Am I missing anything?

Thanks in advancem

Filipe Rebollo

[BenedictV · Accepted solution]

Hello Filipe,

You need to specify a partition column for ranking. In your case if you just want to pick the record with latest time stamp, then a 'Aggregation node' with MAX(timestamp) should work. If that is what you are trying to do.

But I think you are trying to get the latest time for a process chain, in which case please give the CHAIN_ID field in the partition column (and filter by CHAIN_ID to get the latest time for a chain)

[former_member280546 · Accepted solution]

Perfect Benedict, thanks a lot for your help.