on 01-10-2008 5:44 AM
hi
iam loading a keyfigure from cube to planning area.
the aggreagtion property of kf is min..while loading this kf i gave the grouping condition at sales area , basepack,region ,0fiscper level.where as we have the kf in cube at product,sales area , basepack,region ,0fiscper level.when i checked the kf in planning area it has the aggregated value which i want it to be a min value.
what could be the reason for aggregation.what changes should i do to get the min.
thanks in advance.
Hi Shiva,
It is not possible, APO needs to have congruency between aggregation level so it is not possible to have the min of details in the upper level, You will have always the sum, there is no change.
We had the same problem, so we had necessarily to have the min in another K-F maybe you can repeat it for every detail and then show it with some macro calculation.
Or you can make a new planning area with only the min in a single aggregation level (just a single level of aggregation) by using some ABAP when loading data into the input infocube.
Best regards,
Carlos E. Rodríguez
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.