cancel
Showing results for 
Search instead for 
Did you mean: 

SAP IBP DISAGG Operator using Attribute selection

0 Kudos
661

Friends,

We have a situation for our demand planning KFs which are at aggregated Level (Product Class), will get disaggregated to SKU Level using a Disaggregate expression which is working fine.

The requirement we have is out of 100 SKU under product class, user will define a attribute in LOCPROD for which DISAGG should not be done, lets say for some 10 SKU..

Current Scenario: 5000 Qty at Class Level will get Disagg to all 100 SKU by 50 each

Requirement: 5 SKU out of 100 will be marked as Lets say NA in some Attribute in LOCPROD Demand Planning Exclusion = NA, expectation is 5000 should get divided to 95 SKU with 52.63 each, and for those 5 SKU DisAGG should not add any value.

What I have done is in COPY_DISAGG Operator, I have added Attributes values Demand Planning Exclusion <> NA.

When I run Redisagg Operator, its not respecting above criteria... Should I write this in KF Disaggregation Logic Itself, can you please guide?

View Entire Topic
AyanBishnu
Active Contributor

Hi Guru

What you want to achieve can be done by modifying the exisitng dissagg expression that you are already using. Since you havent shared the screenshot of the expression and assuming that the present expression is working fine, all you need to do is to add an additional logic as below.

Lets say you have created a new attribute (e.g PRODSTATUS) where user maintained a value of I ( meaning inactive) for SKU where they dont want the values to be dissaggregated. So your modified expression would be as follows

IF("PRODSTATUS" <> I, "<your existing expression>", NULL)

Hope it helps