C_SAC_2421

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...

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

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?A . FluidB . SingleC . MassView AnswerAnswer: A

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...

What must you use to transform data in a dataset using if/then/else logic?A . Calculations editorB . Custom expression editorC . Formula barD . Transform barView AnswerAnswer: B Explanation: To transform data in a dataset using if/then/else logic in SAP Analytics Cloud, you must use the Custom expression editor. This...

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

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?A . ReferenceB . DriverC . DistributeD . RedistributeView AnswerAnswer: B Explanation: In the context of creating an allocation...

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 script for an advanced data action. Which character designates a virtual variable member?A . %B . /C . *D . #View AnswerAnswer: B

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