Skip to Content
0
Oct 14, 2013 at 12:04 PM

Dynamic characteristic based on keyfigure-aggregate (KF-classification)

44 Views

Hi experts,

I'm facing the following request:

A report is needed, which shows (e.g.) invoices.

The invoices shall be groupable based on the quantity stored in the position-items (refering to that invoice).

The selection shall allow position-characteristics to be filtered.

An example:

The following records exist on the database:

Invoice PosNr Material QTY

900 10 4711 30

900 20 4712 50

901 10 4711 60

901 20 4712 20

902 10 4711 10

The report-drill-down should look like this (without setting any filters):

QtyGroup #Invoices

00 - 20 1 (reading: There's 1 invoice with a total-qty between 0 and 20)

21 - 40 0

41 - 60 0

61 - 100 2 (reading: There're 2 invices with a total-qty between 61 and 100

The report-drill-down should look like this if the user selects matnr 4711 only:

QtyGroup #Invoices

00 - 20 1 (reading: There's 1 invocice which has a total-qty bt. 0 and 20, regarding the filtered positions)

21 - 40 1

41 - 60 1

61 - 100 0

As you can see the groups are dependant from the user's filter, hence they cannot be
precalulated on the database at the moment of data-loading.

Furthermore virtial characteristics imho cannot be used, since they work only on a - per-record - basis,

but cannot loop over the whole result-information to build the needed aggregates for the group-assignment.

So, does anybody have an idea how to solve such "classification"/"grouping"-problems?