Skip to Content
avatar image
Former Member

Exception aggregation not count type in reporting

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 20, 2008 at 05:08 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 11:15 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 01:07 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded