| Analytics , SAP Analytics Cloud ,
Budgeting and Forecasting is an integral part of any business. Often while forecasting values, we would have several questions like – what will happen to my sales if I add a 30% discount during this time of the year or what if the growth rate increases by x% instead of y% etc. etc. This is where SAP Analytics Cloud’s new feature, Value Driver Trees (VDT) comes into play. In literal sense, a Value Driver Tree simulates how a particular value can drive or impact the rest of the values in the tree.
Value Driver Trees have 4 type of nodes – Data Source Nodes (the actual values), YOY Nodes (year-over-year values including forecasted values), Union Nodes (unites or combines the data source nodes), and Simple Calculation Nodes (to perform basic arithmetic calculations).
We have tried to create a simple VDT with 3 nodes and consume it in a story to forecast sales figures. We have included the steps we followed below:
*Data Source Node: this is used if the node has to display the values directly from the Data source (No Dependency on VDT)
*Union Node: This node gives the union of values from all the linked nodes.
This enables planning for the future dates as well. Value Driver Trees allow us to explore different scenarios and project possible outcomes which in turn help businesses make more informed decisions.
Setting up High availability for SAP Cloud Connector – 2.12
Dynamically Switching Dimensions in Power BI using DAX
Tableau vs. Power BI vs. Looker – Which tool is better for your Business?
Creating Certificate Using OpenSSL and Importing it into SAP HANA Web Dispatcher