Skip to Content
0
Former Member
Oct 25, 2005 at 01:44 PM

Key figure and Exception aggregat options

19 Views

I define a key figure with Exception aggregat option „Average (all values)” and agg.referen.char. „PSOBSZAR”. But BW still generate query as:

  • QUERY STATEMENT IN OPEN-SQL

*

  • SELECT

SELECT

DT~SID_0CALWEEK AS S____122

D1~SID_PSOBSZAR AS S____229

D1~SID_PSREGION AS S____230

COUNT( * ) AS 1ROWCOUNT

SUM( F~/BIC/PSSSKUPUM ) AS PSSSKUPUM

  • FROM

FROM

/BIC/FPSCAUDYT AS F

JOIN

/BIC/DPSCAUDYTT AS DT

ON

F~KEY_PSCAUDYTT

= DT~DIMID

JOIN

/BIC/DPSCAUDYT1 AS D1

ON

F~KEY_PSCAUDYT1

= D1~DIMID

JOIN

/BIC/DPSCAUDYTP AS DP

ON

F~KEY_PSCAUDYTP

= DP~DIMID

  • WHERE

WHERE

( ( ( (

DP~SID_0RECORDTP

= 0

) ) AND ( (

DP~SID_0REQUID

<= 850

) ) ) )

  • GROUP BY

GROUP BY

DT~SID_0CALWEEK

D1~SID_PSOBSZAR

D1~SID_PSREGION

  • DB-SPECIFIC HINTS

&SUBSTITUTE LITERALS&

I want to get query with avg function instead of sum function. Can anybody help me? Did I should reference another characteristic or something?