MayMendoza

What source system can you connect to with a live connection?. SAP ERP Central Component. SAP SuccessFactors. SAP Business ByDesign Analytics. SAP Datasphere.

You are using a live connection for a model. Where is the data stored?. Public dataset. SAP Analytics Cloud model. Source system. Embedded data set.

You are using a live connection for a model. Where can you define data security?. Source system. Data access control. SAP Analytics Cloud model. SAP Analytics Cloud role.

What must you use to transform data in a dataset using if/then/else logic?. Calculations editor. Custom expression editor. Formula bar. Transform bar.

You import data into a dataset. One of the columns imported is Year, and SAP Analytics Cloud interprets it as a measure. How can you ensure that it is treated as a calendar year?. Change the Year measure to a dimension in the dataset. Includes the Year measure in a level-based time hierarchy in the dataset. Insert a character into the Year measure using the transform bar. Add the month as a suffix to the Year measure.

You have a story based on an import model. The transaction data in the model's data source changes. How can you update the data in the model? Note: There are 2 correct answers to this question. Allow model import. Refresh the story. Refresh the import job. Schedule the import.

You need to delete characters from a column in a dataset. What can you use? Note: There are 2 correct answers to this question. Custom expression editor. Formula bar. Calculation editor. Transform bar.

What can you use to organize dimensions into logical categories in a live model?. Level-based hierarchy. Group. Value driver tree. Parent-child hierarchy.

What are the available connection types in SAP Analytics Cloud? Note: There are 2 correct answers to this question. Live. On-premise. Cloud. Import.

Your embedded dataset in SAP Analytics Cloud has columns for Country, Region, City, and Customer Name. You want to aggregate measures for these columns as a single column. What can you do?. Create a group that includes the dimensions. Create a level-based hierarchy in the dataset. Create a parent-child hierarchy in the dataset. Convert the embedded dataset to a model.

You are creating a script for an advanced data action. Which character designates a virtual variable member?. %. /. *. #.

You are creating a data action to copy data from one year to the next. In the parameter for the source year, which default setting must you change?. Level. Hierarchy. Cardinality. Granularity.

You want to total several income and expense accounts using the account type property. What configuration option in the advanced formula must you use?. Unbooked. Append. Signflip. Aggregate To.

You have a dimension with members for product groups and products. Each product group has associated products. You want to plan by product group without disaggregating into the products. Use two properties. Dis-able allocations. Use two hierarchies. Dis-able distribution.

What can you do with a multi action? Note: There are 2 correct answers to this question. Run allocation data actions. Import transaction data. Approve data. Run allocation processes.

You are creating an allocation step to distribute expenses from the HR cost center to your operating cost centers. Which dimension setting controls how much is distributed to each operating cost center?. Reference. Driver. Distribute. Redistribute.

You are entering values for several expense accounts in a data table. Which data entry mode must you use to process the data with a delay defined in System Administration?. Fluid. Single. Mass.

Where can you change a data lock status? Note: There are 2 correct answers to this question. Data action. Value lock management. Multi action. Calendar task.

How can you improve the performance of advanced data actions? Note: There are 3 correct answers to this question. Use fewer MEMBERSET statements. Use fewer FOREACH functions. Use fewer IF statements. Use fewer data functions. Use fewer aggregation dimension functions.

What type of predictive scenario can write back to a planning model?. Regression. Value driver tree. Classification. Time series forecast.

How can you determine node relationships in a value driver tree? Note: There are 2 correct answers to this question. Use a dimension hierarchy. Use a calculated member. Use a story calculated measure. Use a model converted measure.

You are creating a new public version. Which categories can you use? Note: There are 2 correct answers to this question. Budget. Actual. Predictive. Forecast.

You input new data for a private version in a story. What must you do to ensure the new data is added to the model?. Save. Send. Publish. Nothing.

What account types use the average rate type? Note: There are 2 correct answers to this question. INC. AST. EXP. LEQ.

Where can you create a blank planning version?. In a data cell. In version management. In the version dimension. In the planning model.

What must a data model contain in SAP Analytics Cloud? Note: There are 2 correct answers to this question. Calculations. Dimensions. Measures. Hierarchies.

Which of the following data sources can you use in SAP Analytics Cloud data analyzer? Note: There are 3 correct answers to this question. SAP Analytics Cloud public dataset. SAP HANA view. SAP Datasphere model. SAP Analytics Cloud analytic model. SAP BusinessObjects Universe.

You have a live data model with two dimensions: Firstname and Lastname. Users want a single dimension in the data model that displays the dimensions as Lastname, Firstname. What must you do?. Create the combined data in the source system. Create a calculated dimension in the data model. Create a calculated dimension in the story. Group the Firstname and Lastname in the data model.

Your users need to analyze data in a story. What kinds of data models can you create? Note: There are 2 correct answers to this question. Standalone. Embedded. Planning. Analytic.

