Free SAP C-SACP-2102 Exam Dumps Questions & Answers

What does SAP recommend you do to improve the performance of advanced formulas?

• A.Minimize the use of LOOP instructions.
• B.Minimize the number of MEMBERSET statements.
• C.Maximize the number of RESULTLOOKUPs.
• D.Maximize the number of DATA functions.

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.

• A.Maintenance view RSBPC_ODATA_V_EX
• B.Enhancement spot RSBPC_ODATA
• C.SAP Business Warehouse connection
• D.OData connection

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.

• A.Comment
• B.Round
• C.Repeat
• D.Lookup

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.

• A.Blend labor hours and labor rates in the story.
• B.Include the labor hours and labor rates in a dimension formula.
• C.Look up the labor rates in an advanced data action.
• D.Copy the labor rates into the expense model.

Your account dimension has an account for Profit that is calculated as [Revenue] - [Cost]. Which formula can you use to enter a value for Profit and have the system re-calculate Cost while Revenue remains constant?

• A.[Revenue] - [Cost] | INVERSE ([Cost] = [Revenue] - [Profit])
• B.[Revenue] - [Cost] | INVERSE ([Cost] := [Revenue] - [Profit])
• C.[Revenue] - [Cost] := (INVERSE [Cost] := [Revenue] - [Profit])
• D.[Revenue] - [Cost] := INVERSE ([Cost] = [Revenue] - [Profit])