SAP DATA WAREHOUSE CLOUD COMMUNITY

This is your platform to ask questions, post answers and share your experience with other customers and experts from SAP.

Issue with SQL View

harikrishnansharikrishnans BI Solutions DeveloperIndia

When I tried to incorporate Rank() window function in SQL view, the rank() function of SQL Statement is automatically getting truncated and throws the following exception. Is there a limitation for certain SQL functions in views.

SQL Statement as given in the help page,


SELECT ProdName, Type, Sales,
RANK() OVER ( PARTITION BY ProdName ORDER BY Sales DESC ) AS Rank
FROM ProductSales
ORDER BY ProdName, Type;


Thanks and Regards,

Hari

Answers

Sign In or Register to comment.