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 currencies Two curriencies types Two measures.
Why would you use the SAP Analytics Cloud, add-in for Microsoft Office instead of SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud? Note: There are 2 correct answer to this question To connect to any device To swap axes To highlight changed cells To lock data.
What are some characteristics of popups in analytic applications? Note: There are 2 correct answer to this question Scripting can be assigned to buttons in the popup Dropdowns in the popup are only displayed when needed Popups cab be copied to stories Popups have a scripting event onInitialization.
In a rolling forecast table, what can be used to determine the date to cut over to plan data? Current and next time filter Last actual value Look ahead x number of months.
When you import group reporting data from SAP S/4HANA to an SAP Analytics Cloud planning model, which mappings are required? Note: There are 2 correct answers to this question Company to an SAP Analytics Cloud entity General ledger account to an SAP Analytics Cloud account Consolidation unit to an SAP Analytics Cloud entity Financial statement item to an SAP Analytics Cloud account.
You have an SAP Business Warehouse data source with 25 key figures and no account characteristic. What must you do to import this data into an existing planning model? Note: There are 2 correct answers to this question Include 25 value columns in the planning model. Map the key figures to the account card during the import. Include 25 accounts in the planning model. Map the key figures to the measures card during the import.
What can you use to restrict input in a story based on nested conditions? Validation rules Advanced filtering Data locking.
You need to copy data from one version to another 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? Validation rules Advanced filtering Data locking.
In a story, how can you create a chart to compare versions? Note: There are 2 correct answers to this question Add a 'difference from' measure. Add a new member with a formula. Add a chart component. Add a recommended comparison.
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 setting in the allocation process is required to achieve this? Add product as a reference dimension Add date as a source dimension Add date as a reference dimension Add product as a source dimension.
How can you change plan data via the Planning Panel in a story? Note: There are 2 correct answers to this question Redistribute values to a lower level of the hierarchy. Distribute values based on recommendations. Realign values based on properties. Repost the values to a higher level of the hierarchy.
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 100 Chile 100 Peru 100 North America 10000 US 0 Canada 0 South America 30300 Brazil 10100 Chile 10100 Peru 10100.
In the pre-delivered planning content, which financial statement version is used to integrate S/4HANA account hierarchies and SAP Analytics Cloud account hierarchies? FPA1 YCOA S4H1.
Which account types allow you to display database values with the opposite sign in stories? Note: There are 2 correct answers to this question INC AST EXP LEQ.
When exporting from SAP Analytics Cloud to SAP Business Warehouse, which of the following are active by default? Note: There are 2 correct answers to this question Update fiscal period Overwrite mode Delta mode Update calendar month.
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? Level-based Table-based Parent-child.
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 are importing account hierarchy data from S/4HANA. To import the member to node assignments, what node type must you use? N L R.
When you configure a planning area in a model, what can the planning area be based on? Note: There are 2 correct answers to this question Input controls Data access control Cell locking Data Locking.
Which DataStore object (advanced) properties must be selected to export data to SAP Business Warehouse? Standard datastore object Staging datastore object Direct update datastore object.
You have a model in SAP BPC, version for SAP BW/4HANA Standard option that contains data records in both local currency and group currency. When you create the corresponding planning model in SAP Analytics Cloud, you set the Currency Conversion setting to On. How does this impact the planning model? Note: There are 2 correct answers to this question Local currency is imported. Currencies are determined from the converted measure Currencies are determined from the entity dimension. Local currency and group currency are imported.
Regarding comments, what can you do in analytical applications but not in stories? Note: There are 2 correct answers to this question 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.
When you delete a planning model, what dimension types are always deleted? Note: There are 2 correct answers to this question Account Version Time Organization.
Which work files can you access when you run a planning process? Note: There are 2 correct answers to this question Dashboard URL link Analytic Application Workbook.
You have created a new SAP Analytics Cloud dimension to be used for SAP S/4HANA master data. To import the members, text, and hierarchy data, how many data sources do you need? 3 1 5.
You are using SAP Analytics Cloud and SAP BPC, version for SAP BW/4HANA Embedded option. Which of the following planning features are available for hybrid planning? Note: There are 2 correct answers to this question Analysis authorizations Data access controls Data actions Planning sequences.
You want to create a copy data action that allows you select the source values and target values for the following dimensions at run time: Version, Account, Time. What do you specify for each of these dimensions? No Filter. Source and target parameters for version, account, and time in the copy rules Source and target parameters for version in the filter. Source and target parameters for version and time in the copy rules. Source version parameter in the filter. Source and target parameters for account and time in the copy rules.
Which of the following properties does a CommentInfo object in an analytical contain? Note: There are 3 correct answers to this question The number of likes The comment technical ID The change history The comment text The comment Lenght.
What dimension types can be used to determine currencies? Note: There are 2 correct answers to this question Date Account Organization Generic.
When importing transaction data from SAP Business Warehouse to SAP Analytics Cloud, what is the maximum? 2000000000 rows 800000 rows 10000000 cells 100000000 cells.
Why do you use a table formula? To disaggregate data To define link dimensiones To enable allocation of data To create an on-the.fly calculation.
How can you use a data action to copy data from one version to another while keeping the account number the same? Note: There are 2 correct answers to this question 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. Include a parameter for version and account in the filter section of the data action. Include a parameter for account in the filter and 'to' & 'from' parameters for version in the copy rules.
In SAP Analytics Cloud Smart Predict, how can you use versions with a planning model? Note: There are 2 correct answers to this question Train the model with completed public data. Train the model with in-process public data. Save the forecast to a private version. Save the forecast to public version.
When you import account hierarchy data from SAP S/4HANA, which of the following account types are determined by semantic tags exclusively? Note: There are 2 correct answers to this question INC EXP LEQ AST.
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 subset of data with Scope = Version and Account Append: Reject duplicated rows in model Update Clean and replace selected version data.
What can you do with a data action trigger in an analytic application? Note: There are 2 correct answers to this question Use the onBeforeExecute event Execute the data action trigger at design time Use the onAfterExecute event Execute the data action trigger at runtime.
You enter the following code into the formula script editor: MEMBERSET [d/Account]= What does the auto-complete feature return? Note: There are 2 correct answers to this question Properties Hierarchies Members Parameters.
You need to schedule the import master data for the profit center, cost center, account dimensions as well as the transction data. Each dimension has members, text, attribites and a hierarchy. When importing from SAP Business Warehouse. How many import steps do you need? 4 10 13.
Which of the following actions on the date dimension are available in Value Driver Trees? Specify a presentation date range. Change the date filter for an individual node within the Value Driver Tree. Select the Day granularity.
Where can you schedule an import into an SAP Analytics Cloud model? Data management SAP Analytics Cloud calendar Data action monitor SAP BW process chain.
You want to import group reporting data to an SAP Analytics cloud planning model. What source table must you use? ACDOCA ACDOCU ACDOCP.
Which of the following are prerequisites to export transaction data to a DataStore object (advanced) in SAP Business Warehouse? Note: There are 2 correct answers to this question Enhancement spot RSBPC_ODATA Maintenance view RSBPC_ODATA_V_EX OData connection SAP Business Warehouse connection.
When you run a data action with the "publish target version automatically" setting enabled, what changes to your data are published? Note: There are 2 correct answers to this question Manual changes to the target version Manual changes to the private and public versions Data action-specific changes to the target public version Data action-specific changes to the private and public versions.
Which dimension types support the system-generated Person Responsible property? Note: There are 2 correct answers to this question Organization Version Account Generic.
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? Note: There are 2 correct answers to this question Source measure Rate type Category Exchange rate.
For which of the following are value driver trees available? Note: There are 2 correct answers to this question Analytic models Planning models Live models Datasets.
You want to rebuild an SAP Analytics Cloud planning model but the Rebuild Model button is inactive.Why might this happen? Note: There are 2 correct answers to this question Data exists in the model. A public version is used in the model. A private version is used in the model. Currency conversion is enabled.
Where can you use time series forecasting in SAP Analytics Cloud? Note: There are 2 correct answers to this question Story table Bar chart SAP Analytics Cloud, add-in for Microsoft Office Smart Predict.
You are using mass data entry mode. After you enter new transaction data, what can you do with the data? Revert Publish Process Lock.
You want to import data from SAP BPC Standard. Which SAP Analytics Cloud planning model types can you use? Note: There are 2 correct answers to this question Write-back Generic Basic Financial.
You are using the SAP BPC, version for SAP BW/4HANA Standard option. When importing data from a YTD model to SAP Analytics Cloud, what can you do? Note: There are 2 correct answers to this question Select the basic model type. Store periodic data for income statement accounts. Store YTD data for income statement accounts. Select the write-back model type.
What data can be exported from SAP Analytics Cloud to SAP S/4HANA? Note: There are 2 correct answers to this question Statistical key figures Cost rates Statistical orders Activity quantities.
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? Note: There are 2 correct answers to this question Profit center property value Account member Product center member Hierarchy node.
In the delievred content for collaborative enterprise planning, where do the sales volumes come from? SAP Business Planning and Consolidation SAP S/4HANA Sales SAP Integrated Business Planning.
Which activities can be scheduled from the calendar in SAP Analytics Cloud? Note: There are 2 correct answers to this question Data locking Create input form Data action Publish stories.
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? Note: There are 2 correct answers to this question Copy the labor rates into the expense model. Blend labor hours and labor rates in the story. Include the labor hours and labor rates in a dimension formula. Look up the labor rates in an advanced data action.
In the visual editor for advanced formulas, which of the following formula options can you select? Note: There are 2 correct answers to this question Calculation Substring Delete Concatenate.
Which of the following are features of an Embedded Data Action step? Note: There are 2 correct answers to this question Combine data actions of different models Nest data actions Create cyclical references of data actions Link parameters of data actions.
Using a live connection in SAP Analytics Cloud, for which system can you change plan data? SAP BPC Estándar SAP S/4HANA SAP BPC Embedded.
In SAP Analytics Cloud, where can you apply data security ? Analysis authorizations SAP Identity Management Dimension properties.
Which scheduling task is available from the SAP Analytics Cloud calendar? Allocations process Planning sequence Multi action.
You have an SAP Business Warehouse data source with 25 key figures and no account characteristic. What must you do to import this data into an existing planning model? Note: There are 2 correct answers to this question The model has a private version The story is shared The model contains private dimensions The model is shared.
To import a display attribute from SAP Business Warehouse into an SAP Analytics Cloud dimension, in which BW object must the display attribute be included? Characteristic InfoProvider Data Source Query.
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? Conversion Calculated Restricted.
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.
When training s smart predict model, which entity has the most accurate forecast? Athletic Shorts - Pacific: Expected MAP 12.84%, infliencer count 2 Athletic Shorts - US: Expected MAP 1382.81%, infliencer count 1 Athletic Shorts - EMEA: Expected MAP 7.16%, infliencer count 1.
Which of the following dimension types supports multiple hierarchies? Organization Account Time.
What can you do in a value driver tree with only a BI user role? Note: There are 2 correct answers to this question 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.
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.
|
