C_SAC_2415

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?A . Create a group that includes the dimensions.B . Create a level-based hierarchy in the dataset.C . Create...

You need to delete characters from a column in a dataset. What can you use? Note: There are 2 correct answers to this question.A . Custom expression editorB . Formula barC . Calculation editorD . Transform barView AnswerAnswer: A D

How can you improve the performance of advanced data actions? Note: There are 3 correct answers to this question.A . Use fewer MEMBERSET statementsB . Use fewer FOREACH functionsC . Use fewer IF statementsD . Use fewer data functionsE . Use fewer aggregation dimension functionsView AnswerAnswer: BCD

What type of predictive scenario can write back to a planning model?A . RegressionB . Value driver treeC . ClassificationD . Time series forecastView AnswerAnswer: D Explanation: In SAP Analytics Cloud, a Time Series Forecast predictive scenario can write back to a planning model. Time Series Forecasting leverages historical data...

Where can you change a data lock status? Note: There are 2 correct answers to this question.A . Data actionB . Value lock managementC . Multi actionD . Calendar taskView AnswerAnswer: C D

You want to total several income and expense accounts using the account type property. What configuration option in the advanced formula must you use?A . UnbookedB . AppendC . SignflipD . Aggregate ToView AnswerAnswer: C

You are using a live connection for a model. Where is the data stored?A . Public datasetB . SAP Analytics Cloud modelC . Source systemD . Embedded data setView AnswerAnswer: C Explanation: Connections and data preparation When using a live connection in SAP Analytics Cloud, the data remains stored in...

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?A . Use two propertiesB . Dis-able allocationsC . Use two hierarchiesD . Dis-able distributionView AnswerAnswer: C...

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?A . LevelB . HierarchyC . CardinalityD . GranularityView AnswerAnswer: C

What can you use to organize dimensions into logical categories in a live model?A . Level-based hierarchyB . GroupsC . Value driver treeD . Parent-child hierarchyView AnswerAnswer: D Explanation: In a live model within SAP Analytics Cloud, dimensions can be organized into logical categories using either level-based hierarchies or parent-child...