Skip to Content
0
Apr 09, 2014 at 09:49 AM

HANA Views

91 Views

Hello Colleagues,

I would like to know if someone could help me out here.

We have a table containing financial written-off amounts, i.e. from bills for which the company will never receive payments.

Lets say the table looks like this:

CLIENT CompCode Date Amount Currency 090 0001 20140120 10 EUR 090 0001 20140123 20 EUR 090 0001 20140201 40 EUR 090 0001 20140203 20 EUR 090 0001 20140205 30 EUR

I want to produce the sum amounts grouped by week numbers, i.e. from the above data I would like to create a View (Calculation/Analytical...) which returns the values 30 (first 2 dates belong to week 4), 40 (week 5) and 50 (week 6).

I thought that I could perhaps produce use a calculated column to convert the 'Date' values to calendar week integers (similar to select week(date) from myTable ) but the week function is not one that is available in the 'Expression Editor' within the view creation module.

The goal is to produce a chart displaying the week numbers with columns representing the written-off sums for each week.

We have already done this using an OData Service (implementing the GET_ENTITYSET method of the generated class) and a DDL view in the ABAP layer and then programming a SAPUI5 application to display the data.

We would now like to see how much effort is involved in producing the same application via the KPI Modeler and Smart Business applications.

Any insight would be helpful.

Kind regards,

Keith Sanderson

Amount