SAC TESTO

Where can you change a data lock status? (2 correct). Multi action. Calendar task. Value lock management. Data action.

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

Which task can you perform in data analyzer? (2 correct). Drill down on data. Filter data. Create cross-calculation. Input data.

What must a data model contain in SAP Analytics Cloud? (2 correct). Dimensions. Measures. Hierarchies. Calculations.

What are the available connection types in SAP Analytics Cloud? (2 correct). Import. Live. Cloud. On-premise.

When scrolling down in long table, how can you retain column headers? (2 correct). Enable Auto-Size and Page Table Vertically. Freeze Up to row. Enable keeping member names visible. Freeze Up to column.

Which SAP Analytics Cloud feature user natural language process?. Smart Insight. Just Ask feature. Data analyzer. Digital boardroom.

In a planning data model, what dimension are include by defaults? (2 correct). Date. Version. Entity. Organization.

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

For which activities must you enable Advanced Mode in story design? (2 correct). Add a pop-up. Add JavaScript to a button. 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 table header. The highest level in the table. The most granular level in the table. The location of the cursor.

What can you do to reduce the data refresh time when opening a story? (3 correct). Load widgets in background. Use responsive pages. Avail table with more than 500 rows and 60 columns. Use conditional formatting. Avail prompts.

Which of the following data sources can you use in SAP Analytics Cloud data analyzer? (3 correct). SAP Datasphere model. SAP Analytics Cloud analytic model. SAN HANA view. SAP BusinessObject Universe. SAP Analytics Cloud public dataset.

The SAP Analytics Cloud modeler has removed the first three character impacted by this change?. Stories. Public datasets. Source system. Embedded data sets.

You are creating a script for an advanced data action. Which character designates a virtual variable member?. Hash(#). Slash(/). Star(*). Percentage (%).

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

What can you use input control for in a story? (2 correct). Changing dimensions or measures displayed in table. Filtering data on a page. Selecting an alternative data source. Implementing row-level and column-level security in a table.

How can you improve the performance of advanced data actions?. Use fewer IF statements. Use fewer data function. Use fewer FOREACH function. Use fewer aggregation dimension functions. Use fewer MEMBERSET statements.

What can you use to organize dimension intro logical categories in a live model?. Parent-child hierarchy. Level-based hierarchy. Groups. Value driver tree.

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

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

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

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

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

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

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

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?. Granularity. Cardinality. Hierarchy. Level.

In which types of data source you concatenate data? (3 correct). Standalone dataset. Imported data model. Embedded data set. Live data model. Data analyzer insight.

What account types use the average rate type? (2 correct). INC. EXP. AST. LEQ.

How can you determine node relationship in a value driver tree? (2 correct). Use a dimension hierarchy. Use a calculated member. Use a story calculated measure. Use a model converted measure.

Which calculation types include dynamic date options? (2 correct). Difference From. Restricted Measure. Aggregation. Date Difference.

What feature are available in the Optimized Design Experience? (3 correct). Linked widgets diagram. Composites. Undo button. Explorer. Grid pages.

To which story elements can you apply conditional formatting? (2 correct). Chart. Table. Lane. Composite.

You are creating a new public version. Which categories can you use?. Budget. Forecast. Predective. Actual.

How can you help a user enter data faster in a planning story? (2 correct). Enable Optimize Recommended Planning Area in the model. Select fluid data entry mode in the story. Enable unbooked data in the story. Set Size limits for Planning Performance in the model.

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

What can you do with a multi action? (2 correct). Run allocation data action. Import transaction data. Approve data. Run allocation processes.

What configuration option in the advanced formula must you use?. Singflip. Aggregate to. Append. Unbooked.

What features are supported by data analyzer? (3 correct). Conditional formatting. Calculated measures. Charts. Linked dimensions. Input controls.

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

Your story takes a long time to open. What could cause this? (3 correct). Large calculation scope. Complex formatting. Many data sources. Many hyperlinks. Many story filters.

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

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?. Publish. Send. Save. Nothing.

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

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

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

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. How can you do this?. Use two properties. Disable allocations. Use two hierarchies. Disable distribution.

Your users need to analyze data in a story. What kinds of data models can you create? (2 correct). Planning. Analytic. Embedded. Standalone.

You have a story in My Files. You want your colleagues to review and comment on the story. What must you do?. Share with View Access. Add a comment widget to the story. Include the story in a discussion. Create a review task for the story.

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

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

You need to delete characters from a column in a dataset. What can you use? (2 correct). Transport bar. Custom expression editor. Formula bar. Calculation editor.

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

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 manually reimport the data. You can schedule the dataset to update on a regular basis. You must create a new dataset. You must refresh the story that uses the dataset.

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 level-based hierarchy in the dataset. Create a group that includes the dimensions. Convert the embedded dataset to a model. Create a parent-child hierarchy in the dataset.

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

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

You have a story based on an import model. The transaction data in he model's data source changes. How can you update the data in the model? (2 correct). Refresh the import job. Schedule the import. Refresh the story. Allow model import.

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

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?. Responsive. Canvas. Composite. Grid.