Create Analytical View to show MAX value of VARCHAR field

[f_geldof2]

Dear HANA Guru's

I am making my first steps in HANA studio coming from BW background. Now i am facing a business requirement to show only the columns of a field where a certain VARCHAR field has the maximum value.

The table is simplified in below example:

Material	Code	Season
ABC	201601	Spring 2016
ABC	201501	Spring 2015

The information i would like to combine with my regular material master to show the MAX Code of the material in the overview as shown below:

Material	Division	Season
ABC	01	Spring 2016

I have tried to create a intermediate Analytical view only showing the MAX code but don't seem to succeed. I try to use the standard objects as much as possible (not try to use SQL script)

I tried to create a view with aggregation and using Max on this field making it a measure. Unfortunately the output of the view is still showing both codes and not the MAX code.

What is best practice in this case?

Thanks in advance for your comments.

Best regards,

F. Geldof

[anindya_bose · Accepted solution]

Hi Freek

Did you try Rank node in Graphical Calculation view ?

It should be working for you .

Link below would give you detail

Cheers

Anindya

[f_geldof2 · Accepted solution]

Hi Anindya,

Great ! That worked perfect, exactly what I needed.

Thanks! Below is the example that I have created.