cancel
Showing results for 
Search instead for 
Did you mean: 

Exception aggregation not count type in reporting

Former Member
0 Kudos

Hi guys,

I have a infocube that contain information of positions and header.

A set of Kpis must be build in the query; but the header kpis have the values duplicates for each infobject's values with the minimal aggregation level. A example follow:

I need a header kpi as:

Max. Duration in a issue that must has aggregation by the issue.

But in the cube is each position for this issue; then the max. duration has a value for each position.

Issue1: 5555

Positions for this issue:

1

2

Max. issue's Durations:

5

5

The value X for max duration is repeat, this is ok because in the cube is aggregated for the positions.

In the query, I am creating a calculated key figures with exception aggregation to the issue; but doesn't working correctly.

Please, I don't know that I am doing bad.

I need your help.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

I am using the exception aggregation option of type average with aggregation to issue.

But the output is the summation of all values for positions.

In the calcelated result as I am putting the average too. But I isn´t doing.

Former Member
0 Kudos

What is the output you get when you use exception aggregation on issue, with aggregation type as say first value or average ?

Also make sure that issue is present in the query output.

Former Member
0 Kudos

Hi,

take a look:

Information about aggregation, cumulation, results row

SAP Note Number: [460255 |https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bw_bex/~form/handler]

Regards

Andreas