C_SACP_2302

Which of the following can you use to create an SAP Analytics Cloud planning model?. Story. Analytic Application. File. Datasource. Model.

You are planning in a new model type sourced from S/4HANA with currency enabled. The model contains a local currency measure and a group currency measure. What happens when you enter local currency values on a plan version?. The group currency is translated based on the S/4HANA currency table. The group currency is translated based on the SAP Analytics Cloud currency table. The group currency in SAP Analytics Cloud stays the same.

What node types can be imported from S/4HANA?. T. R. H. L. N.

In a story table cell, you want to change the value from 500 to 450. What can you enter to achieve this?. -50. 90%. -10%. +-50.

In an analytic application you want to use a data action trigger. Your customer complains that the data action trigger pushbutton is too large. How can you address this complaint?. Add a cascading style sheet to the data action trigger. Resize the data action trigger in the builder pane. Use a button to run a data action.

You want to create a copy data action that allows you to select the source and target values for the following dimensions at run time: Version. Account. Time. What do you specify for each of these dimensions?. Source and target parameters for version, account, and time in the copy rules. Source and target parameters for version in the filter. Source version parameter in the filter. Source and target parameters for account and time in the copy rules. No Filter. Source and target parameters for version, account, and time in the copy rules.

Which of the following actions on the date dimension are available in Value Driver Trees?. Select the day granularity. Specify a presentation date range. Change the date filter for an individual node within the Value Driver Tree. Change the date filter for the entire Value Driver Tree.

What validation rule types are supported by SAP Analytics Cloud?. Attribute. Member. User exit. Hierarchy.

For which of the following are value driver trees available?. Planning models. Live models. Analytic models. Datasets.

You need to copy data between versions for a group of customers. For privacy reasons, you want the results to be copied to an unassigned customer. Where do you specify this in your data action?. Filters. Copy rules. Aggregate to. Context.

Where can you enter data into an SAP Analytics Cloud model?. In the SAP HANA studio. In the SAP Analytics Cloud mobile app. In an analytic application. In a story.

Which account types allow you to display database values with the opposite sign in stories?. EXP. INC. AST. LEQ.

In SAP Analytics Cloud, where can you apply data security?. SAP Identity Management. Dimension properties. Analysis authorizations.

When you enable currency translation for a planning model with an account dimension, which object is added to the model automatically?. Currency property. Rate type property. Currency dimension.

Where can you run data actions?. Analytical application. Planning process. SAP Analytics Cloud calendar. Planning sequence.

In SAP Analytics Cloud, where can you apply data security?. Analysis Authorizations. Model. Property. SAP Identity Management.

Which of the following are features of an Embedded Data Action step?. Nest data actions. Combine data actions of different models. Link parameters of data actions. Create cyclical references of data actions.

How can you translate local currency to another currency with a classic planning model?. Create a data action with a currency conversion step. Create a model conversion measure. Create conversion measures in the story.

What are some characteristics of popups in analytic applications?. Scripting can be assigned to buttons in the popup. Popups have a scripting event on Initialization. Popups can be copied to stories. Drop downs in the popup are only displayed when needed.

Your account dimension has an account for Profit that is calculated as [Revenue] - [Cost]. Which formula can you use to enter a value for Profit and have the system re-calculate Cost while Revenue remains constant?. [Revenue] - [Cost] := INVERSE ([Cost] = [Revenue] -[Profit]). [Revenue] - [Cost] | INVERSE ([Cost] = [Revenue] -[Profit]). [Revenue] - [Cost] := (INVERSE [Cost] := [Revenue] -[Profit]). [Revenue] - [Cost] | INVERSE ([Cost] := [Revenue] -[Profit]).

What master data can you update during the import of transaction data into an SAP Analytics Cloud planning model with private and public dimensions?. Hierarchies for public dimensions. Property values for private dimensions. Property values for public dimensions.

Why would you decide to use an Analytic Application instead of a Story?. To have fewer data action triggers. To do form-based data input. To use advanced data actions. To use data cell comments.

In the visual editor for advanced formulas, which of the following formula options can you select?. Comment. Repeat. Lookup. Round.

