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?