Skip to Content
0

hana model view to do a minimum on a sum - aggregations

Mar 16, 2017 at 05:06 PM

35

avatar image

dear all

i am trying to sum a few records, then perform a minimum on the sum, and it just wont work.

here is my table of data

Instance	Host	Epoch	Day		FP
BP5		a	1	2016-02-03	11
BP5		b	1	2016-02-03	86 		
BP5		c	1	2016-02-03	69


BP5		a	2	2016-02-03	42
BP5		b	2	2016-02-03	55 		
BP5		c	2	2016-02-03	33


BP5		a	3	2016-02-03	78
BP5		b	3	2016-02-03	24		
BP5		c	3	2016-02-03	97

as you can see, they are split into Hosts are split with Epoch.

Instance and Day are just here in the example.

Epoch 1 sums as 166, Epoch 2 sums as 130, and Epoch 3 sums as 199 as below

2016-02-03 1 BP5 166
2016-02-03 2 BP5 130
2016-02-03 3 BP5 199

next i want to get the minimum which is record 2, ending in 130

something like this

2016-02-03 BP5 130

and most of all, i wish to do it in a Calculation view (or two), but i just cannot get the aggregation, node types, or whatever, right, and does not return 130.

this can be done using an hdbtablefunction, i know, but surely a graphical calculation view should be able to do this

any help or pointers would be great.

thanks in advanced


                
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers