Dis aggregation based on Currency Attribute

[former_member354734]

Hi Experts,

I have a requirement where I want to enter my ASP Value at Sub family level. when it dis aggregates it should copy values only to the combinations where we have Curr as USD. the challenge is i have my Planning objects for multiple currencies. for ex

PRD A, LOC L1 CUST C1 CURR USD

PRD A, LOC L1, CUST C1 ,CURR EUR

some planning objects are only with EUR and many of them have combinations with USD and EUR.

so now when i need to enter a ASP Value at Sub family level i want it to fall only to the combinations with CURR = USD.

How to achieve that? i am currently storing my ASP as Stored ASP KF and in Seperate KF i am writing IF statement that if my Curr ID = USD, then it should be Stored ASP else NULL. in this case only USD in populated but i have some combination with one Planning object with a non USD currency ,this also becomes NULL. I want to write a condition where in if there are 2 planning obj for 1 product for EUR and USD ,value should only fall to USD and not on EUR. but if i have only one entry with EUR then this should get populated with Stored ASP KF.

Can anybody suggest how can i achieve this condition.

Thanks for the help.

Regards,

Hari

[former_member194529]

Hi Hari,

Were you able to accomplish your requirement? If yes, please feel free to share the solution here.

Best,

Ivan