When you delete a planning model, what dimension types are always deleted?. Organization. Version. Time. Account.

You have a New Model that only contains local currency values. When the New Model is used in stories, you need model-configured group currency values that are not stored in the database. What type of measure would you include in the New Model to meet the requirement?. Restricted. Calculated. Conversion.

What dimension types can be used to determine currencies?. Organization. Date. Account. Generic.

When importing data, why would you use a New Model instead of a Classic Model?. To change data types. To import multiple versions. To combine data from multiple sources. To define link dimensions.

You have a planning model with the following dimensions: Cost Center, Account, Date, Entity, Version. When you add new transactional data to your model, you want to overwrite any records with cost center A and add new data for cost center B. Which import method do you use?. Update. Merge. Overwrite. Append.

Which activities can be scheduled from the calendar in SAP Analytics Cloud?. Data locking. Create input form. Data action. Publish stories.

You have an SAP Analytics Cloud BI license. What can you do with a value driver tree (VDT)?. Change data on a VDT. Create a VDT from a planning process. Publish data with a VDT. Create a VDT directly within a story.

What can you do in an analytics application?. Trigger input tasks. Read data from write-back models. Enter form-based comments.

What can you do with a data action trigger in an analytic application?. Use the onAfterExecute event. Use the onBeforeExecute event. Execute the data action trigger at design time. Execute the data action trigger at runtime.

In an analytic application, which element can you enter comments for?. Data cells in a table. Data points in a chart. Dimension members in a table.

How can you change plan data via the Planning Panel in a story?. Redistribute values among date members. Realign values based on properties. Repost the values to a higher level of the hierarchy. Distribute values based on recommendations.

Which work files can you access when you run a planning process?. Workbook. Analytic application. URL link. Dashboard.

What can you use to publish the result of a predictive forecast in a planning model?. Table. Line chart. Smart Predict model. Time series chart.

You are importing from SAP S/4HANA into a planning model with pre-converted actuals turned on. What mappings are required to import both local and default currency?. Two measures. Two currencies. Two Accounts. Two currency types.

What are the pillars of SAP Analytics Cloud?. Data Warehousing. Predictive. Planning. Blockchain Management. Business Intelligence.

You enter the following code into the formula script editor: MEMBERSET[d/Account]= What does the auto-complete feature return?. Parameters. Members. Properties. Hierarchies.

Which of the following dimension types supports multiple hierarchies?. Version. Time. Organization. Account.

You want to create an input task using a story based on a planning model. What are prerequisites for this scenario?. The model is shared. The model has a private version. The story is shared. The model contains private dimensions.

What can you use to restrict input in a story based on nested conditions?. Advanced filtering. Validation rules. Data locking.

You need a hierarchy that is based both on the region and the country column in the same dimension. What hierarchy type can you use?. Parent-child. Table-based. Level-based.

You want to rebuild an SAP Analytics Cloud classic planning model but the Rebuild Model button is inactive. Why might this happen?. A public version is used in the model. A private version is used in the model. Data exists in the model. Currency conversion is enabled.

Which planning version type can you share with a co-worker from within a story?. Plan. Private. Public.

When you import data into a classic planning model, what can you do with category and version in data management?. Use an existing category. Create a new Category. Create a new Private Version. Use an existing Version. Create a new Public Version.

You are running a predictive forecast. What could the data lines represent in the preview?. Line 1 is input data. Line 1 is forecast data. Line 2 is input data. Line 2 is forecast data.

You are using the planning panel to distribute values. Which of the following driver options can you select?. Equal. Append. Overwrite. Proportionate. User defined.

Where can you schedule an import into an SAP Analytics Cloud model?. SAP Analytics Cloud calendar. Data action monitor. SAP BW process chain. Data management.

Which scenarios can you implement using SAP Analytics Cloud advanced formulas?. Eliminate inter company transactions in real-time. Aggregate dimension members. Calculate depreciation. Forecast HR turnover rates using machine learning.

You are working on a flat file-based planning model. You want to prevent manual data entry for certain data intersections. What options do you have?. Work status locks. Cell locks. Dataslice locks. Data locks.

