My VP asked me to work with my plan number to figure out how to increase and support our sales region. On the planning admin, I created a model and then imported actual and forecasted data. From that, I was able to determine the variance. We managed to plan this with small amounts of data.
We created a planning model and enabled it to make a planning checkmark that works with the time category in the tab dimension, in order to bring it down to the lowest granularity, by month, start date, and end date.
We created an organization dimension. A responsible person to monitor each region is required. Then you can drag and drop the region hierarchy from the parent.
Then, we worked on the calculated numbers, for example, the gross margin, which was the total revenue minus COGS. We then divided that number by total revenue times one hundred. From there, we could pull the data from the file and select source actuality to validate it.
We performed all of this using SAP Analytics Cloud.