Which SAP Analytics Cloud feature uses natural language processing?. Digital boardroom. Data analyzer. Smart insight. Just Ask feature.

Which automatically created dimension type can you delete from an analytic data model?. Version. Date. Organization. Generic.

You want to save your data analyzer result. What is it saved as?. Story. Insight. Dataset. Model.

The SAP Analytics Cloud (SAC) modeler has removed the first three characters from an SAP Analytics Cloud public dimension imported from a source system. What is impacted by this change?. Public datasets. Source system. Stories. Embedded data sets.

Which dimension type can you use like a measure?. Account. Date. Organization. Entity.

What features are supported by data analyzer? Note: There are 3 correct answers to this question. Linked dimensions. Charts. Conditional formatting. Input controls. Calculated measures.

In a data model, what can you use to further describe a dimension?. Data action. Measure. Property. Variable.

You have a dataset that extracts data from an SAP Business Warehouse (SAP BW) system. The data in the SAP BW system changes. How can you update the dataset?. You must create a new dataset. You must manually reimport the data. You must refresh the story that uses the dataset. You can schedule the dataset to update on a regular basis.

In a planning data model, what dimensions are included by default? Note: There are 2 correct Answers to this question. Date. Version. Entity. Organization.

Which tasks can you perform in data analyzer? Note: There are 2 correct answers to this question. Input data. Filter data. Drill down on data. Create cross-calculation.

In which types of data source can you concatenate data? Note: There are 3 correct answers to this question. Embedded data set. Live data model. Data analyzer insight. Standalone dataset. Imported data model.

Which programming language is used for scripting in an SAP Analytics Cloud story?. Python. Wrangling Expression Language. ABAP. JavaScript.

You are designing a new story. You want the size and position of widgets to adjust dynamically for viewing on different devices and screen sizes. Which page type must you use?. Grid. Responsive. Composite. Canvas.

To which story elements can you apply conditional formatting? Note: There are 2 correct answers to this question. Table. Lane. Chart. Composite.

What can you use input controls for in a story? Note: There are 2 correct answers to this question. Changing dimensions or measures displayed in a table. Filtering data on a page. Selecting an alternate data source. Implementing row-level and column-level security in a table.

You want to use an input control to filter data appearing in a story. At what level is the filter applied?. Calculation. Page. Component. Story.

When scrolling down in a long table, how can you retain column headers? Note: There are 2 correct answers to this question. Enable Keeping member names visible. Enable Auto-Size And Page Table Vertically. Freeze Up to row. Freeze Up to column.

Which features are available in the Optimized Design Experience? Note: There are 3 correct answers to this question. Undo button. Grid pages. Linked widgets diagram. Composites. Explorer.

For which activities must you enable Advanced Mode in story design? Note: There are 2 correct answers to this question. Add JavaScript to a button. Add a popup. Add a layer to a geo map. Add a custom widget.

You are creating a styling rule for a table. What is the context?. The most granular level in the table. The highest level in the table. The table header. The location of the cursor.

What can you use to perform cell-based calculations in a story?. Calculated measures. Dimension formulas. Restricted measures. Table formulas.

You are creating a styling rule for a table with a hierarchy of Country, Region, and City. You want to apply the styling rule only to countries. Which level option must you use?. Self and Siblings. Self and Children. Self and Descendants. Self.

Which calculation types include dynamic date options? Note: There are 2 correct answers to this Question. Aggregation. Date Difference. Restricted Measure. Difference From.

What is required to use version management in a story?. Planning model. Classic mode. Analytic model. Optimized mode.

You want to display differences between measures in a chart. What can you use?. Variance. Restricted measure. Threshold. Reference line.

How can you limit the refresh time of a story?. Use canvas pages. Collapse the hierarchy. Create calculated measures. Implement a value driver tree.

How can you help a user enter data faster in a planning story? Note: There are 2 correct answers to this question. Select fluid data entry mode in the story. Enable Optimize Recommended Planning Area in the model. Set Size Limits for Planning Performance in the model. Enable unbooked data in the story.

You have a story in My Files. You want your colleague to review and comment on the story. What must you do?. Create a Review task for the story. Add a Comment widget to the story. Share with View access. Include the story in a Discussion.

You have a column chart in a story. You notice some of the labels are missing until you mouse over the data point. How can you ensure that the labels are always visible?. Increase the overall size of the chart widget on the page. Select the Avoid Data Label Overlap checkbox. Increase the font size of the axis labels.

What can you do to reduce the data refresh time when opening a story? Note: There are 3 correct answers to this question. Use responsive pages. Avaid tables with more than 500 rows and 60 columns. Load widgets in the background. Use conditional formatting. Avaid prompts.

Your story takes a long time to open. What could cause this? Note: There are 3 correct answers to this question. Large calculation scope. Many story filters. Many hyperlinks. Complex formatting. Many data sources.