When you set up a copy data action, what must you do to allow the user to select the source version?. Add a copy rule for the version. Add an aggregate for the version. Add a parameter to the filter.

In SAP Analytics Cloud Smart Predict, how can you use versions with a planning model?. Save the forecast to public version. Train the model with in-process public data. Save the forecast to a private version. Train the model with completed public data.

When setting up data wrangling to import data, which functions can be used in calculated columns?. RESTRICT. CONTAIN. LOOKUP. DATEDIFF. TRIM.

You have an allocation process with 3 steps. Which of the following can be used to run only allocation step #2?. Data Action. Story Taskbar. Allocation button.

Which dimension types support the system-generated Person Responsible property?. Organization. Generic. Account. Version.

What can you do with Smart Predict but not with table-based predictive forecast?. Add dimensions to identify entities. Add influencers. Select the algorithm. Define number of forecast periods.

In a story, how can you create a chart to compare versions?. Add a 'difference from' measure. Add a new member with a formula. Add a chart component. Add a recommended comparison.

Which scheduling task is available from the SAP Analytics Cloud calendar?. Planning sequence. Multi action. Allocation process.

Which modeling options can you use in a classic account planning model?. Define calculated measures. Define a default currency. Activate pre-calculated actuals. Define conversion measures.

In an existing planning model, what currency-related setting CANNOT be changed?. Default currency. Currency dimension. Currency table. Date dimension.

What can you schedule from the SAP Analytics Cloud calendar?. Data exports. Data imports. Data actions. Data locking.

You create an input task using a story based on a planning model. Which kind of field can you set for "Distribution"?. Dimension. User Name. User Role.

You are using mass data entry mode. After you enter new transaction data, what can you do with the data?. Publish. Process. Approve. Revert.

What does SAP recommend you do to improve the performance of advanced formulas?. Maximise the number of DATA functions. Minimise the use of LOOP instructions. Minimise the number of MEMBERSET statements. Maximise the number of RESULTLOOKUPs.

You enter plan values by year and product group. You want to allocate these values to months and products in proportion to last year's actual data. What dimension do you add to the allocation process to achieve this?. Add date as a source dimension. Add product as a source dimension. Add date as a reference dimension. Add product as a reference dimension.

You have labor hours in an expense model and labor rates in the HR model. To calculate and store labor values (labor hours x labor rates) in the expense model, what must you do?. Look up the labor rates in an advanced data action. Include the labor hours and labor rates in a dimension formula. Blend labor hours and labor rates in the story. Copy the labor rates into the expense model.

Why do you use a table formula?. To create an on-the-fly calculation. To define link dimensions. To enable allocation of data. To disaggregate data.

In a rolling forecast table, what can be used to determine the date to cut over to plan data?. Look ahead x number of months. Local actual value. Current and next time filter. Look back x number of months.

Which of the following actions would allow you to use data point comments?. Add a comment widget to the story. Insert a calculated column to a table. Activate comments by model. Activate comments by dimension.

Regarding the creation of master data, what is available in analytical applications but not in stories?. System-generated master data members. Parent node assignments of new members if a related hierarchy exists. Dimension lookup of master data property values. The “Add member” context menu option in a planning table.

You saved data for a certain cost center and profit center combination. Later, an administrator created a validation rule that prevents saving data against that combination. What happens when you display the data in a story?. The data is re-aligned. A warning message is displayed. The data is deleted. An error message is displayed.

You have a planning model with the following dimensions: Cost Center. Account. Date. Version. When you add new transactional data to your model, you want to add new data for cost center A and remove any records for cost center B. Which import method do you use?. Update. Clean and replace selected version data. Append.

You want to import group reporting data to an SAP Analytics cloud planning model. What source table must you use?. ACDOCU. ACDOCA. ACDOCP. ACDOCC.

In SAP Analytics Cloud, where can users data locking tasks?. Planning Stories. Input Controls. Calendar. Security.

What can you do in a value driver tree with only a BI user role?. Nest value driver trees. Filter the date dimension at node level. Enter data into the value driver tree. Add a cross calculation to a specific node.

