Skip to Content
0
Former Member
Mar 04, 2010 at 04:34 PM

Disaggregation in DP

70 Views

Hi

We are on SCM 5.0

My user wants to add data to a single KF at one location at higher level.

(We have many levels like Product, Customer, Location,.)

When he is adding the data in location level in one column, its not disaggregating to the existing proportions. (The KF is type I. So rt now, it should disaggregate by Pro Rata than looking at other KF for Prop Factors). Its not disaggregating in right way to customer and Product level. He is ensuring by opening up all Products and copying, it works fine with product data. but when we drill down by customer, its not doing the right disaggregation as per existing customer proportions.

How to solve this issue. I can't run a macro, as the data added is very manual. Macro can only copy from 1 KF to other(as per my knowledge). I never tried macros with functions like AGGR, etc..

Any help pls ?

thanks

venkat