Skip to Content
avatar image
Former Member

Unable to obtain proper aggregation with calculation view .

dfkkop-withoutkey-withoutkey-v1-xml.xml

Hello Experts,

I have a scenario , where the source is a details table DFKKOP.The fields under study are MADNT, GPART,VKONT, AUGDT,FAEDN and filters applied on AUGRD and BLART.

The Columns AUGDT(clearing date) and FAEDN(due date ) are storing date.We are extracting the date part from AUGDT (i.e 15 from 20150101 or 15 Jan 2015) say CC_CD.

For every similar the combination of (MADNT, GPART,VKONT, AUGDT,FAEDN

) is considered as a single record.And frequency of CC_CD need to be obtained . And the corresponding record with maximum frequency needs to be the output .

The final node contains

MADNT, GPART,VKONT, CC_CD(whose frequency is maximum).

The screenshot I am sharing is of calculation view of type Blank (final node as projection ) but the same has been tried with cube and dimension as well .data.jpgaggregation-1.jpgdata.jpgexpected-datase.jpgaggregation-2.jpgdata.jpgprojection-final-node.jpgdata2finalprojection.jpg

Problem faced .

Whenever I am trying to aggregate the records on base of

MADNT, GPART,VKONT, AUGDT,FAEDN , CC_CD , the aggregation provided correct frequency . But when I remove the columns

AUGDT,FAEDN in the subsequent level I get the frequency(COUNT) as 1 for CC_CD.

I have tried the changing the view type from CUBE , DIMENSION , BLANK .But still I am unable to get the perfect result .

I have checked by setting the KEEP FLAG once as well as unsettling the KEEP flag, But both times the result projected is same .

I sense that in the aggregation nodes all columns present in the table , even if they are not selected are taking part in the aggregation . Which I certainly dont want .

I am attaching the screen shots and data preview at each node for reference .Can you experts please highlight if I am missing anything which is causing the aggregation error .

The DB version is

1.00.122.07.1486663129

Studio Version: 2.3.13

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers