Allocations in SAP Analytics Cloud

[#1]

Hello Experts,

I have a question regarding allocations in SAC and need your expertise. I am able to accomplish the below in Allocations by specifying the rules like the below screenshot. My problem is there are many territories and listing all of them is counterproductive. Is there a way I can use properties in allocation? What is the best way to accomplish below.

Thanks,

Vamshi

[ScottGodfree]

Hi Vamshi,

This might depend some what on how are you planning to enter the data in red? Natively you cannot enter this and store it to a parent.

Are you actually trying to run an allocation, or you want to plan a number at an aggregate level and have it disaggregate to the leaves based on the actuals ratio? If it's the latter, then I would suggest simply seeding the Plan version with the Actuals (or a scale set of the actuals prior to having the users enter the aggregate values).

Thanks,

Scott

[vamshib01]

Scott,

I aggregated the values in Red that are at different Product group and outlet level to the Territory Level and a dummy Product member using a script in data action as a first step. So initially the value of the first red value was 60 (10+20+30).

If the user then modifies this number to 100, I want to disaggregate to outlet and product group level based on the actuals ratio. How can I achieve this using Advanced script?

I agree that I could have simply copied Actuals to Plan and then made the change, but I am trying the above scenario out. How can I do this?

Thanks,

Vamshi