Question Re: Data Action - Allocation in Technology Q&A

Data Action - Allocation

Alebarba — Fri, 21 Jun 2024 10:55:15 GMT

In the planning model I created a data action that allocates the quantities to the forecast in relation to the quantity ordered. Once the allocation has been carried out, I would like a new data action that allocates only the forecast quantities lower than 1000 TON to the other forecast quantities. it's possible?

Thanks

Re: Data Action - Allocation

William_Yu1 — Sat, 22 Jun 2024 04:28:12 GMT

Hi Alebarba,

Though you might not able to directly put a value based filter for allocation step, but you may try this:

After the initial allocation step, you can create an advance formula step to move value under 1000 to a dummy member of any dimension.
have a second allocation step to allocation the value from dummy member.

Best regards, William

Re: Data Action - Allocation

Alebarba — Tue, 25 Jun 2024 06:04:49 GMT

Thanks William, Best regards