Adding PRDVALID and CUSTVALID attributes in the existing KF calculation which has disagg expression

[Former Member]

Hello Experts,

we have a requirement where we have to PRDVALID & CUSTVALID attributes which are a part of Product and Customer master data contains value X. We are trying to add these attributes in the existing calculation as below so that users would be able to enter and save the values for the products or customers has the validity flag as X.

To achieve this we have added a logic to the existing calculation as below.

Existing calculation: IF(ISNULL( "ZUSBASELINEFINAL @WKPRODLOCCUST" ), "ZUSBASELINEFINALY1 @WKPRODLOCCUST" , "ZUSBASELINEFINAL @WKPRODLOCCUST" )

We have added the attributes to the calculation as below:

IF( "CUSTVALID" = ''X'' AND "PRDVALID" = ''X'', IF(ISNULL( "ZUSBASELINEFINAL@WKPRODLOCCUST" ), "ZUSBASELINEFINALY1@WKPRODLOCCUST" , "ZUSBASELINEFINAL@WKPRODLOCCUST" ) , "ZUSBASELINEFINAL@WKPRODLOCCUST")

But when we remove the validity flag for one Customer ID so I could test entering a forecast at the baseline at sold-to and product to level to see the dissag logic with a ship-to being not valid (blank in the validity field).

Post removal of validity flag – when I refreshed it removed all of the baseline forecast. This is incorrect. Customer ID’s will at times be flagged for deletion in SAP which will update in IBP, we cannot have the key figure data removed when it is flagged for deletion. Please find the attached screenshot of the existing calculation and advise how we can achieve this.

Thanks,

Kisshorezusbaselinefina-calculation.pngvalidity-flag-issue.png

[former_member194529 · Accepted solution]

Hi Kishore,

Were you able to accomplish this requirement? If yes, please feel free to share the approach used.

Best,

Ivan