Skip to Content
0
Former Member
Nov 28, 2006 at 07:52 PM

Problems with Key Figure - SnapShot Inventory

27 Views

I have a problem with the overall results values for the Total Stock Key Figure in the SnapShot cube.

I have changed the definition of the Key figure to:

Aggregation: Summation

Exception Aggr: Last Value

Agr refer char: 0FISCPER

When I build a query which has plant has a characteristic the overall result gives the correct value. However, if I drop Storage Location in the query it takes the value in the last row as the overall result

Is there a reason for this and how can I solve? Thanks

The problem was that I defined the key figure on the query level as last value

Message was edited by:

Niten Shah