In my query based on InfoCube I got 3 characteristics:
Planning Date
Date
Planning Level
and one Key figure
Planned amount
For every Planning Level on every Date there can be several plannings done on different Planning Dates. In my query I need to show only the LAST planned amount. I've done it by creating Calculated Key Figure "Last planned Amount" with Exception Aggregation "Last Value" and Reference Characteristic Planning Date. But somehow the query doesn't work the way I need it. I got wrong totals by Date. My totals by Date doesn't sum all forecasts (see picture at http://www.ljplus.ru/img4/s/o/sokol_jasnyj/2---detailed-view.jpg) inculding only those, that are done on last date before the Date. In my query I need 48.573 LTL sum, not the 42.785 LTL