How can you configure a currency conversion measure in a New Model?. Hard code a unit type. Dynamically determine a unit type. Hard code a Category.

What is supported when you use the New Model for planning?. Creating a measure using simple moving average. Defining a model without an account dimension. Using a default model currency. Using a currency variable. Viewing formula results in the modeler.

Which SAP Analytics Cloud Machine Learning function provides performance indicators that can be used to evaluate the accuracy of a statistical model?. Smart Grouping. Smart Predict. Smart Insights. Smart Discovery.

What dimension types are required in a planning model?. Account. Generic. Version. Organization. Date.

When you run a data action with the "publish target version automatically" setting enabled, what changes to your data are published?. Data action-specific changes to the private and public versions. Manual changes to the private and public versions. Data action-specific changes to the target public version. Manual changes to the target version.

What can you use to restrict input in a story based on tested conditions?. Advance filtering. Validation Rules. Data Locking.

When you configure a planning area in a model, what can the planning area be based on?. Data access control. Data locking. Input controls. Cell locking.

In a story: you are using a planning model with currency translation enabled. Which properties in the cross calculation editor do you have when configuring currency conversion?. Category. Rate type. Exchange rate. Rate version.

You are importing account hierarchy data from S/4HANA. To import the member to node assignments, what node type must you use?. L. R. N.

Where can you use time series forecasting in SAP Analytics Cloud?. Smart Predict. Bar chart. Story table. SAP Analytics Cloud, add-in for Microsoft Office.

Regarding comments, what can you do in analytical applications but not in stories?. Use a filter for a comment widget. Use radio buttons to select comments. Use the Like feature of comments. Use a dropdown box to select comments.

What must you do to create a seasonal time hierarchy?. Set date to system-managed. Add a property. Set date to user-managed. Add a member.

What data can be exported from SAP Analytics Cloud to SAP S/4HANA?. Activity quantities. Statistical orders. Statistical key figures. Cost rates.

From which S/4HANA source table can you import actual data for cost centers?. ACDOCP. COSP. COSS. ACDOCA.

What is required in an allocation process to allocate occupancy expenses to cost centers based on square footage occupied in the previous year?. Table formula. Reference dimension. Dimension formula.

You create an input form with a restricted measure called 'Current Year Plan' based on the amount measure and date set to current year. In the attached image, what is used to display the selected year as a column header?. Text variable. Dimension formula. Text widget. Table formula.

What data can be exported from SAP Analytics Cloud to SAP S/4HANA?. Hierachies. Master Data Attributes. Statistical key figures. Activity Prices.

You have financial data from SAP S/4HANA with local currency, group currency, and quantity values. You need to import the data into SAP Analytics Cloud. Following the SAP best practice guidelines, how would you design a New Model?. One measure and at least three accounts. Three measures and no accounts. Three measures and at least one account.

Which data locking status can you use to prevent manual data entry?. Released. Submitted. Restricted. Closed.

How can you use a data action to copy data from one version to another while keeping the account number the same?. Include a parameter for version and account in the filter section of the data action. Include 'to' & 'from' parameters for version and account in the copy rules. Include 'to' & 'from' parameters for version and account in the copy rules. Include a parameter for version in the filter and 'to' & 'from' parameters for the account dimension in the copy rules.

You imported a transaction data file into an empty model with the results as shown in Figure A. Later, a member of the finance team wants you to import a new data file. In the new data file, you find the following differences: The value of the Labor account has increased to 1600. There is a new record for the Services account, with a value of 250. The record for the Travel account has been deleted. To achieve the result shown in Figure B, which option must you use to update the data?. Clean and replace selected version data. Append: Reject duplicated rows in model. Clean and replace subset of data with Scope = Version and Account. Update.

You are planning with two hierarchies that have different granularity. Your model contains no data. The story has two pages: a parent planning page and a member planning page (see screenshot). In the Member Planning page you enter the following data: Brazil 100 Chile 100 Peru 100. In the Parent Planning page you enter the following data: North America 10000 South America 30000. When you go back to the Member Planning page, what will you see? Note: There are 2 correct answers to this question. North America 10000. US 5000. Canada 5000. South America 30300. Brazil 10100. Chile 10100. Peru 10100. South America 30300. Brazil 100. Chile 100. Peru 100. North America 10000. US 0. Canada 0.

