6.3 Planning Flashcards
customer can use existing BW, S4HANA and BPC with SAC tf
True - they can take a hybrid approach and use them to keep data on prem, and use SAC interface
What can the planning do that analytics model cannot (4)
planning model can also be used for
- sales forecasting,
- budget allocation,
- whatif analysis
- create public, private, shared version of data for planning scenarios
What standard data versions are available? (5)
- Actual
- budget
- planning (goal)
- forecast (expectation for specific timeframe)
- rolling forcast (range for how far back and forward you look)
What planning model preferences can you set (5)
- model description
- default currency
- data audit (track changes)
- privacy (who can access model)
- currency conversion (see model in diff currencies)
planning features (10)
- structured allocations
- currency conversion
- calendar
- input tasks
- data entry
-data actions - data locking
- validation rules
- validation driver trees
- version mgmt
-currency conversion
What is data entry
ability to type relative or absolute values into the table
What happens if you enter data at a higher level on a node
the data will be rolled down to the lowest level.
- you can use the planning panel to adjust proportions between members and move values along multiple dimensions
Data entry - What does it mean where there is a * on a column and it is yellow
data has been changed but not saved
Version mgmt helps carry out tasks like (3)
- variance analysis
- quickly explore, share and publish different scenarios without impacting the original
- roll a private version back to original if you want to change direction
what are Data Actions
model sequences of copy-paste actions, allocation steps and advance formulas. This helps with things like cash flow planning, depreciations,.
how do you build data actions
- build formulas using a visual editor, does not require scripting knowledge.
- but Scripting engine is available
what is a copy data action
-moves data from one part of the model to another, or to a different model
2 ways to make data actions more flexible
- add parameters to be set while designing or running data actions
- run data actions as steps within other data actions, to reuse common calculations
features of data actions (4)
- sequence them
- embed data actions
- schedule/adhoc actions
- add prompts for actions
what is the planning calendar used for (5)
- schedule data actions
- schedule data locking
- keep track of task status
- assign tasks
- set up review tasks: files, approval workflows, and processes that link tasks togetjer
what is predictive forecasting used for
- select a value and calculate the likely outcomes for future periods based on historical data.
- add these predictions to your table
what are features of data locking
- choose sections of data to lock
- sections of data can be assigned to owners who will lock the data, or set so they can only edit
- scheduled the data locks in the calendar
What are validation rules
- let you define who is allowed to change data based on specific dimensions
- let you define who can pass validation based on dimension combinations
- .eg. can only do planning for certain products in certain locations
- can create warnings in stories to guide planners
Why use value driver trees? (7)
- graphical planning simulation
- visualize the entire value chain
- kpi relationships
- driver based planning
- choose any time granularity
- use story calculations
- use dimension formulas
what are input tasks
- when plan needs input from a certain group, you can assign an input task to them
- assign them an area of the model (eg, by region)
Currency conversion features (3)
- apply exchange rate tables to more than 1 model
- can have many rates for different dates, categories of data, specific scenarios
- can review stories for different currencies, exchange rates, compare different scenarios
what are Structures allocations or
to create reusable steps for allocating costs
how do you build structure allocations
- a visual tool doesn’t require scripting expertise and covers range of allocation workflows
- define source and target for each allocation step
- visually configure multiple allocation rules per step, and for each define the specific source elements, allocation driver, and target elements
- execute allocations against a selected version from within the story
what is business content for planning
- import via content network
- get premade models for specific connections (s4hana, IBP)
- some contains data actions and structure allocations
when to use 2-way integration with BPC
- need on-prem planning system, but want cloud-based user experience
- connect BPC data to SAC through a live connection or import/write-back
Does SAC support 2-way integration with SAP Integrated Business Planning
yes - eg, set strategic plan in SAC and export it to SAP IBP to check plan against supply constraints.
Then, bring data back into SAC to make furhter adjustments
Does SAC support 2-way integration with SAP BW
Yes, data is imported via BW queries into SAC, planned on, then exported back to BW
Does SAC support 2-way integration with SAP S4HANA
Yes, data is imported via CDS views into SAC, planned on, then exported back to S4HANA