Free SAP C_BOWI_42 Practice Test & Real Exam Questions
A table contains a dimension [CITY] and a measure [SALES]. You insert a column to display the formula AVERAGE([SALES]). Which operator do you add to the formula so that it displays the average for the table in every row? (2 answers)
Correct Answer: A,D
Vote an answer
You are asked to create a table to display revenue data in three distinct colors. What must you create in a single conditional formatting rule?
Correct Answer: A
Vote an answer
What is the correct formula for the RunningSum column (shown in the attached graphic)?
Correct Answer: D
Vote an answer
What happens when you create a section in a report? (2 answers)
Correct Answer: A,B
Vote an answer
In the Annual Revenue column, what formula calculates the total annual revenue in each row (shown in the attached graphic)?
Correct Answer: D
Vote an answer
Which operator allows you to enter more than one operand value?
Correct Answer: C
Vote an answer
You want to subtotal the data by year in a table but you do not have a location for the subtotal in the table. What must you do to create the location for the subtotal in the table?
Correct Answer: D
Vote an answer
Which table type looks most similar to a Microsoft Excel pivot table?
Correct Answer: B
Vote an answer
What can you use to create hyperlinks between Web Intelligence documents?
Correct Answer: A
Vote an answer
