I searched for achieving the rank functionality in SAP DWC in Graphical model but seems there is no rank node available just like we have in HANA. I tried scripted view where I could not get proper syntax to implement the Rank functionality .
note : I did change the language to SQL Script ( Table Function)