Skip to Content
0

SAP HANA Calculation VIEW RANK NODE ERROR (GRAPHICAL)

Mar 10, 2017 at 05:31 PM

297

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Mar 10, 2017 at 07:58 PM
1

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)

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Perfect Benedict, thanks a lot for your help.

1