SAP Webi Online Quiz



Following quiz provides Multiple Choice Questions (MCQs) related to SAP Webi. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.

Questions and Answers

Q 1 - Which of the following can be used to select result objects in a Webi document from a Universe as data source?

A - Information Design Tool

B - Query Merge

C - Explorer

D - Query Panel

Answer : D

Explanation

In Query panel, you can select from list of available objects as per your access permissions. You may not be able to use few of the objects cos of permission.

In query panel, you have Universe outline in left pane and Result objects, query filters, data preview panels in main pane.

Q 2 - Which method can you use to combine queries in Webi Rich Client?

A - Minus

B - Add

C - Add All

D - Subtract All

E - Subtract

Answer : A

Explanation

Minus and Intersect can be used to combine queries in a Webi document.

Q 3 - You want to create queries from multiple data sources in a Webi document? Which of the following feature you should use?

A - Aggregation

B - Joins

C - Union

D - Indexing

E - Query Merge

Answer : E

Explanation

This option allows you to merge the data from different data sources. Assume that you have created Query 1 and Query 2 in Query Panel. When you combine both the queries in a single WebI report, objects from both the queries are shown in list of available objects. To use, go to Data Access → Merge

Answer : D

Explanation

A hierarchy represents parent child relationship in Universe. It allows you to drill up or drill down in the report to next level.

Example

Geography hierarchy contains Country, State and City.

Time hierarchy contains Year, Quarter, Month and Week.

Using member selector in defining hierarchy, you can define which member appear in the result set. In hierarchical data sources hierarchies are associated with a dimension.

Q 6 - Which of the following is not a part of a Prompt in query panel?

A - An Object

B - Message

C - An Operand

D - An Operator

Answer : D

Explanation

A Prompt contains below section −

  • An Object
  • An Operator
  • Message

Q 7 - Where do formulas get store when you use in a Webi report?

A - Universe

B - Query Panel

C - Report Page

D - PDF

Answer : C

Q 8 - To create a section on a dimension in Webi report, where you can select Insert section option in Webi Rich client?

A - Analysis

B - Report Elements

C - Format

D - Page Setup

E - Data Access

Answer : B

Explanation

To create a section from a Dimension, Go to Report Elements → Section → Insert Section

Q 9 - Which of the following is not an aggregation function that can be used in a Webi document?

A - Max

B - Min

C - Count All

D - Count

E - Average

Answer : C

Q 10 - To use a formula in WebI report, report should be opened in which of the following mode?

A - Data

B - Design

C - Read

D - All of the above

Answer : B

sap_webi_questions_answers.htm
Advertisements