Hi,
We have multiprovider which contains sales, intransit, orders and demand. We have report called Inventory report on top of that multiprovider with all the key figures from all the underlying cubes and also the key figure attributes of material and material location as formula variables with replacement path. In the report when the inventory only available, the report does not give the values for formula variable and when the inventory is coming along with any other key figure values, then in that records the formula variable works.
I was observing some SAP notes on the service pack level for non cumulative key figures to work with formula variable and there seems to be some restrictions. We have this development on APO BW box and the bw service pack level is 9 and we are on BI7.
So in our scenario all the inventory snapshot from R/3 and also from international locations(using flat files) is coming to a DSO and from there moving to a cube. Now inventory being a non cumulative value the report is not working. Can we design stock as CUMULATIVE key figure? If so how can we do this?
Regards
Vijay