Skip to Content

SAP HANA Calculation VIEW RANK NODE ERROR (GRAPHICAL)

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

rank.png (25.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 10, 2017 at 07:58 PM

    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)

    Add comment
    10|10000 characters needed characters exceeded