Pre-Sort data via View

[Former Member]

Hi folks,

I want to create a view where the output is already sortet. In my case I need the data prepared in a sorted manner for Predictive Analysis using HANA Online scenario.

So is it possible to create a view where I can sort the data upfront??

Cheers, Christoph.

[lbreddemann · Accepted solution]

Hi Christoph,

that's possible in a straight-forward way.

Create a calculation view on top of your information model, that consists of a SELECT with the required ORDER BY clause.

- Lars

[Former Member · Accepted solution]

Hi Lars, thanks for your reply. That means, I need to build a select statement on a table with order by and an calculation view on top? How do I persist the SQL statement thou?

Regards, Christoph.

[former_member184768 · Accepted solution]

Hi Christoph,

I guess what Lars meant is, to build a SQL script based Calc view on top of your Analytic model with ORDER BY clause in it.

If the data to be analyzed is available in table and not coming from HANA Information model, then you can build a SQL script based Calc view with SELECT statement on the table with the required ORDER BY clause.

Regards,

Ravi

[Former Member · Accepted solution]

Thanks Ravi!