You have a planning model with the following dimensions: account, product, profit center, date, and version. In a story, which new master data can you add on the fly?. Profit center property value. Account member. Profit center member. Hierarchy node.

Your account dimension has an account for Profit that is calculated as [Revenue] - [Cost]. Which formula can you use to enter a value for Profit and have the system re-calculate Cost while Revenue remains constant?. [Revenue] - [Cost] := INVERSE ([Cost] = [Revenue] - [Profit]). [Revenue] - [Cost] | INVERSE ([Cost]: = [Revenue] -[Profit]). [Revenue] - [Cost] | INVERSE ([Cost] = [Revenue] -[Profit]).

In a story, you are using a New Model with currency translation enabled. Which properties in the calculation editor are available when you configure currency conversion?. Rate Type. Source Measure. Category. Exchange Rate.

Which hierarchy types are supported in an SAP Analytics Cloud dimension?. Version Dependant. Time Dependant. Story Specific. Level based.

When you set up a copy data action, what must you do to allow the user to select the source and target version?. Create a parameter for the source version. Add a copy rule for version. Create a parameter for the target version.

You are using an advanced data action to copy Northeast (NE) data to Northwest (NW) as shown in the attached image. What must you activate in the advanced data action to achieve the desired result for profit center PC4?. Overwrite. Unbooked. Signflip.

The SAC Planning Process. The Prepare Phase. The Planning Phase (Plan, Predict, Analyze). The Finalize Phase.

The SAC Prepare Phase. 1.- Build a Planning Model. 2.- Add planning Functionality, that includes: a) Set up validation rules b) Configure data locking c) Create data actions d) Set up allocation processes e) Create multi actions. 3.- Create stories and analytic applications, that includes: a) Build value driver trees b) Create planning tables. 4.- Set up and asssing tasks and processes, that includes: a) Schedule automatic data actions b) Schedule multi actions c) Schedule data locking tasks.

The SAC Planning Phase. Planning Reporter: 1.- Create and share private versions. 2.- Enter data usign planning tools Ad hoc Planning: a) Do manual data entry b) Use the planning panel c) Add new dimension members Structured Planning: a) Run structured allocation b) Run data actions &multi actions c) Run BPC planning processes Driver-based Planning: a) Use value driver trees for simulations Predictive Planning: a) Use the calendar to organize your process b) Run data point Predictive forecasts c) Run time series predictive forecasts. 3.- Share content with viewers. Planning Viewer: 4.- Comment and discuss.

In the visual editor for advanced formulas, which of the following formula options can you select?. Subtraing. Delete. Concatenate. Calculation. Repeat. Condition. Comments.

Allocation with Unique HR Account. Allocation Account. Target Account. Booking Account.

Wich one are mandatory in Driving Dimensions. Version. Date. Account. Organization.

Data Locks logged as No-Owner. Change the data lock status. Set the cell to ignore data locks. Change the data. Publish it.

Conflicting properties between an account dimension and measures, if you have a calculations in the rows and in the column, wich one wins?. The global setting priority settings still prevails for conversion measures, and calculated accounts or calculated measures that use either the Restrict or Lookup formula. n/a.

Rolling Forecast. A rolling forecast predicts the future development of a value, allowing a flexible timeline for calculation. The time interval of a rolling forecast is not static, and changes automatically. The time period of a rolling forecast is set so that it has no ending; when a period of the predefined timeline is passed, the same time period is automatically added to the end of the forecast. n/a.

The SAC Finalize Phase. 1.- Submit data for Calendar Tasks. 2.- Review and approve Calendar tasks. 3.- Publish versions. 4.- Set data locks. 5.- Export Planning model data.

When training a smart predict model, which entity has the most accurate forecast?. Athletic Shorts – Pacific: Expected MAPE 12.84 %, influencer count 2. Athletic Shorts – US: Expected MAPE 1382.81 %, influencer count 1. Athletic Shorts – EMEA: Expected MAPE 7.16 %, influencer count 1.