I have the following scenario
1) Group Level Cube which is loaded from underlying an cube and 2 ODS, one is the snapshot ODS similar to has described in the How to guide
2) The Group level cube has the characteristics Material, Storage Location, Plant and Sold_To customer. All four of these characteristics (along with other characteristics) exist in all of the 3 sources
3) I have a total stock key figure in my group cube
4) In each of the three update rules to the Group cube I am carrying out a one to one mapping between the Total Stock key figure and each underlying specific total stock figure
I would expect that when I display this key figure it would show the sum of the three underlying values. This is not the case, why is this and how can I overcome?
All Key Figures have Exception Aggregation as LAS VALUE and Aggr. ref char is Fiscal Period.
Can someone assist with this one?
Thanks
Message was edited by:
Niten Shah