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 is not in main tabs in BI Launchpad?

A - Home

B - Document

C - My Applications

D - My recently viewed documents

E - Options

Answer : E

Explanation

BI Launchpad has the below tabs −

Home

Document

Any open Document

You can use Application tab to start an application including Web Intelligence.

You can use Preference tab to define BI Launchpad preferences.

Q 2 - Query panel is not available when you use Web Interface of Webi tool?

A - True

B - False

Answer : A

Q 3 - Which Object is retrieved from the Input File Repository Server when you refresh a Web Intelligence document?

A - Universe

B - BEx

C - Publication

D - Hyperlink

E - Analysis View

Answer : A

Q 4 - Which of the following is not an Operand in a query filter in query panel?

A - LOVs

B - Prompt

C - Constant

D - Variable

E - Result from Other Query

Answer : D

Explanation

Object (On which filter is applied), Operator (You can use various comparison operators) Operand.

You can select from the list of Operands −

  • Constant
  • List of Values (LOVs)
  • Prompt
  • Universe Object
  • Result from Other Query

Q 5 - Which of the following can be used to extract the word smart from the product category smart watch?

A - Right((Product cat),5)

B - Right(5; [Product cat])

C - Left ([Product cat];5)

D - All of the above

Answer : C

Q 6 - You can create Webi documents based on BEx (business Exchange Queries) created by BEx Query Designer which is based on Info Cube in SAP BW system. You can only use BEx queries which are flagged with Allow External access to the Query?

A - True

B - False

Answer : A

Explanation

You can create Webi documents based on BEx (business Exchange Queries) created by BEx Query Designer which is based on Info Cube in SAP BW system. You can connect to a BEx query in WebI with use of BICS BI consumer service connection. You need not to create Universe for BEx queries and all attributes, hierarchies, dimensions and measures are automatically mapped in WebI document.

You can edit, create, refresh documents based on BEx using Web Intelligence Rich Internet Application Applet based, WebI Rich Client. If you are using WebI DHTM web interface, you can only view or refresh a WebI document based on BEx and cant edit them.

Below points about BEx should be considered −

You can only use BEx queries which are flagged with Allow External access to the Query.

To manage object mapping, refer to restriction and equivalent pages to ensure correct use of queries.

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

Answer : D

Explanation

You can rank the unranked data from database in your report. Database ranking allows you to rank the data at database level so when you run a query, data returned by query is already ranked.

Database ranking is done by editing the script generated by query. If you database doesnt support ranking, then option to create ranking will not highlight in query panel.

Also note that Ranking cant be created on hierarchical data.

Q 9 - Which of the following chart in Webi can be used to show five number summary based on distribution of a dataset: the maximum, the minimum, the first quartile, the third quartile, and the median and can also show abnormal values called outliers?

A - Map chart

B - Dot chart with 2 axis

C - Point chart

D - Box Plot

E - Pie

Answer : C

Answer : C

Explanation

Drill allows you to move to level up or level down as per the hierarchy in Universe.

To set Drill option In a WebI report, go to Analysis tab → Interact → Drill → Start Drill

sap_webi_questions_answers.htm
Advertisements