on 10-18-2008 3:26 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
13 | |
13 | |
11 | |
10 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.