Skip to Content
0
Former Member
Dec 02, 2006 at 05:34 PM

Group Inventory Cube

22 Views

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